EPMContextMember filter syntax

[Former Member]

Hi

We're on EPM ADD IN SP20

BPC 10 NW

I try to put a filter in EPMContextMember formula

it's work for =EPMContextMember(;"TIME";"YEAR = 2009"&";"LEVEL = MONTH")

I need YEAR > to 2014

IF I put "YEAR > 2014" I received message : The format of the user defined 'Year >2009;LEVEL = MONTH' is invalid

What is wrong in the syntax ?

Regards

[former_member190501 · Accepted solution]

Hi,

Context member formula does not work with >,<,<>,between and like.

As Andy said hard code years in the formula.

Thanks,

Raju

[former_member186338 · Accepted solution]

Comment about hard coding:

=EPMContextMember(;"TIME";"LEVEL=MONTH;YEAR=2014;YEAR=2015;YEAR=2016;YEAR=2017;YEAR=2018;YEAR=2019";TRUE)

Simply add enough years to the string! Even if you don't have the years defined as members it will work.

Vadim

[former_member186338]

Hi Frederic,

Please explain, what do you want to achieve!

Vadim

[cecilia_petersson2]

Hi Frederic,

A slightly different approach is to create property IS_EXCL_YEAR for Time and set it to 1 for all periods that are 2009 or earlier. Then you just replace YEAR=2009 with IS_EXCL_YEAR<>1.

/Cecilia

[Former Member]

Hi Frederic,

I don't think you can use > in the context formula.

depends on your requirement I'm sure there is a way around it.

we typed out the years we want to display ref them in the context formula.

Andy