How to filter current Year and Previous years in EPMContext Member

[former_member187267]

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]

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.

[former_member186338]

Unfortunately, filter in EPMContextMember is very limited!

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

[former_member187267]

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]

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

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