Potential 22.03 regression
If you encounter the following error during Consolidate or Force Consolidate on your 22.03 TRC instance please review the steps below to apply a workaround.
Batch calc error, FIX statement cannot contain Dynamic Calc member from dimension [Account]
The following workaround will resolve the error. It must be applied to ALL environments, e.g. test, production, DR, UAT, dev, etc.
- Select Navigate — > Tools —> Variables, then select Substitution Variables
- Click on the + icon to create a new substitution variable
- Create a subscription variable with the following details
Variable Name: EnableBucketedMovement_TRCS
The issue is resolved in 22.04 and going forward.