Hi Board experts,

Everything is in the title, we are working on a computation engine that works both with monthly and Year-to-date values.

In a dataflow we currently do the operation to convert a monthly cube in a YTD value cube, but what would be the most efficient way to do the reverse ? How would you set it up to obtain an HBMP algorithm ?

Thanks for your help,

Etienne

Hi Etienne CAUSSE,

Maybe I’m missing something, but would a dataflow like one of these meet your expectations?

a. Value, with Cumulative Value function applied and cycle of 1000

b. Value, with Cumulative Value function applies and cycle of 1000 and offset of 1

c. Algorithm c=a-b

Since these are already YTD values, using just an offset variance may do the trick too.

a. Value

b. Value, offset 1

c. Algorithm c=a-b