Using a Rule in a Dataflow

This topic describes how to use Rules in Dataflow Procedure steps.


Rules can be used in Dataflow Procedure steps. By running a Rule for a Cube in a Dataflow, the calculation results of the formula are stored in the target Cube. The target Cube has to contain the Rule Entity as dimension which must be consolidated.


To run a Rule for a Cube in a Dataflow Procedure step, proceed as follow:

  • Create a Procedure and define a Dataflow step
  • In the Layout editor of the Dataflow, select the Cube on which the Rule should be applied
  • Select a Rule from the Block settings sliding right panel, under the "RULES" menu
  • Select the target Cube and enter the calculation in the "Target" area.
  • Configure all other properties as needed (optional)
  • Click the "SAVE CHANGES" button.


Rules generally include algorithms or formulas which cannot be aggregated (for example percentages and ratios), so Rules are usually not applied in Dataflow steps.


To properly calculate all members of the Entity where a Rule has been set, the "Extend calculation" option must be enabled on that Entity.
To apply a Rule to a Cube in the Dataflow Layout, select the appropriate Cube and apply the desired Rule from the "RULES" menu in the Block properties panel. The Cube must have the Entity where the Rules has been set in its Structure. You cannot add a Rule as a Block of the Dataflow Layout.
If a Rule refers to a previous Block in the Layout through the column offset operator and that Block is also the target of the Dataflow, then the "Period by Period recursion" option can be enabled.