Skip to Content
avatar image
Former Member

Filter Member by properties via Member Selector in EPM 10

Hi Gurus,

I need a help about filter member by properties in member selector window. I want to restrict members automatically. For reducing incorrect inputs, when users choose A dimension's member, system have to restrict B dimension's member with A property automatically. Is there anyway to solve this issue?

Best regards

Haşim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 14, 2012 at 02:00 AM

    Hi,

    This cannot be done using the member selector. You need to use the dimensionoverride function for this.

    In cell A1, use the context function to get the context member of the A dimension.

    In the cell A2, use the dimensionoverrride function using the correct property value.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Luciana Zavalaga

      Old post but I think you need concatenation for your EPMContextMember:

      =EPMContextMember(,"MATERIAL","GRUPO="&EPMContextMember(,"CUENTA"))

  • Sep 13, 2012 at 07:34 PM

    Hi Hasim,

    I don't believe you can automatically do this in the EPM Add-In.

    Are you saying you have the Time and Category dimensions in your column key axis, choose the ACTUAL category then only the Time members that have a specific property value (i.e. IN_ACTUAL = Y ) would appear in the member list?

    You do have this option when building reports but not when actually choosing members from the member selector.

    There is also the EPMContextMember which allows for a third paramater called:

    filter - Filter by property to return only members with specified property values. Optional.

    EPMContextMember("Finance","Entity","CALC=N;GROUP=SALES") ( from the EPM Add-in Help guide )

    HTH,

    John 

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi John,

      Thank you for quick response. Actually, one dimension is in the row axis (costcenter), other is in page axis(bus_area). When user choose bus area, they do not want to see all costcenters. Only they want to see costcenters with chosen bus_area property in member selector. I can't find any method about this. And also they will select costcenter. It means I can't use EPMDimensionOverride formula because in input schedule, all costcenters are not drilled, only one will be shown. What can I do?

      Best regards

      Haşim