Which MDX code segment should you insert at line 02?

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?

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?

A.
KPIValue( “GPMargin” ) > ( KPIValue( “GPMargin” ),

B.
KPITrend( “GPMargin” ) > ( KPIValue ( “GPMargin” ),

C.
KPIStatus( “GPMargin” ) > ( KPIValue( “GPMargin” ),

D.
KPIGoal( “GPMargin” ) > ( KPIValue( “GPMargin” ),



Leave a Reply 0

Your email address will not be published. Required fields are marked *