Skip to Content
0
Former Member
Dec 13, 2006 at 03:59 PM

Reporting on attr.of 0MATERIAL and 0MAT_PLANT + Trans. data in one report

40 Views

Dear all,

I have an issue here with a very simple requirement:

I have cube that contains both infoobjects 0MATERIAL and 0MAT_PLANT as well as some Key-Figures KF1 and KF2.

I want to report now on attributes from 0MATERIALand 0MAT_PLANT together with my KPIs

0MATERIAL ATTR1 ATTR2 0MAT_PLANT ATTR3 ATTR4 KPI1 KPI2

If I set the display option of 0MAT_PLANT to "no display" and filter on the site for 0MAT_PLANT, I get the desired result:

0MATERIAL ATTR1 ATTR2 ATTR3 ATTR4 KPI1 KPI2

Unfortunately I only can see the lines, for which I have data in the cube, but I want now to enlarge the report to show all(!) 0MATERIALS with the corresponding attributes (ATTR1 - ATTR4) for which I have masterdata.

How can I do so?

I already tried to add both infoobjects again to my mutliprovider and to use the constant selection filter with the option "Display values not posted", but the result was always something like

0MATERIAL1 ATTR1 ATTR2 0MAT_PLANT1 ATTR3 ATTR4

0MATERIAL1 ATTR1 ATTR2 0MAT_PLANT2 ATTR3 ATTR4

0MATERIAL1 ATTR1 ATTR2 0MAT_PLANT3 ATTR3 ATTR4

0MATERIAL2 ATTR1 ATTR2 0MAT_PLANT1 ATTR3 ATTR4

0MATERIAL2 ATTR1 ATTR2 0MAT_PLANT2 ATTR3 ATTR4

0MATERIAL2 ATTR1 ATTR2 0MAT_PLANT3 ATTR3 ATTR4

Any ideas?

Thanks,

Andreas