Oracle
1Z0-960 · Question #61
You want to define a tree or hierarchy for use in reports and allocations. What three aspects should you remember when creating the tree?
The correct answer is B. You must flatten the columns and publish the tree to view the hierarchy in Essbase cubes. C. The tree should have at least two tree versions to reduce report and allocation maintenance. E. It is fine to have the same child value roll up to two or more different parent values. See the full explanation below for the reasoning.
Question
You want to define a tree or hierarchy for use in reports and allocations. What three aspects should you remember when creating the tree?
Options
- AYou need to flatten the rows to be able to use drilldown in Smart View and you must publishtree
- BYou must flatten the columns and publish the tree to view the hierarchy in Essbase cubes.
- CThe tree should have at least two tree versions to reduce report and allocation maintenance.
- DYou only need to flatten the columns if you plan to use the hierarchy in Oracle Transactional
- EIt is fine to have the same child value roll up to two or more different parent values.
How the community answered
(14 responses)- A21% (3)
- B71% (10)
- D7% (1)
Community Discussion
No community discussion yet for this question.