CubeRuleAppend function for IBM Planning Analytics (TM1)

Where can the CubeRuleAppend function be used?

TurboIntegrator

Which TM1 Server version is the CubeRuleAppend function available for?

Version 11 and 12

What is the syntax for CubeRuleAppend?

CubeRuleAppend(CubeName, RuleText, IsCalculationRule)

• ​CubeName = Name of the Cube. ​
• RuleText = Single line of rule text that we want to insert in the Rule. ​
• IsCalculationRule = To define if the new rule line should be added above the feeder statement or below the feeder statement. ​
  • 1 = insert new rule line above the feeder statement
  • 0 = add the new rule line below the feeder statement or at the end of the rule.

Relevant Functions

• CubeProcessFeeders = Re-processes feeders in the rule for a specified cube
• CubeRuleAppend = Appends a single line of text to a rule
• CubeRuleDestroy = Deletes the rule from a cube
• CubeRuleGet = retrieves all rule lines within a cube rule as a single string.
• CubeRuleSet = returns all the rule lines within a cube rule as a single string.
• DeleteAllPersistentFeeders = Deletes all persistent feeders on the TM1 Server
• ForceSkipCheck = Forces the view query to process only values in the cube, instead of going through every possible cell
• RuleLoadFromFile = Loads a text file that contains rules to a Cube
• RuleLoadFromFileEx = creates or overwrites a cube’s rule from a text file