nerdexam
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.

Full 70-448 Practice