You are designing a complex report that displays sales metrics for a customer hierarchy. The customer hierarchy has six levels and contains approximately 1 million members.
You have the following requirements:
- Allow users to easily display and navigate data.
- Minimize report processing time.
- Simplify the report design and maintenance processes.
You need to design a report that meets the requirements.
How should you design the report? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Retrieve all customers and use drilldown groupings to show or hide hierarchy levels.
B. Add a report part for each hierarchy level.
C. Add a subreport for each hierarchy level.
D. Display only the children of the current hierarchy level and drill through to the selected member.
