You want to define a tree or hierarchy for use in reports and allocations.
What three aspects should you remember when creating the tree?
A. You need to flatten the rows to be able to use drilldown in Smart View and you must publish tree to view the hierarchy in Essbase cubes.
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.
D. You only need to flatten the columns if you plan to use the hierarchy in Oracle Transactional Business Intelligence (OTBI).
E. It is fine to have the same child value roll up to two or more different parent values.