Reporting Question - Detail and Summary info in the same report
I have a situation where I have to report the detail and summary information from one cube (or multiple cubes) in a single report. Following is the example cube with smaple data and the required report
Cube - Char - 0CUSTOMER
Key Fig - 0AMOUNT
0CUSTOMER 0MATERIAL 0MATL_GRP 0AMOUNT 0CURRENCY
CUS1 MAT1 GRP1 1000 USD
CUS1 MAT2 GRP1 2000 USD
CUS1 MAT3 GRP2 3000 USD
CUS1 MAT4 GRP2 4000 USD
CUS2 MAT2 GRP1 2222 USD
If I run a report to See Which Customers have bought Material MAT1, I want to produce a report like
Material Cust Matl_Gr Amt(Matl) Amt(Cust/Mtgr) Amt(Cust)
MAT1 CUS1 GRP1 1000 USD 3000 USD 10000 USD
MAT1 CUS2 GRP1 2222 USD 2222 USD 2222 USD
Any Ideas to create such a report is welcome. I am open to use multiple cubes, Multicubes, summarized data joins etc.
Thanks in advance for the help.