Skip to Content
avatar image
Former Member

BPC Report Dimension Value Based On Other Dimension

Hi all,

I want to create a report with a dimension members based on other dimension members, example :

Here is 2 dimension with their members :

The reports :

Dim2 list of members display is based on Prop2 property with value from Dim1 ID.

D2_1 or D2_2 member will not show with D1_2 member.

D2_3 or D2_4 member will not show with D1_1 member.

I want to create a report like this. Few years ago with EPM Add-In, I done it (if I am not mistake). Now I am using AO, but I couldn't find the way.

Thanks.

u29nh.png (4.3 kB)
tiaz4.png (2.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 20, 2017 at 06:49 AM

    If you are using EPM in AO then the same as with standalone EPM:

    Add comment
    10|10000 characters needed characters exceeded

    • You can't use Dimension override for PRODH dimension!

      You are mixing things...

      You can use dimension override for Material dimension only!

      Then the corresponding PRODH member will be selected based on property of Material dimension.

  • avatar image
    Former Member
    Mar 21, 2017 at 02:04 AM

    Mm, I need to find other way for this.

    Btw, I want to combine the selection with calc=N, but I cannot find the ampersand symbol which is has in EPM Add-In.

    In EPM Add-In, the ampersand (&) symbol can be set in operator column:

    Do you know how to set in AO ?

    Add comment
    10|10000 characters needed characters exceeded

    • You can't combine linked to property with any other criteria using AND! And it was not possible in old EPM add-in. You will get empty result.

      To combine other conditions you can use Merge button on the right (under X button)

  • Mar 21, 2017 at 08:18 AM

    In general the only possible solution is:

    1. Create additional report (as default report) with PRODH in rows and EPMDimensionOverride("000","PRODH","BAS(XXX)") to get required base member list.

    2. Create a local member in this report to concatenate string:

    PRODH=X1,PRODH=X2,PRODH=X3 etc... - in the first row of the report (for example cell B5)

    3. In your real report 001 use

    EPMDimensionOverride("000","MATERIAL",B5)

    Add comment
    10|10000 characters needed characters exceeded