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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 21, 2017 at 08:14 PM

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

    Add a comment
    10|10000 characters needed characters exceeded