Microsoft
70-448 · Question #270
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a key performance indicator (KPI) named GPMargin for your solution. You set the Value expression of the KPI in the…
The correct answer is A. KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ). See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a key performance indicator (KPI) named GPMargin for your solution. You set the Value expression of the KPI in the following manner. You need to set a Trend expression of the KPI to show a difference in the values compared with the previous quarter. Which MDX code segment should you insert at line 02?
Exhibit
Options
- AKPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ),
- BKPITrend( "GPMargin" ) > ( KPIValue ( "GPMargin" ),
- CKPIStatus( "GPMargin" ) > ( KPIValue( "GPMargin" ),
- DKPIGoal( "GPMargin" ) > ( KPIValue( "GPMargin" ),
How the community answered
(40 responses)- A83% (33)
- B10% (4)
- C5% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.