Skip to Content

LocalMember not shown

Hi experts.

I have a report with this structure:

The option of the report is not to shown empty o 0 value rows, so the expantion is dinamically. The problem is that the local member with the sums are not shown.. For example , if there´s no data on Account B , then the local member with the sum is not shown.

Any suggestions?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 29, 2017 at 06:41 PM

    Local members are linked to the members on the report. If the linked member is missing - local member is not shown.

    In general it's better to use parent of ENTITY xxx to show on the report!

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 29, 2017 at 06:58 PM

    In your particular case you can attach the local member after the inner dimension - ENTITY:

    In my sample COMPANY_CODE=ENTITY

    P.S. And to get a Grand Total insert another local member after row axis:

    =SUM(EPMALLMEMBERS)

    Add comment
    10|10000 characters needed characters exceeded