EPMMEMBEROFFSET TIME RETURNS INCORRECT VALUE

[former_member623]

BPC 10.1 NW SP10 on HANA

BW 7.4 SP15

Epmmember offset for one particular member(2018.Total) returns incorrect value. all other members works fine in time dimension.

=EPMMemberOffset(,"2018.total",1,"year")

In dimension all property values looks correct for 2018.total. any idea what causing this issue?

[former_member186338 · Accepted solution]

Based on your screenshot you have incorrect root base member in your TIME dimension 2013.1

Delete it!

[former_member186338 · Accepted solution]

P.S. You can see that this wrong member is on the same level as TOTAL members and after 2018.TOTAL 🙂

[former_member623 · Accepted solution]

Thanks vadim. Deleting 2013.1 solved the issue.

[former_member186338]

"Epmmember offset for one particular member(2018.Total) returns incorrect value" - what is the incorrect value?

[former_member623]

its returning 2013.1