TM1 Functions for Excel
DBR
Retrieves and writes back a value or text to a cube’s cell. DBR is less efficient over a WAN than DBRW. DBR will be processed before a DBRW.
DBS
Used to send a value to a cube’s cell. This function cannot send a string to a cube. To send strings, use the DBSS function.
DBSA
Used to send a value to a dimension attribute. The value sent can be either a string or numeric value, based on the attribute type.
DTYPE
Returns the element type in a dimension.
N = numeric element; C = consolidated element; S = string element
ELCOMP
Returns the name of a child element from a consolidated element based on the position.
ELISCOMP
Determines whether an element is a component of a parent element in a dimension.
ELSLEN
Return the number of characters in the element in a dimension. Member ID and alias can be used.
SUBNM
Return an element from a dimension set. The formula transforms the cell into a drop down and can open to the set by double-clicking on the cell.
TM1GLOBALSANDBOX
Returns the active sandbox for the user. Only available in IBM Planning Analytics for Excel and Worksapce.
TM1INFO
Return information on the TM1 client. Only supported in Planning Analytics for Excel.
TM1RPTELISCONSOLIDATED
Returns a boolean value if an element is consolidated.
Used for Dynamic Reports (Active Form).
TM1RPTELISEXPANDED
Returns a boolean value if an element is expanded on the row set.
Used for Dynamic Reports (Active Form).
TM1RPTELLEV
Returns an element’s level relative to the root in the subset.
Used for Dynamic Reports (Active Form).
TM1RPTFILTER
Apply a filter to the Dynamic report to sort the row based on a column
Used for Dynamic Reports (Active Form).
TM1RPTROW
Returns the row set in a Dynamic Report. Use MDX, a set/subset or hardcode a list of elements in Excel to return members to the row.
TM1RPTTITLE
Used to define the title dimension. TM1RPTTITLE is used in conjunction with TM1RptView.
Used for Dynamic Reports (Active Form).
TM1RPTVIEW
Controls the definition of the report like zero suppression and the format area.
Used for Dynamic Reports (Active Form).
VIEW
Sets up an optimised view for a cube that is cached in memory, so it can be referenced quicker.