cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation Sequence of a Single Data Unit:

PFugereCSO
New Contributor III

 

The items below detail the specific list of tasks that are executed for each data unit during the calculation process.

Data Unit Calculation Sequence (DUCS)

  1. Clear previously calculated data
    1.  If Using Hybrid Scenarios  - the copy will run here
  2. Run Scenario Member Formula
  3. Run reverse translations by calculating Flow members from other Alt Cur. Input Flow members
  4. Execute Finance Business Rules (1 & 2)
  5. Run Formula Passes (1 – 4 )
    • Account, Flow, UD1, UD2, … UD8 (Member Formula Execution)
  6. Execute Finance Business Rules (3 & 4)
  7. Run Formula Passes (5 – 😎
    • Account, Flow, UD1, UD2, … UD8 (Member Formula Execution)
  8. Execute Finance Business Rules  (5 and 6)
  9. Run Formula Passes (9 – 12)
    • Account, Flow, UD1, UD2, … UD8 (Member Formula Execution)
  10. Execute Finance Business Rules  (7 and 8 )
  11. Run Formula Passes (13 – 16)
    • Account, Flow, UD1, UD2, … UD8 (Member Formula Execution)
4 REPLIES 4

NaeemPathan
New Contributor II

Thanks Peter, this is useful to refer to.

TomABC
New Contributor II

TLinton_0-1637758352458.png

A visual to go with the Data Unit Calculation Sequence (DUCS), hope this helps

Summer
New Contributor

Hello Peter and Tom,

 

Thanks for sharing. It's super clear and useful.

I have a question regarding the third step.

3. Run reverse translations by calculating Flow members from other Alt Cur. Input Flow members

This step is only for entities which have multi-currency input. Say an entity allows input in both USD and EUR, its local currency is USD. When we calculate on this entity, this step will translate EUR input data to USD. Am I right?

 

Thanks in advance for your reply.

PFugereCSO
New Contributor III

You can add Force Translations in the workflow, as part of the Run Calculate step.  And I like this option much better than having the system try and guess based on where data is.  The reason is that there are times when no one will enter data and you will need it to run.  So why have the performance hit unless you need it?