nerdexam
Microsoft

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)
  • A
    74% (14)
  • B
    5% (1)
  • C
    5% (1)
  • D
    16% (3)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice