Residual data on report after suppress

[Former Member]

EPM 10 SP 10 NW

I have a report with zero suppression on rows. Also i have two columns as local members in columns one for epmsavecomments formula while the other column is for comment entry.

As the report expands the comments formula replicates allowing user to enter and save columns in the corresponding cell next to it.

Issue: When report expands to 10 rows , user enters 10 comments.  On selection change if the report renders only 3 data rows, additional 7 comments from earlier rendering still remains on the report after refresh.

How do you configure to clear those redundant comment cells as the report expand and shrink based on report data .. i am sure i must be missing some configuration setting on the report.

Please see attachment for details

~Dilkins

[meenubansal87 · Accepted solution]

Hi Andrew,

Make sure you are taking 2 local members. As per my knowledge, the comments exist after shrinks down the report rows because you are taking an excel column to enter comments instead of local members. Local member is dynamic which varies with the report.

If this is not the case, please check sheet-options "keep formulas static that reference report cells" is unchecked.

Regards,

Meenu

[Former Member · Accepted solution]

Thank you Meenu.  That was the problem.

~Dilkins

[former_member186338]

Hi Andrew,

Can you show both local member formulas?

Vadim

[former_member186338]

Just tested - no issues:

Local member setup:

First selection - 8 lines, all comments filled and saved!

Second selection - 3 lines - no residual data!

Vadim

[former_member186338]

Ups, tested the same with empty/zero suppression - same result, no residual data!

[Former Member]

Thank you Vadim. After investigation, it appeared that the definition of my second local member was not enabled hence causing the issue.

But, your sample was very helpful as i noticed better way of referring to the connection and row axis member.

When i tried to implement the same in the local member formula, as soon i change it to (USRENTRY is a second local member)

=EPMSAVECOMMENT(EPMMEMBER(USRENTRY),EPMMODELCUBEID(),...)

the local member is removed from the report as it is not recognizing EPMMEMBER(USRENTRY)

Any idea?

~Dilkins

[former_member186338]

The syntax is not EPMMEMBER(USRENTRY), but EPMMEMBER(000) or EPMMEMBER(001)

Please test some simple local member with just =EPMMEMBER(000)

Vadim

[Former Member]

Vadim,

Thanks for the suggestion. but that gave same result. What does 000 represent?  Column number or the order of the Local member on the report? One difference i noticed is, in your template you used the default local member id Localmember000 while i defined my name as USRENTRY. How does it change the usage.

~Dilkins

[former_member186338]

000 - is the first local member (001 - second, etc...)

You can reference it in the formula of the second local member.

You can't reference second local member in the first local member!

Local members are created in the order on the left of the Local Member form.

Vadim

[former_member186338]

Sample: Local member LM002 is referencing to first local member LM (Description - Test1):

Vadim

[Former Member]

Thank you Vadim. Perfect.

[former_member190501]

Hi,

In our case its working fine. We are in SP16 patch 01. Please try in latest version of EPM Add-in.

Thanks,

Raju

[Former Member]

Hi Andrew,

maybe play around with the option called keep formula on data, or keep formula static ref to report.

Andy