Skip to Content
avatar image
Former Member

How to manage a late payment

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 20, 2017 at 05:14 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded