EPM Report - Node without few members

[sap_user62]

Hi Friends,

EPM Addin - 10.1/SP28

The data in our existing reports is at node level -

Example Account- Revenue Node in row and time in Column

We have a temporary requirement to show the account node-Revenue but it should not show data for certain accounts(new) in the node. Those excluded accounts will be filtered by a property in account dimension - called account group. This account group property is only populated to the base level account members.

In the report editor if I add dynamic filter like Revenue - Member only + account group <> "XXXX" then it does not exclude those accounts, as Revenue node by itself does not have any acct group

If I add Revenue - Base level + account group <> "XXXX" then I get the data I want, but I get all the base level members.

Users want to see one line Revenue (excluding the accounts) not all base level accounts in the report.

Is there a way other than creating another report with base llevel and referencing to the cells.

Thanks for your time.

[former_member186338 · Accepted solution]

Create a new parent, may be in a new hierarchy!

It's the only way!

[sap_user62]

I was not able to create a new hierarchy as most of the standard reports that business uses are static with account nodes hard coded in reports.

However we decided to remove the accounts which we do not need out of the hierarchy, and they will stay as orphans for some time, to simply reporting needs.

Ed

[former_member186338]

Will do the job!

[sap_user62]

Thanks Vadim for your reply.

I have attached a sample report which shows Revenue in the rows and time in the column

Screen shot of dynamic selections with Account -Member only (dynamic selection Member Only.png) -- This selection does not exclude the accounts with the acc_group = rrev.

Screen shot of dynamic selections with Account-base level(Dynamic selection - Base Level + Account Group.png) - This selection excluded the accounts which belong to account group - rrev

Final outcome of Dynamic selection - Base Level + Account Group.png is the "resultset after dynamic selection of base level and account group.png" . If we see the final outcome, it has all the base level information.

I need a way to show only Revenue accounts total (single line) excluding the accounts which belong to acc_group = rrev.

[former_member186338]

Still not clear!

"I need a way to show only Revenue accounts total (single line) excluding the accounts which belong to acc_group = rrev"

Create a new parent?

[sap_user62]

Thanks Vadim for your reply.

Still not clear! --- requirement is show a account node in the report excluding few accounts which have an account group of rrev.

Create a new parent? -- The accounts which need to be excluded are spread across the entire revenue hierarchy in multiple places.

This is only a temporary requirement, as a major project and year end reporting have clashed timings.

We have multiple reports that need to be remediated for this activity.

[former_member186338]

Sorry, but absolutely not clear! Please start again with sample report screenshots!