Skip to Content
author's profile photo Former Member
Former Member

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


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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 21, 2016 at 06:46 PM

    Unfortunately it's a system behavior, you can't change it. Keep blocks is related to the outer dimension only.

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.