Skip to Content

EPMMEMBEROFFSET TIME RETURNS INCORRECT VALUE

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?

timedim.png (77.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 21, 2017 at 08:21 PM

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

    Delete it!

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2017 at 08:14 PM

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

    Add comment
    10|10000 characters needed characters exceeded