You have a reporting requirement to track and report the employee status for employees in your workforce ASO Essbase database. Employee status can change over time. One report requires employees…

The correct answer is D. Attribute dimension. D: An attribute dimension is a special type of dimension that is associated with a standard Use attribute dimensions to report and aggregate data based on characteristics of standard dimensions. In the Sample.Basic database, for example, the Product dimension is associated with…

Creating and Managing Cubes

Question

You have a reporting requirement to track and report the employee status for employees in your workforce ASO Essbase database. Employee status can change over time. One report requires employees down the rows and employee status across the columns. What is the best solution to meet the all of the requirements?

Options

ASeparate Employee status dimension
BText List
CSmart List
DAttribute dimension
EVarying attribute dimension
FAlternate hierarchy
GUser defined attribute

How the community answered

(31 responses)

B
3% (1)
C
13% (4)
D
71% (22)
F
10% (3)
G
3% (1)

Explanation

D: An attribute dimension is a special type of dimension that is associated with a standard Use attribute dimensions to report and aggregate data based on characteristics of standard dimensions. In the Sample.Basic database, for example, the Product dimension is associated with the Ounces attribute dimension. Members of the Ounces attribute dimension categorize products based on their size in ounces. Essbase does not allocate storage for attribute dimension member. Instead, it dynamically calculates the members when the user requests data associated with them. Attribute dimensions are always sparse dimensions. And you can associate attribute dimensions only with sparse standard dimensions

Topics

#attribute dimension#varying attribute#ASO#dimension design

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice