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.

[OSAdmin]

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