Skip to Content

Searching in EPM Context Menu using part ID and part Description of Dimension


Is there any option to search an ID from Dimension context menu where I can search using a part of dimension ID and part of its description.

For Example:- In Account Dimension, there are 1000 GLs. I want to search an account which starts from 6611* and have a description as *Fee* somewhere in it. The modelling is such that GLs are selected using epmcontextmember() in the report/input template.

I am using BPC NW 10.0 and EPM addin SP25 Patch3 .net4.0 on MS-Excel 2013.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 15, 2017 at 08:59 AM

    Multiple conditions are not supported.

    "*" is not supported

    If you enter "Fee" - all members with Fee inside text will be shown.

    Add comment
    10|10000 characters needed characters exceeded

    • For sure you can create a property and use it as a filter of the list (but it's not related to your original question). The issue is additional maintenance of this property. Try to fill this property in transformation file when you load account master data.