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?
A.
IIF( [Measures].[Expenses] <= [Measures].[Margin] , [Measures].[Expenses] / [Measures].[Margin] , [Measures].[Net Profit Percentage]*-1 )
B.
IIF([Measures].[Expenses]<=[Measures].[Margin],[Measures].[Expenses]/[Measures].[Margin],[Mea sures].[Net Profit Percentage])
C.
IIF([Measures].[Expenses]>= [Measures].[Margin],[Measures].[Expenses]/[Measures].[Margin],[Measures].[Net Profit Percentage]*-1)
D.
IIF([Measures].[Expenses]>=[Measures].[Margin],[Measures].[Expenses]/[Measures].[Margin],[ Measures].[Net Profit Percentage] )