on 04-01-2014 3:30 PM
In the EPM 10NW report, I need to exclude certain entity members from the display.
In the 'report editor' I am using the 'Exclude members' option in this regard.
These members are excluded from the report display, but still showing up in the hierarchy total in the display.
How to make sure that it is not showing up in hierarchy total.
Appreciate inputs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you are using the parent member to get the totals, then it will include the excluded members also; since parent member is calculated based on the hierarchy.
If you dont want the excluded members to be summed up, then you need to have the custom sum formula in your excel, adding up the members appearing in the template. This can be done using local member.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You could try simply creating a new hierarchy that does not include those particular entities. That would provide the report without excluding items and should also give you the total you are looking for. Let me know if this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, it might not be quite as elegant, but then I would suggest maybe creating a local member to subtract out the excluded entities and show the "correct" total that you would like to see. Will the excluded entities remain the same for a particular report? It sounds like each report might have different entities, but that the excluded entities would not change within a single report. Is that correct? Would this help you out?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.