Skip to Content
-1

BPC EPM 10.0 - Displaying data in a report using EPMDimensionOverride

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 16 at 07:34 PM
    -1

    Sorry, but your requirements are not clear. Add screenshots and details!

    Add comment
    10|10000 characters needed characters exceeded

  • May 16 at 09:07 PM

    Do you have the same ID (EMEA) in other dimension(s)? Have you tried EPMMemberID

    Add comment
    10|10000 characters needed characters exceeded

  • May 17 at 01:19 PM

    Hi Vadim, Lucas

    Thanks for your revert

    I add more details :

    Hereafter an example of selection the user has to make in the local parameter tab :

    DimensionRole to selectCC_ORIGIN_CC_Site_directorsSITE_ORIGIN_S_EMEA_AreaTIME2018.02CURRENCYLocal CurrencyIn the restitution page, he gets:

    In cell C6, the formula is the following :

    =EPMDimensionOverride("000";"SITE_ORIGIN";RECHERCHEV('Local parameter'!C4&'Local parameter'!B4;Profiles_list[[PK]:[Member]];4;FAUX))

    RECHERCHEV is the french version of VLOOKUP.

    'Local parameter'!C4&'Local parameter'!B4 gives "_S_EMEA_AreaSITE_ORIGIN". The matching for this is "EMEA" in the table "Profiles_list" which is located in another tab in the same workbook.

    @Lucas:

    You are right, I have this ID "EMEA" in another dimension. I also though it could be a problem for the EPM formula to spot what I was looking for due to potential ambiguity. But the level 1 of the hierarchy (e.g. of member : GAA) is also present in another dimension and for this, it works.

    I did not try so far EPMMemberID, I test that and go back to you :)

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Nothing attached...

      Sorry, but looks like it's a waste of time...

      How it's possible to help you if you don't want to provide full and clear info?

      In general if you have some issue - then it's a bad idea to show this issue on the complex report!

      Create a simple test report to illustrate your issue and post it.