1Z0-531 · Question #5
Your current block storage option design includes two dimensions: Markets and Regions. The Market dimension looks like: Users need to be able to report by both regions and markets. Subtotals for…
The correct answer is C. Create a UDA with members Northeast and Southwest (associated to states in the Market dimension). Essbase supports this concept called UDA's wherein one can assign the same attribute to multiple dimension members so that one can do cross dimensional attribute analysis. For example, if you take the default Sample-> Basic database you would notice that the Market Dimension…
Question
Your current block storage option design includes two dimensions: Markets and Regions. The Market dimension looks like:
Users need to be able to report by both regions and markets. Subtotals for Northeast and Southwest will display on some reports.
Exhibit
Options
- AAdd another level to the market dimension for Northeast with North and East as children and Southwest
- BAdd an alternate hierarchy to the market dimension with the states as shared members, rolling up to
- CCreate a UDA with members Northeast and Southwest (associated to states in the Market dimension)
- DCreate an attribute dimension with members Northeast and Southwest (associated to states in the
- ECreate a Text list with the values containing the members Northeast and Southwest.
How the community answered
(24 responses)- A8% (2)
- B4% (1)
- C83% (20)
- E4% (1)
Explanation
Essbase supports this concept called UDA's wherein one can assign the same attribute to multiple dimension members so that one can do cross dimensional attribute analysis. For example, if you take the default Sample-> Basic database you would notice that the Market Dimension members would have some UDA's assigned to it like Major Market, Small Market etc. Note: user-defined attributes (UDAs).
Topics
Community Discussion
No community discussion yet for this question.