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