Knowledge Base Article

Question: How do you run a consolidation, or a force calculate, in a business rule? I’m copying data into another scenario and then want to calculate the member formulas in the account dimension.

Answer

  • Rather than triggering a calculation/consolidation from the business rule, consider adding it as a second step in a data management sequence instead (for example after the ‘data copy’ custom calculation step).
  • Otherwise, one can create a calculation/consolidation step as part of a separate data management job that can then be called using a business rule. 
  • A data management job can be called within a business rule using one of the following commands:

 

  • StartDataMgmtSequence – start the sequence in the background and move to the next line of code in the business rule
  • ExecuteDataMgmtSequence – start the sequence and wait for it to finish before moving to the next line of code in the business rule
  • QueueDataMgmtSequence – like StartDataMgmtSequence but creates a queued task that will be considered by all the data management servers not just the server that is running the business rule. 

Source: Office Hours 2020-7-2 - Partner Enablement

 

Updated 2 years ago
Version 3.0
No CommentsBe the first to comment