EPMContextMember does not reflect changes in range

[Former Member]

Hi,

I encountered a problem, when I change the "TIME" range to 2 years only (2014, 2015), instead of all.

EPM Function:

=EPMContextMember("","TIME",B4)

B4 Function:

="YEAR="&B5&";YEAR="&B6&";MonthNUM<>13;Period<>TOTAL;Calc=N;ID<>NA_TIME;"

B5 Function:

=YEAR(NOW())

B6 Function:

=YEAR(NOW())-1

Sometimes it reflects these changes and shows only 2014 & 2015 in the filter, sometimes it does not feed the data corectly and filter shows all years...

How can we ensure it always loads the data as was requested by the function please?

Thanks!

[Former Member]

Hi Peter,

1)     I think problem is in your formula

="YEAR="&B5&";YEAR="&B6&";MonthNUM<>13;Period<>TOTAL;Calc=N;ID<>NA_TIME;"

2)     When you mention connection name it should be same as it in the EPM bar "Active Connection".

3)     just try

  

you can hard code first value

Sushant

[Former Member]

Hi

also go through below link

sushant

[bhagyesh_ravange]

I have tested the same it work fine.. may be you need to provide Connection name in EPMFormula and fix the cell reference through $ sign..

[Shrikant_Jadhav]

Hi Peter,

Not sure about the exact reason but you can try this - provide connection name in formula, populate member offset using EPMMemberOffset formula and do not refer the cell where EPMContextMember("","TIME",B4) written to other cell.

Shrikant

[Former Member]

Tried this and did not help either:

=EPMContextMember("expense","TIME",""&B3)

=EPMContextMember("expense","TIME",B3)

It looks like function totally ignores the value in Cell "B3".

Is there any cache memory, which might cause the problem?

Thanks