Skip to Content

YTD MEASURE

BPC 10.1 NW SP10 ON HANA. Consolidation YTD model. Integration rule enabled.

BW 7.4 SP15

EPM Addin SP30 P1

For Net income(INC Type) there is no activity (data) after period 2. When we use YTD measure expecting to see value in period 2 in all remaining periods(Period 3 to 12) .But currently it shows BLANK. Is this issue with YTD measure?

capture.png (9.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 05 at 04:17 PM

    "When we use YTD measure expecting to see value in period 2 in all remaining periods(Period 3 to 12)" - it's only yours expectation!

    This is a correct behavior of YTD model - if you have no data in the period then it's empty!

    Add comment
    10|10000 characters needed characters exceeded

    • And next time the users will want to see 2 x 2 = 5 ???

      Missing data in the period is equal zero for BPC - it's by design!

      If you load data for some last month in YTD cube (period 2 for example) you can copy using script this data to all remaining period (3-12) to make strange users happy... But it's absolutely not a normal requirement! Ha-ha-ha!

  • Feb 05 at 04:00 PM
    -1

    Have you followed the steps in 1665088 - Integration mode in consolidation. Can you provide screen capture of the Integration rules defined?

    Add comment
    10|10000 characters needed characters exceeded