70-466 · Question #114
A sales cube contains two years of data. The sales team must see year-over-year (YOY) and month-over-month (MOM) sales metrics. You need to modify the cube to support the sales team's requirements…
The correct answer is A. Define time intelligence. Tests knowledge of which Business Intelligence Wizard enhancement in SSAS generates time-based relative calculations such as year-over-year and month-over-month metrics.
Question
Options
- ADefine time intelligence
- BDefine account intelligence
- CDefine dimension intelligence
- DSpecify a unary operator
- ECreate a custom member formula
- FSpecify attribute ordering
- GDefine semiadditive behavior
- HDefine currency conversion
How the community answered
(32 responses)- A94% (30)
- E3% (1)
- F3% (1)
Why each option
Tests knowledge of which Business Intelligence Wizard enhancement in SSAS generates time-based relative calculations such as year-over-year and month-over-month metrics.
The Define Time Intelligence enhancement in the Business Intelligence Wizard automatically creates MDX-based calculated members for common time comparisons including year-over-year (YOY) and month-over-month (MOM) metrics. It leverages an existing time dimension in the cube and generates the necessary named calculations without requiring manual MDX scripting.
Define account intelligence maps dimension members to standard account types such as asset or liability to control aggregation behavior - it does not create time-comparison metrics.
Define dimension intelligence assigns a semantic dimension type to enable special framework behaviors but does not generate time-comparison calculated members.
Specify a unary operator sets custom rollup behavior for parent-child hierarchies and is unrelated to time intelligence calculations.
Create a custom member formula adds MDX expressions to specific members but is a fully manual approach that requires writing MDX, unlike the wizard-driven time intelligence option.
Specify attribute ordering controls how dimension attribute members are sorted and has no relation to generating time-based comparative metrics.
Define semiadditive behavior specifies how measures aggregate across time dimensions - it does not create YOY or MOM comparison calculated members.
Define currency conversion configures exchange-rate-based measure conversions between currencies and is unrelated to time-over-time comparisons.
Concept tested: Business Intelligence Wizard time intelligence for YOY and MOM
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/define-time-intelligence-calculations-using-the-business-intelligence-wizard
Topics
Community Discussion
No community discussion yet for this question.