Skip to Content
avatar image
Former Member

How to display master data with and without transaction data

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 07, 2015 at 06:11 PM

    Hi Peter,

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

    Thank you,

    Nanda


    test.png (11.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2015 at 09:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded