Supported IBM TM1 worksheet functions

IBM® Planning Analytics for Microsoft Excel supports most TM1® worksheet functions.

DBR
DBR retrieves a value from a specified TM1 cube.
DBRA
DBRA retrieves the value of a specified member attribute.
DBRW
DBRW retrieves a value from a specified TM1 cube.
DBS
DBS sends a numeric value to a TM1 cube.
DBSA
DBSA sends a value to a specified member attribute.
DBSS
DBSS sends a string to a cube of any number of dimensions.
DBSW
DBSW sends a numeric value to a TM1 cube.
DefineCalc
User-defined calculations (UDC) are supported through the DefineCalc function. You can use this function to register or unregister a calculation definition in IBM Planning Analytics for Microsoft Excel.
DFRST
DFRST returns the first member of a specified dimension. The first member in a dimension is the member with an index number of 1.
DIMIX
DIMIX returns the index number of a member within a dimension.
DIMNM
DIMNM returns the member of a dimension that corresponds to the index argument.
DIMSIZ
DIMSIZ returns the number of members within a specified dimension.
DNEXT
DNEXT returns the member name that follows the member specified as an argument to the function.
DNLEV
DNLEV returns the number of hierarchy levels in a dimension.
DTYPE
DTYPE returns information about the specified member.
ELCOMP
ELCOMP returns the name of a child of a consolidated member in a specified dimension.
ELCOMPN
ELCOMPN returns the number of children of a specified member.
ELISCOMP
ELISCOMP determines whether element1 is an immediate child of element2 in the specified dimension.
ELISPAR
ELISPAR determines whether member1 is an immediate parent of member2 in the specified dimension.
ELLEV
ELLEV returns the level of a member within a dimension.
ELPAR
ELPAR returns the parent of a member in a specified dimension
ELPARN
ELPARN returns the number of unique parents of a member in a specified dimension.
ELSLEN
ELSLEN returns the length of a member name within a dimension, if the member name is a string.
ELWEIGHT
ELWEIGHT returns the weight of a child in a consolidated member.
SUBNM
SUBNM returns the member of a set corresponding to the IndexOrName argument.
SUBSIZ
SUBSIZ returns the number of members in a dimension set.
TABDIM
TABDIM returns the dimension name that corresponds to a given index argument.
TM1ELLIST
TM1ELLIST returns a downward array vector of values. It is useful because you can get a set of element values from a TM1 model by using a single formula.
TM1GLOBALSANDBOX
TM1GLOBALSANDBOX returns the current global active sandbox for the user.
TM1INFO
TM1INFO returns information about the current TM1 or Planning Analytics for Microsoft Excel version or client.
TM1PRIMARYDBNAME
TM1PRIMARYDBNAME returns the primary TM1 server name that the user is authenticated through, even if the user is implicitly logged into multiple TM1 servers. This function doesn't accept any arguments.
TM1ACTIVESERVERS
TM1ACTIVESERVERS returns the host URI, server name, and username information for active session connections in a 2-dimensional array. This function doesn't accept any arguments.
TM1RESOLVEBOOK
TM1RESOLVEBOOK resolves formulas with nested parentheses in an active workbook.
TM1RESOLVEFORMULAS
Use TM1RESOLVEFORMULAS to resolve formulas with nested parentheses in a cell range.
TM1RESOLVENESTEDPARENS
TM1RESOLVENESTEDPARENS removes nested parentheses from a formula and returns a string.
TM1RESOLVESHEET
TM1RESOLVESHEET resolves formulas with nested parentheses in an active worksheet. Make sure you are not connected to a server when running this function.
TM1RPTELISCONSOLIDATED
TM1RPTELISCONSOLIDATED returns a Boolean value to indicate whether a member in a Dynamic Report is consolidated.
TM1RPTELLSEXPANDED
TM1RPTELLSEXPANDED returns a Boolean value to indicate whether or not a member is expanded in a Dynamic Report row set.
TM1RPTELLEV
TM1RPTELLEV returns an integer value representing a member level within a hierarchy. This function is used in Dynamic Reports.
TM1RPTFILTER
TM1RPTFILTER defines the filter applied to a Dynamic Report column dimension.
TM1RPTROW
TM1RPTROW sets the Dynamic Report control row definition. The control row definition governs the behavior of all rows in the Dynamic Report.
TM1RPTTITLE
TM1RPTTITLE defines a Dynamic Report title dimension.
TM1RPTVIEW
TM1RPTVIEW defines the view displayed in a Dynamic Report.
TM1SET
TM1SET is a powerful function that supports alternate hierarchies in IBM Planning Analytics for Microsoft Excel and IBM Planning Analytics TM1 Web.
TM1USER
TM1USER returns the user name of the user currently logged in to TM1 and using the TM1USER function.
TM1Val
TM1Val is a hierarchy spreadsheet formula available in IBM Planning Analytics TM1 Web and IBM Planning Analytics for Microsoft Excel.
VIEW
VIEW is primarily used for compatibility with IBM TM1 Perspectives worksheets. For example, when you create a slice from a TM1 Perspectives worksheet and open it in IBM Planning Analytics for Microsoft Excel, you might see a VIEW function. The VIEW function defines a view of the cube specified by the server:cube argument.

Parent topic: TM1 worksheet functions in IBM Planning Analytics for Microsoft Excel