Skip to Content

How to filter current Year and Previous years in EPMContext Member

Hi Experts,

I am having EPMContextmember where i am having all time dimension members are coming ..

=EPMContextMember(,"Plan_Time")

But i need to have only current year and previous year time .

So any things with the filter can we have this ?

I do not want to see next year in the EPMContextMember..

Thanks,

ravi

capture.jpg (54.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 16, 2017 at 07:09 AM

    Unfortunately, filter in EPMContextMember is very limited!

    You can filter only for single value of YEAR property...

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 16, 2017 at 07:35 AM

    As an alternative you can use Excel in line drop down with a list of members generated using Excel formulas (Excel Data Validation).

    You will be able to select month from current and previous year! But you will not be able to change context in this case.

    Add comment
    10|10000 characters needed characters exceeded