You are developing a SQL Server 2008 Analysis Services (SSAS) solution for Company.com.
There is a key performance indicator (KPI) named PerKey in your solution.
You configure the Value expression of the KPI below.
[Measures].[Amount],[Account].[Accounts].[Operating Expenses] /[Measures].[Amount],[Account].[Accounts].[Gross Margin]
There is a time dimension called TestTime in your solution Multidimensional Expressions (MDX) statement are listed below
11 IIf(
12
13 ParallelPeriod
14 ( [TestTime].[Calendar].[Quarter],1,[ TestTime].[Calendar].CurrentMember
15 ) ), 2, -10 )
In order to configure a Trend expression of the KPI to show a difference in the values compared with the before quarter.In order to solve the problem, which is the correct answer?
A.
You should insert KPIValue( “GPMargin” ) > ( KPIValue( “GPMargin” ) at line 12,
B.
You should insert KPITrend( “GPMargin” ) <( KPIValue ( “GPMargin” ) at line 12,
C.
You should insert KPIStatus( “GPMargin” ) < ( KPIValue( “GPMargin” ) at line 12,
D.
You should insert KPIGoal( “GPMargin” ) => ( KPIValue( “GPMargin” ) at line 12,
Explanation:
Exam E