Which three statements are true about multiple hierarchies in ASO?

The correct answer is A. First hierarchy must be stored. B. Multiple hierarchies must be enabled by dimension. E. Alternate hierarchies may be either dynamic or stored. A: The member representing the first hierarchy (top level member of the hierarchy) in a dimension that has multiple hierarchies must be tagged as a stored hierarchy. Analytic Services requires such a hierarchy to be a stored hierarchy. B: To use multiple hierarchies in a…

Creating and Managing Cubes

Question

Options

AFirst hierarchy must be stored.
BMultiple hierarchies must be enabled by dimension.
CFirst hierarchy must be dynamic.
DAll alternate hierarchies must be dynamic.
EAlternate hierarchies may be either dynamic or stored.

How the community answered

(28 responses)

A
82% (23)
C
11% (3)
D
7% (2)

Explanation

A: The member representing the first hierarchy (top level member of the hierarchy) in a dimension that has multiple hierarchies must be tagged as a stored hierarchy. Analytic Services requires such a hierarchy to be a stored hierarchy. B: To use multiple hierarchies in a dimension, you must enable multiple hierarchies for that E: Alternate hierarchies may be either dynamic or stored.

Topics

#multiple hierarchies#ASO#stored hierarchies#dynamic hierarchies

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice