nerdexam
Microsoft

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.

Build an analysis services database

Question

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. Which Business Intelligence Wizard enhancements should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

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)
  • A
    94% (30)
  • E
    3% (1)
  • F
    3% (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.

ADefine time intelligenceCorrect

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.

BDefine account intelligence

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.

CDefine dimension intelligence

Define dimension intelligence assigns a semantic dimension type to enable special framework behaviors but does not generate time-comparison calculated members.

DSpecify a unary operator

Specify a unary operator sets custom rollup behavior for parent-child hierarchies and is unrelated to time intelligence calculations.

ECreate a custom member formula

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.

FSpecify attribute ordering

Specify attribute ordering controls how dimension attribute members are sorted and has no relation to generating time-based comparative metrics.

GDefine semiadditive behavior

Define semiadditive behavior specifies how measures aggregate across time dimensions - it does not create YOY or MOM comparison calculated members.

HDefine currency conversion

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

#time intelligence#Business Intelligence Wizard#year-over-year#month-over-month

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice