Conversion of MTD to YTD values

[Former Member]

Hi Experts,

I have a MODEL that is of YTD format in BPC. We are loading periodic values from BW and these values are getting stored under the YTD measure of the model.

Any suggestions on how to convert these values which are under YTD, to YTD?

For EX: The values under YTD are actually periodic values directly loading from BW

I would like to ideally convert these values to YTD as -

YTD 2018.02 = YTD 2018.01+PERIODIC 2018.02 and so on...

Any suggestions would be helpful.

[former_member186338 · Accepted solution]

Please read my blog: https://blogs.sap.com/2018/11/02/periodic-ytd-conversion-using-script-logic-in-bpc-nw/

[Former Member]

Hi Vadim,

The loading process is that The actuals will be copied to Forecast (by running a DM package), after which the Forecasted values will be loaded from BW. These values should be in YTD format for which I am writing this code.

The logic is being executed through a DM package, and I am passing the parameter value of TIME, %TIME_SET% here.

"If the Time variable passed is 2013.11, The YTD should be calculated for 2013.11 and 2013.12 only." : Correct me if I am wrong, but currently with this logic, when I pass the Parameter value of 2013.11 in the DM package, the YTD is calculated for 2013.11, 2013.12,2013.01,2013.02...2013.10

Here, should the year not increment to the next year i.e.

2013.11, 2013.12?

[former_member186338]

"The loading process is that The actuals will be copied to Forecast (by running a DM package), after which the Forecasted values will be loaded from BW. These values should be in YTD format for which I am writing this code." - sorry, but absolutely not clear!

Please provide VERY detailed explanation! With samples... Without full understanding I can't help you.

Also, provide details about first/last month of your fiscal year!

[Former Member]

Hi Vadim,

Thanks for your post. I did try the below logic you posted -

I wanted to know if you could help me achieve this, If the Time variable passed is 2013.11, The YTD should be calculated for 2013.11 and 2013.12 only.

But this is continues to sum the values from

2013.11, 2013.12, 2013.01, 2013.02 and so on.

How do I make I stop at 2013.12? I tried

*XDIM_MEMBERSET TIME > %TIME_SET% But it throws error.

------*XDIM_MEMBERSET TIME = %Y%.01,%Y%.02,%Y%.03,%Y%.04,%Y%.05,%Y%.06,%Y%.07,%Y%.08,%Y%.09,%Y%.10,%Y%.11,%Y%.12 *WHEN TIME

*IS *
*REC(EXPRESSION = %VALUE%,TIME = %Y%.12)
*ENDWHEN

*XDIM_MEMBERSET TIME = %Y%.01,%Y%.02,%Y%.03,%Y%.04,%Y%.05,%Y%.06,%Y%.07,%Y%.08,%Y%.09,%Y%.10,%Y%.11
*WHEN TIME
*IS *
*REC(EXPRESSION = %VALUE%,TIME = %Y%.11)
-----*ENDWHEN and so on...

Thank you.

[former_member186338]

Sorry, but can you explain what do you mean by:

"If the Time variable passed is 2013.11, The YTD should be calculated for 2013.11 and 2013.12 only." - strange logic!

[former_member186338]

P.S. Explain your loading process - how often, data scope etc...