You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube that uses a dimension named Product. The Product dimension contains an attribute named ProductName. You also create a URL action and set the action expression to “http://mycompany.com/ProductInfo.aspx?Product=”+Product.ProductName.CurrentMember.Na me You need to set the action target properties for the URL action. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

The project consists of a cube that contains the following objects:

A time dimension named DimTime that contains a hierarchy named Calendar. The first level of the hierarchy is named Year and the second level is named Quarter.

A dimension named DimProduct.
A fact table named FactInventory that stores the daily stock-in-hand measure for each product.

You need to set the AggregateFunction property to ensure that the cube displays the stock-in-hand measure for each product at the end of each quarter. Which value should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

The project has the following objects:

A cube named SalesData for a database named SalesDB.
Two dimensions named Region and Gender.
A role named Employee that has the Read permission set for the cube.

You need to modify the Employee role definition to allow the SalesData cube to be browsed only by using the Region dimension.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a cube that uses a dimension named DimProducts. The DimProducts dimension contains the following features: An attribute named Product. A column named ProductEnglishName for the

English name of the product. A column named ProductFrenchName for the French name of the product.

The NameColumn property of the Product attribute is set to the ProductEnglishName column. The language property of the cube is set to French.

You need to ensure that the cube displays the product names in French when you browse through the cube from a client that uses the fr-FR locale.

What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

Your data source has the following tables:

Scenarios table that contains columns named ScenarioKey and ScenarioName.FactFinance table that contains a foreign key column named ScenarioKey.

You need to create a calculated column in a data source view named ScenarioCalc in the FactFinance table to display the ScenarioName.

Which expression should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube named FinalAccounts.

The cube contains the following objects:

A measure named Balance under a measure group named Finance.
A dimension named DimAccount that contains an attribute named Account. The attribute contains two members named Operation Expense and Gross Margin.

A calculated member and named sets as shown in the following exhibit. (Click the Exhibit button.)

You create a Key Performance Indicator (KPI) by using a Gauge status indicator that calculates the ratio between the two attribute members. If the Operation Expense member is greater than the Gross Margin balance member, the Operation Expense member is in poor status.

You need to type the Multidimensional Expressions (MDX) expression for the Status expression of the KPI.

Which MDX expression should you use?

You are designing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a dimension named DimProducts that contains the following features:

An attribute named Categories.
A key attribute named Products that has a relationship to the Categories attribute.

A hierarchy that has the Categories attribute on the first level and the Products attribute on the second level.

When you browse through the dimension, it shows all the Products that do not have a relationship to the Categories attribute. The attribute is grouped under a Categories member named Unknown.

You need to ensure that only those products that have a relationship to the Categories attribute are displayed.
What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The cube must store details of the data in a relational format and the aggregations in a multidimensional format.
Which of the predefined ProactiveCaching values property should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

Your data source view has a table named Products. The Products table contains the following three columns:

ProductKeyCostDiscount

The table also contains a named calculation column named PercentageCost.
You need to add another column named DiscountedCost that will display the value of Cost*Discount/100.

What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. A database named CallCenterMetrics contains a data mining structure named Call Center Forecasting. The data mining structure implements the Microsoft Neural Network mining model and the Microsoft Clustering- based mining model. You need to change the parameters for both the mining models to narrow the number of rows that are returned from Microsoft Mining Content Viewer. What should you do?