Which of the following conditions must be met?

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.

Which of the following conditions must be met? Note: There are 2 correct answers to this question.
A . The hierarchy must be exposed by a calculation view of type CUBE with star join.
B. The hierarchy must be a shared hierarchy.
C. The hierarchy must be a local hierarchy.
D. The hierarchy must be a parent-child hierarchy.

View Answer

Answer: A,B