Skip to Content
avatar image
Former Member

EPM 10.0 SP27 EPM Member Selector issue

Hello,1-epm-member-selector.png2-epm-member-selector.png

I have installed EPM 10.0 SP19 and in another machine EPM 10.0 SP27 and the result is the same in both solutions.

I have to expand members of a dimension using the EPM Member selector and filtering by a property of the dimension to expand that is driven by the context. I have to expand the products in rows that have the property Business Unit equal to the member of the dimension Business Unit that is selected in the context.

Attached you can see the result

Can you Help me?

Marta

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Apr 19, 2017 at 02:44 PM

    Just tested!

    Working absolutely fine!

    May be you have context selection not matching any property value?

    P.S. In my sample I am using COST_CENTER dimension having BPC_COMPANY_CODE property. And valid COMPANY_CODE dimension member is selected in the context.

    In the report all COST_CENTER members with the property BPC_COMPANY_CODE equal to context member of COMPANY_CODE dimension are shown!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 20, 2017 at 03:53 PM

    sample-edit-report-dimensions.jpgsample-edit-report-property-filter.jpgsample-report.jpg

    Hello Vadim,

    I've tried to develop a very simple report with a dimension in row and another one in column as you suggested and attached the result; The EPM Member selector doesn't work properly.

    Maybe I have to set something? Do you have any idea?

    Thank you

    Marta

    Add comment
    10|10000 characters needed characters exceeded

    • Please show that you really have members in SOP_FAMILY with property BUSINESS having value EN

      Screenshot of SOP_FAMILY dimension administration will help!

      If you don't have this property value then your report will fail.

      Have to repeat - my test report is working absolutely as expected.

  • avatar image
    Former Member
    Apr 21, 2017 at 01:27 PM

    Attached the image of SOP Family dimension: the SOP Family EN135 has the property BUSINESS = EN

    Thank you

    Martasop-family-dimesnion.png

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 21, 2017 at 02:08 PM

    Just to test property:

    Use a simple report with any selection for

    SOP_ACCOUNT

    Add in some cell:

    =EPMDimensionOverride("000","SOP_ACCOUNT","BUSINESS=EN")

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2017 at 06:15 PM

    I have found the issue preventing you to use property to CONTEXT filter.

    You have to set "Display as ID" in the context member selection!

    And on your screenshot I see that context is shown as ID - Description!

    In order to be independent of Display option you can do the following:

    In A1 you have page axis member of BUSINESS dimension.

    In B1 put formula: =EPMMemberProperty(, EPMMemberID(A1), "ID")

    Name B1 as a range ___BUS

    Configure filter for SOP_FAMILY as:

    Property

    BUSINESS = ___BUS

    Done!

    Add comment
    10|10000 characters needed characters exceeded