on 02-02-2015 10:20 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew,
Can you show both local member formulas?
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi,
In our case its working fine. We are in SP16 patch 01. Please try in latest version of EPM Add-in.
Thanks,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew,
maybe play around with the option called keep formula on data, or keep formula static ref to report.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.