Skip to Content
0

How to manage a late payment

Jun 16, 2017 at 01:51 PM

53

avatar image
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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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.

Share
10 |10000 characters needed characters left characters exceeded