Can the entity of the rule be a parent of a cube structure entity for rule consolidation?

Edward

When trying to consolidate and store the rule into a cube (CUBE A) I running into issues.

Based on the documentation I followed appropriate steps: setup a temporary cube and then used it in a dataflow TEMP = a (where block a is CUBE A with rule applied). I then run a second dataflow to flow TEMP back into CUBE A.

The rule (simplified) is created on a dimension called "P&L" however the cube is structured by "GL". This is the only thing that I am finding ambiguous in the documentation. Does the rule need to be written on "GL" for this process to work?

I have applied the extend to "GL" as this is the child of "P&L".

Hamza Mesbahi

Hi @Edward,

Yes, based on the Board manual documentation on using a rule in a data flow and prior experience, the entity on which the rule is applied must be a dimension in the target cube for the rule consolidation to work correctly. In your case, you would either need to have your target cube also dimensioned by P&L or, as you mentioned, define the rule at the GL level so that both the source and target share the same rule dimension.

In addition to the Board manual link mentioned above, I also recommend reviewing this best practices article on rule consolidation from our Center of Excellence.

Hope this helps.

Hamza