RuleLoadFromFile function for IBM Planning Analytics (TM1)
RuleLoadFromFile loads a text file that contains rules to a Cube
In this video, RuleLoadFromFile is used to load a rule from a text file to the Product Scorecard cube.
Where can the RuleLoadFromFile function be used?
TurboIntegrator
Which TM1 Server version is the RuleLoadFromFile function available for?
Version 11 and 12
What is the syntax for CubeRuleSet?
RuleLoadFromFile(CubeName, TextFile)
- CubeName = Name of the Cube.
- TextFile = Full file path & file name, including its extension.
Note: If we don’t specify the full path of the file, then the function looks for the file in the TM1 data directory. And if we don’t specify the file extension, then the function looks for the .rux extension.
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