SAP
C_HANAIMP_18 · Question #8
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.
The correct answer is B. The hierarchy must be exposed by a calculation view of type CUBE with star join. D. The hierarchy must be a shared hierarchy. See the full explanation below for the reasoning.
Question
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.
Options
- AThe hierarchy must be defined in a calculation view of type SQL ACCESS ONLY.
- BThe hierarchy must be exposed by a calculation view of type CUBE with star join.
- CThe hierarchy must be a local hierarchy.
- DThe hierarchy must be a shared hierarchy.
How the community answered
(34 responses)- A9% (3)
- B71% (24)
- C21% (7)
Community Discussion
No community discussion yet for this question.