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.
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)- A6% (1)
- B83% (15)
- C11% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.