Company hierarchy is split in to 3 regions.( A,B,C)
Under each regions there are 10 company each (approx).
Reprting requirement is such that on each region client wants to drilldown uniquely and see the data either by product, or functional area or business area.
For example, under A regions there is 10 company code. A is total sale is 10 million and customer wants to drilldown the detail and see the totsl specifically by business area.
Similarly B region total need to be drilldown only by functional area and the total composition seen only by this.
Similarly C region product details.
How to achieve this navigational drill thru data modeling or what will help this.
Any clarification appreciated?