AddInfoCubeRestriction function for IBM Planning Analytics (TM1)

Where can the AddInfoCubeRestriction function be used?

Which TM1 Server version is the AddInfoCubeRestriction function available for?

What is the syntax for ExecuteCommand?

• 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