Question Re: How to filter current Year and Previous years in EPMContext Member in Financial Management Q&A

How to filter current Year and Previous years in EPMContext Member

Former Member — Thu, 16 Mar 2017 06:46:19 GMT

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

former_member186338 — Thu, 16 Mar 2017 07:09:32 GMT

Unfortunately, filter in EPMContextMember is very limited!

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

Former Member — Thu, 16 Mar 2017 07:22:21 GMT

Hi Vadim,

Year property filter, Can i have filter that in year Property It should be current year and Previous year only ?

Thanks,

Ravi

former_member186338 — Thu, 16 Mar 2017 07:25:30 GMT

I have already answered you: only single property value can be used in filter like:

=EPMContextMember(;"TIME";"YEAR=2017")

former_member186338 — Thu, 16 Mar 2017 07:35:31 GMT

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.