Skip to Content
0

How to filter current Year and Previous years in EPMContext Member

Mar 16, 2017 at 06:46 AM

64

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Mar 16, 2017 at 07:09 AM
0

Unfortunately, filter in EPMContextMember is very limited!

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

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

Thanks,

Ravi

0

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

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

0
Vadim Kalinin Mar 16, 2017 at 07:35 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded