BPC EVDRE - Supression on Multiple Expansions

[Former Member]

Hello world wide web... please help!!!

I am trying to build a financial business report in excel using the BPC evdre function.

Issue

I am not getting the desire result from my SUPRESS value settings in my PARAMETER: EXPANSIONS.

Overview:

• I have places my general ledger accounts set as ROW values.  They are permenant and no expandsion set for them.
• I have three types of expandsions set as COL values:
  • GEOORG - Geographic location
  • MEASURES - Peiodic (Mth to Date) and YTD (Yr to Date)
  • CATEGORY - Actual, Forecast, Budget

Desired Outcome

• Supress all GEOORGs that have no data at all
• Show all GEOORGs if any data is available, even if one of the secondary expansionsions are showeing all -0-.  For example: UK has Budget and Forecast data, but no actual.  I would like to see all three Categories with Actual populated with -0-

Actual Outcome

• GEOORGs with no data at all are poroperly supressed
• Secondary expansions (MEASURES / CATEGORY) supress any areas that contain -0- data.  For example: UK has Budget and Forecast data, but no actual.  UK shows Budget and Forecast data, but Actual is Supressed.

I have provided pictoral views of the examples, my settings and the desired outcome.

Any assistance, as soon as possible, would be greatly appreciated.

Thanks,

Chris

[Former Member]

Does anyone know how I can get this question answered?