AddInfoCubeRestriction function for IBM Planning Analytics (TM1)
AddInfoCubeRestriction restricts values that are imported from an InfoCube data set. Use this function in the Prolog. AddInfoCubeRestriction can be called multiple times to filter more than one characteristic in a process.
Where can the AddInfoCubeRestriction function be used?
TurboIntegrator
Which TM1 Server version is the AddInfoCubeRestriction function available for?
Version 11
What is the syntax for ExecuteCommand?
AddInfoCubeRestriction(STRING CharactName, STRING sign,STRING compOperator, STRING lowValue, STRING highValue)
- STRING CharactName = technical name of the characteristic to be restricted. Less than or equal to 30 characters.
- STRING sign = ‘I’ for inclusive or ‘E’ for exclusive.
STRING compOperator = Comparative Operator.- EQ = equal
- NE = not equal
- LT = less than
- GT = greater than
- LE = less or equal
- GE = greater or equal
- BT = between
- NB = not between
- STRING lowValue = low value for the operator defined before.
- STRING highValue = contains the high value for the operator defined before. Only needed for operators BT and NB.
Relevant Functions
- AddInfoCubeRestriction = Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic
- Expand = Expands variable names, enclosed in % signs
- FileExists = Searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned
- LogOutput = Writes a message to the tm1server.log file
- TM1User = Returns the user logged in
- WildcardFileSearch = Searches files using wildcard characters in a folder