How to display master data with and without transaction data

[petr_halamicek2]

Hi all,

I have GL account with attributes and transaction data in cube.

1 of the GL attribute is navigation attribut.

GL accounts which contain data in cube should be displayed with attributes and transaction data in report.

GL accounts which are missing data in cube should be displayed only with attributes values (although there is no data in cube).

I am not sure how to display GL master data in report without records in cube.

How could I do it? Should I create multiprovider on GL account and cube?

Will it work when 1 of the attributes is navigation attribute?

Any idea is very welcome.

Thank you very much.

[Former Member]

Hi Petr,

You can create infoset with left outer join on glaccount and infocube to achieve this. Check below link

Creating InfoSets - Modeling - SAP Library

[ccc_ccc]

Hi Peter,

Yes, we can do with the property "Values in master table" of GL Account .

Thank you,

Nanda