Microsoft
70-448 · Question #90
70-448 Question #90: Real Exam Question with Answer & Explanation
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,
Community Discussion
No community discussion yet for this question.