Skip to Content
0
Former Member
Jun 21, 2016 at 05:12 PM

How do I suppress 2 outer dimensions but keep block of 3rd dimension on row?

162 Views


Hello experts,

I've been trying to create a report using the EPM 10 reporting that keeps the block of Accounts on the inner dimension, but suppresses based on the Profit Center and Product for the outer dimensions. So if there are values in any account 1 thru 3 for any Profit Center and Product combination then show all 3 accounts. Otherwise if there are no values in any account in the block, then don't show the Profit Center and Product combination. This is simple to do using an EVDRE but I cannot find a way to do it using the EPM reporting capability. See example below:

In my example, first you'll see a simple example of the data without the suppression

ProfitCenter Product Account 2016.Total PC1 Product 1 Account 1 500 Account 2 400 Account 3 0 Product 2 Account 1

0

Account 2

0 Account 3 0 PC2 Product 1 Account 1 0 Account 2 0 Account 3 0 Product 2 Account 1 100 Account 2 0 Account 3 0 PC3 Product 1 Account 1 0 Account 2 0 Account 3 0 Product 2 Account 1 0 Account 2 0 Account 3 0

But I'd like my report to show this. Keeping the Account Block and suppressing outer 2 dimensions:

ProfitCenter Product Account 2016.Total PC1 Product 1 Account 1 500 Account 2 400 Account 3 0 PC2 Product 2 Account 1 100 Account 2 0 Account 3 0

I've tried the Keep Blocks functionality on the Filter tab when editing the report with no success. Any suggestions on how to achieve this?

FYI we are current using EPM 10.0 classic on NW with Hana Enabled.