Skip to Content
-1
May 16, 2018 at 10:35 AM

BPC EPM 10.0 - Displaying data in a report using EPMDimensionOverride

188 Views

Hi BPC experts,

I would like to display rows on a report based on a member selection done on a parameter page. To do it, I use EPMDimensionOverride on the page axis report using "parameter page" as a reference in the formula.I have this kind of formula:

=EPMDimensionOverride("000";"[DIMENSION]";VLOOKUP[parameter])

In the parameter central page, the user might select ID but also hierarchical levels of a member.

E.g.: For dimension "Site" he may select "OS_AA" (the base level, ID of the dimension) or "GAA" (group society, parent of "OS_AA") or even a higher hierarchical level like "EMEA".

Here is the problem. For some reason, my report filters well when I select the ID in the parameter as well as some hierarchical levels like "GAA". But for "EMEA", I have no rows displaying... I am sure that EMEA is in the H1 where I also find "GAA" in this example.

Has someone already faced this kind of issue?

Thanks in advance,

Romain