nerdexam
Microsoft

70-466 · Question #79

You need to create the KPI in the AdhocReports project. What should you do?

The correct answer is A. Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCLUBE statement to define the KPI and target value.. This question tests the correct MDX syntax and workflow for defining a KPI in SSAS, requiring a base measure before the KPI definition statement.

Build a tabular data model

Question

You need to create the KPI in the AdhocReports project. What should you do?

Options

  • ACreate a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCLUBE statement to define the KPI and target value.
  • BCreate a measure by using the SUM(OrderQuantity) expression and create a KPI based on the measure. Then set the target value.
  • CCreate a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
  • DCreate a KPI based on the OrderQuantity column and then set the target value.

How the community answered

(47 responses)
  • A
    70% (33)
  • B
    17% (8)
  • C
    4% (2)
  • D
    9% (4)

Why each option

This question tests the correct MDX syntax and workflow for defining a KPI in SSAS, requiring a base measure before the KPI definition statement.

ACreate a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCLUBE statement to define the KPI and target value.Correct

In SSAS Multidimensional, a KPI must be based on a valid measure defined with correct MDX syntax, and SUM([OrderQuantity]) with bracketed column reference is valid MDX. The CREATE KPI CURRENTCUBE statement is the correct MDX command to programmatically declare a KPI and associate a target value within the cube context.

BCreate a measure by using the SUM(OrderQuantity) expression and create a KPI based on the measure. Then set the target value.

SUM(OrderQuantity) omits the required MDX brackets around the column name, producing invalid MDX syntax that would fail at parse time.

CCreate a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.

Using COUNT([OrderQuantity]) counts the number of rows rather than summing quantities, which produces an incorrect value for an order quantity KPI.

DCreate a KPI based on the OrderQuantity column and then set the target value.

SSAS KPIs cannot be based directly on a raw column - a measure must be created first before a KPI can be defined, making this approach invalid.

Concept tested: Creating SSAS KPI with MDX measure and CREATE KPI CURRENTCUBE

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/key-performance-indicators-kpis-in-multidimensional-models

Topics

#SSAS KPI#DAX measures#SUM expression#tabular KPI creation

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice