cancel
Showing results for 
Search instead for 
Did you mean: 

mapping property -> dimension in advanced formula, SAC

ypinchuk
Explorer
0 Kudos

Hi,

Please advise me on how to make an advanced formula to move sales planning data to the P&L model.

The Sales planning model is dimensioned by Projects. Each Project has properties: BusinessLine, CostCenter and RevenueAccount.

P&L Model is dimensioned by Account (RevenueAccount), BusinessLine and CostCenter.

I need to transfer Sales data -> P&L Model, with the mapping

RevenueAccount (property) -> Account (dimension),

BusinessLine (property) -> BusinessLine (dimension),

CostCenter (property) -> CostCenter (dimension).

I used this script to map account (property to dimension)

ypinchuk_0-1709134987128.png

but I don't understand how to add the other two property-dimension mappings to the formula.

I prefer to keep Account, BusinessLine and CostCenter as properties of the Project because they are 1-1 related.

Many thanks,

Yuri

 

Accepted Solutions (0)

Answers (1)

Answers (1)

ypinchuk
Explorer
0 Kudos

Other mappings could be easily added to the formula. The problem was that the advanced formula script editor gives incorrect suggestions, so I had to print the additional mapping manually