70-448 · Question #90
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…
The correct answer is A. You should insert KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ) at line 12. See the full explanation below for the reasoning.
Question
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( 13 ParallelPeriod 14 ( [TestTime].[Calendar].[Quarter],1,[ TestTime].[Calendar].CurrentMembe r 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?
Options
- AYou should insert KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ) at line 12,
- BYou should insert KPITrend( "GPMargin" ) <( KPIValue ( "GPMargin" ) at line 12,
- CYou should insert KPIStatus( "GPMargin" ) < ( KPIValue( "GPMargin" ) at line 12,
- DYou should insert KPIGoal( "GPMargin" ) => ( KPIValue( "GPMargin" ) at line 12,
How the community answered
(19 responses)- A74% (14)
- B5% (1)
- C5% (1)
- D16% (3)
Community Discussion
No community discussion yet for this question.