DB function for IBM Planning Analytics (TM1)

Where can the DB function be used?

Which TM1 Server version is the DB function available for?

What is the syntax for DB?

• ​Cube = Cube Name to retrieve the data from ​
• e1,e2….en = Dimension element names determining the data point within the cube to be retrieved. The sequence of the element arguments should match the order of the dimensions in the cube. ​
  
  Note: ​
  The principal element name or Alias can be used to argue the function. If using hierarchies, the dimension name should be mentioned along with the element name, like HierarchyName:ElementName 

Relevant Functions

• DB = Retrieve a value from a cube cell
• IsLeaf = Determines if an element is a leaf element or not
• IsUndefinedCellValue = Compares the argument value with the default numeric cube value and returns 1 if the cell value is equal to the cube’s default value
• Undef = Returns the undefined value
• UndefinedCellValue = Returns the default numeric cube value
• UndefVals = Changes the default value for the cube from zero to a special undefined value