70-466 · Question #94
You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which SSAS feature should you use?
The correct answer is B. Translation. SSAS Translations allow dimension hierarchy metadata to be displayed in different languages or locales, meeting multi-region reporting requirements without changing the underlying data structure.
Question
Exhibit
Options
- ACalculation
- BTranslation
- CAction
- DPerspective
How the community answered
(62 responses)- A3% (2)
- B71% (44)
- C10% (6)
- D16% (10)
Why each option
SSAS Translations allow dimension hierarchy metadata to be displayed in different languages or locales, meeting multi-region reporting requirements without changing the underlying data structure.
Calculations define computed values or named sets using MDX expressions and do not affect how hierarchy names or labels are displayed to users.
Translations in SSAS allow you to define locale-specific names for dimensions, hierarchies, levels, and members. When the Sales Regions hierarchy must surface different labels for different regional audiences, a Translation object maps the metadata to the appropriate language or locale at query time without altering cube structure.
Actions define interactive behaviors such as URL navigation or drill-through when a user clicks on a cube cell or member, not metadata localization.
A Perspective creates a filtered subset view of a cube to reduce complexity, but it does not provide language- or region-specific naming for hierarchies.
Concept tested: SSAS Translation for multilingual dimension metadata
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/translations-in-multidimensional-models-analysis-services
Topics
Community Discussion
No community discussion yet for this question.
