Skip to Content

Historical To Date Measure on BPC 10.1 (NW on HANA DB)

Hi Community,

We are trying to build a new measure which is historical to date (HTD) on our model and we don't know how to proceed.

Do you know if recursive formulas like this one can works or do you have another suggestion :

IIF([%TIME%].CURRENTMEMBER.PROPERTIES("YEAR"),([%TIME%].[YEAR-1],[MEASURES].[HTD])+([%TIME%].CURRENTMEMBER,[MEASURES].[YTD])

Great thanks for your help.

Kind regards

Stéphane

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 04, 2017 at 08:58 AM

    In general the formula like:

    SUM([%TIME%].[2006.01]:[%TIME%].CURRENTMEMBER,[MEASURES].[/CPMB/SDATA])

    will work correctly for base members. Please replace 2006.01 with the first member of your TIME dimension.

    For parents you have to experiment with IIF...

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03, 2017 at 02:55 PM

    Hi Vadim,

    Thanks for your answer, to give an example we want if we select time 2016.12 to obtain the amount of all month before this date (including 2016.12).

    I don't know if it is clear for you ?

    It is used by my company to see depreciations.

    Best regards

    Stéphane

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vadim,

      That's that, the HTD measure we want is for all periods from the company start, I see your response, I think that can corresond to our case.

      Thanks for your answer I am going to study the case.

      Kind regards

      Stéphane

  • Jan 03, 2017 at 02:50 PM

    Can you explain the desired calculation logic using some example instead of incorrect formula?

    Add comment
    10|10000 characters needed characters exceeded