How to manage a late payment

[Former Member]

Hello,

I created a new model in SAP BO Cloud with Product and Entity Dimensions, and amount and NBMonthsDelay Measures in the Account Dimension.

At the first sight, the amounts are all assigned to January.

I would like, depending of "NBMonthsDelay" values, move the amounts to the next or multiple months on.

Exp :

Delay January Feb Mar

A 1 10 - -

B 2 30 - -

Target:

Delay January Feb Mar

A 1 - 10 -

B 2 - - 30

Any idea how to implement this on SAC/BO CLoud?

Appreciate your help,

[pdaniel · Accepted solution]

Hi. If I understand your question, you are asking how to place a value from January of a year into a future period? It sounds like it requires an ability to allocate a "From" period into a "To" period, based on a value defined as "Number of months" forward. But this also would require SAC to have an ability to perform time intelligent calculations, which I cannot find a solution for at this time. Account formulas have an ability to Lookup data at Previous or Last, but that would not seem feasible either. I would submit an enhancement request.