Skip to Content
0

LocalMember not shown

Apr 29, 2017 at 06:37 PM

44

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Apr 29, 2017 at 06:41 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Apr 29, 2017 at 06:58 PM
0

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)


lm.png (42.7 kB)
Share
10 |10000 characters needed characters left characters exceeded