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 10
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 0But 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 0I'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.
Unfortunately it's a system behavior, you can't change it. Keep blocks is related to the outer dimension only.
Vadim
Add a comment