nerdexam
Microsoft

70-467 · Question #105

You need to ensure that queries to the Sales Analysis cube default to the correct time period. Where should you set the default member Multidimensional Expressions (MDX) expression?

The correct answer is B. In the cube's calculation script. The cube's MDX calculation script is the correct place to set a cube-specific default member for a time dimension, because it overrides dimension-level defaults and applies uniformly to all queries against that cube.

Design BI data models

Question

You need to ensure that queries to the Sales Analysis cube default to the correct time period. Where should you set the default member Multidimensional Expressions (MDX) expression?

Options

  • AIn the DefaultMember property of the Month attribute of the Date dimension.
  • BIn the cube's calculation script.
  • CIn the DefaultMeasure property of the cube.
  • DIn the Analysts role.

How the community answered

(18 responses)
  • A
    6% (1)
  • B
    83% (15)
  • C
    11% (2)

Why each option

The cube's MDX calculation script is the correct place to set a cube-specific default member for a time dimension, because it overrides dimension-level defaults and applies uniformly to all queries against that cube.

AIn the DefaultMember property of the Month attribute of the Date dimension.

Setting DefaultMember on the Month attribute of the Date dimension applies the default at the dimension level and affects every cube that uses that dimension, not just the Sales Analysis cube, which can cause unintended side effects.

BIn the cube's calculation script.Correct

Placing the default member MDX expression inside the cube's calculation script using an ALTER CUBE or CALCULATE statement with a DEFAULT_MEMBER assignment makes the default cube-specific and evaluated at query time within that cube's context. This overrides any attribute-level DefaultMember settings and ensures the correct time period is applied for all users and roles querying the Sales Analysis cube without affecting other cubes that share the same Date dimension.

CIn the DefaultMeasure property of the cube.

The DefaultMeasure property controls which measure is returned when none is specified in a query - it has no effect on which time dimension member is selected by default.

DIn the Analysts role.

Setting the default member inside the Analysts role restricts the default to users assigned that role only, meaning other users or roles querying the cube would not receive the correct default time period.

Concept tested: SSAS cube calculation script MDX default member

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/mdx-query-the-basic-query

Topics

#default member#MDX expression#cube calculation script#time dimension

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice