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

[michael_hutchins2]

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.

[former_member186338]

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

Vadim

[michael_hutchins2]

So without using EVDRE, there's no way to achieve this?

[former_member186338]

I think that my answer is clear And I don't recommend using evdre, the support of evdre will be dropped...

[michael_hutchins2]

How do I suggest that SAP add this as an enhancement to the EPM Add-in? 

This is possible in EVDRE, but not possible in the EPM reporting, and I have multiple clients asking how to achieve this using the new EPM reporting.  I would think SAP needs to help find a solution for this type of report creation.

[former_member186338]

"How do I suggest that SAP add this as an enhancement to the EPM Add-in?" you can use SAP idea place: SAP Business Planning and Consolidation for SAP NW: Home

But not sure that you will have success - this idea doesn't perfectly fit the EPM report concept...

[michael_hutchins2]

Thanks Vadim,

I've added the idea on Idea Place...we'll see what happens.

I have to disagree as I think this idea fits perfectly with EPM functionality since it already exists in EVDRE.  SAP will never be able to phase out EVDRE if customer's can't get the same functionality using the EPM Addin for reporting.  Seems like a reasonably straight forward enhancement to consider allowing Keep Blocks on the inner vs outer expansion.

[former_member186338]

The idea of EVDRE (Excel formula based configuration) and EPM (Embedded Object configuration) are absolutely different inside. In EPM filtering is not linked with the particular dimension in column/row axis from the very beginning. And it's not an easy job to rewrite it now with additional complex interface and to provide version compatibility.

"EPM Add-in (EPM plugin) which comes together with Analysis Office 2.1 does not support the EVDRE function"

[Former Member]

Vadim,

I am confused as to how this feature is not available in BPC 10.  As a member of a planning/budgeting finance group our job is to make these processes as easy on the business as possible.  We currently provide budgeting/planning templates that allow for the business to list out tactics and/or general business plans with there expected costs (for tracking purposes), which the business wants to maintain.  Without this type of feature I do not know how I will ever be able to move away from our EVDRE based input reports (especially if we want to utilize BPC as the system of record, which it is designed to do with the save commentary options).

As BPC 10, allows for suppression will it be possible for future versions to allow suppression by dimension (or would this require to much additional coding)?

Is the only workaround to build a macro off a BPC 10 report that suppresses the two outer dimensions that creates a third report that the business uses for inputing tactics?

Thank you for your time,

Lucas

[former_member186338]

Hi Lucas,

I am not a SAP employee and I can't predict the implementation of any feature... My assumption (based on internal EPM code that can be decompiled): it will take time or will never happen...

In our company we have never required to perform suppression like you want in BPC 7.5 and do not need the same in BPC 10.

And for sure the vba code can be created to perform suppression (at least - hiding rows).

Vadim

[former_member186338]

VBA code (in AFTER_REFRESH):

Copy range (Account and Value, GetDataBottomRightCell) to the array.

Loop Array to identify number of accounts.

Loop records number of account times.

If block is zero - hide rows.