What Is the Problem?

The preceding rule statement includes a DB function that references the Date dimension.

(The !Date argument to the DB function instructs the TM1® server to use the current element of the Date dimension.) Unfortunately, the Plan cube for which the rule is written does not include the Date dimension. The server is unable to resolve the !Date argument, resulting in the error.

The Plan cube does contain the Month dimension, which shares common element names with the Date dimension. If you substitute a reference to the Month dimension for the original reference to the Date dimension, the rule compiles and correctly moves data from the Production cube into the Plan cube.

['Planned Production Qty - Kgs']=DB('Production',!CakeType,!Month,'Quantity
Produced - Kgs');

Follow the steps below to create the calculation statement for the Plan cube.

Procedure

  1. Right-click the Plan cube in the Server Explorer, and click Create Rule.
  2. Enter the calculation statement in the Rules Editor.
  3. Click Save to save the rule.
  4. Confirm that the rule works by opening the Jan - Mar view for both the Production and Plan cube. The Jan - Mar view of the Plan cube pulls values from the identically structured view of the Production cube.