70-466 · Question #97
You need to modify the Sales cube to support the planning requirements. Which SSAS feature should you use?
The correct answer is C. A writeback partition. SSAS writeback partitions allow end users to write values directly into the cube, which is the core requirement for planning and budgeting scenarios.
Question
Options
- AA KPI
- BA translation
- CA writeback partition
- DA perspective
How the community answered
(37 responses)- A11% (4)
- B3% (1)
- C81% (30)
- D5% (2)
Why each option
SSAS writeback partitions allow end users to write values directly into the cube, which is the core requirement for planning and budgeting scenarios.
A KPI defines visual indicators and goal thresholds to measure business performance; it is read-only and cannot accept user input for planning.
A translation provides localized metadata names for cube objects and has no bearing on data entry or planning data capture.
A writeback partition converts a measure group partition so that cube cells become editable, enabling users to enter forecast, budget, or plan values directly. This write-enabled capability is specifically designed for planning workflows where users must push data into the cube and have it reflected in aggregations.
A perspective exposes a curated subset of cube objects to simplify the user experience but does not enable any write-back or data entry capability.
Concept tested: SSAS writeback partition for planning and budgeting
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/set-partition-writeback
Topics
Community Discussion
No community discussion yet for this question.