RuleLoadFromFileEx function for IBM Planning Analytics (TM1)

RuleLoadFromFileEx creates or overwrites a cube’s rule from a text file. The file must use a semi-colon (;) to end each rule and a hash (#) for comments.

Where can the RuleLoadFromFileEx function be used?

TurboIntegrator

Which TM1 Server version is the RuleLoadFromFileEx function available for?

Version 11 and 12

What is the syntax for RuleLoadFromFileEx?

RuleLoadFromFileEx(Cube, TextFile, CharacterSet)

Cube = Cube Name
TextFile = Name of the text file with the rules
CharacterSet = Character encoding used for the file (refer to the SetInputCharacterSet function)

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