Skip to Content

Dynamic EPMSELECTMEMBER

Hello Experts,

I want to give cell reference in Filter section of EPMSELECTMEMBER function. But whenever I select member through EPMSELECTMEMBER the function gets Static.

Any help on this...

Thanks & Regards

Bhagyesh Ravange

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 23, 2015 at 07:53 AM

    Hi BHagyesh,

    To make it dynamic, you can pass the filter values in a cell and can give the cell reference in filter.

    Suppose you have Profitcenter ID in cell G13 then in G14 populate "PROFITCENTER="G13 Value and then pass G14 in Filter.

    Hope it helps.

    Thanks

    Astha

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Bhagyesh,

      Can you please specify the filters that you want to add in formula. The cell value "PROFIT_CENTER="G14 should be made by concatenating the values so that it can be read dynamically from the formula.

      Thanks,

      Astha

  • Oct 23, 2015 at 07:14 AM

    EPM SP?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2015 at 10:18 AM

    Thanks for the support... Its working now...

    Add comment
    10|10000 characters needed characters exceeded