What are the three rules for Shared Members in ASO?

The correct answer is A. A Multiple Hierarchy Enabled dimension can have shared members. C. The alternate hierarchy has shared members that refer to nonshared members of previous hierarchies D. The shared members roll up according to a different hierarchy from the nonshared members to which. Shared member hierarchy is also an alternate hierarchy. All shared member refers to stored members of outline (C). In aggregate storage application only multiple hierarchies can have shared members. (A) Stored hierarchy has only addition as consolidation operator. You can use…

Creating and Managing Cubes

Question

Options

AA Multiple Hierarchy Enabled dimension can have shared members.
BWhen a hierarchy is tagged Multiple Hierarchies Enabled, it must be store.
CThe alternate hierarchy has shared members that refer to nonshared members of previous hierarchies
DThe shared members roll up according to a different hierarchy from the nonshared members to which

How the community answered

(34 responses)

A
76% (26)
B
24% (8)

Explanation

Shared member hierarchy is also an alternate hierarchy. All shared member refers to stored members of outline (C). In aggregate storage application only multiple hierarchies can have shared members. (A) Stored hierarchy has only addition as consolidation operator. You can use the stored hierarchy type where aggregation is the only mathematical requirement. If you have some shared member in hierarchy then use multiple hierarchy.

Topics

#shared members#ASO rules#multiple hierarchies enabled#alternate hierarchies

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice