Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reporting Question - Detail and Summary info in the same report

Hello All,

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

0MATERIAL

0MATL_GRP

0CURRENCY

Key Fig - 0AMOUNT

Data

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.

Amit Gupta

Former Member
Not what you were looking for? View more on this topic or Ask a question