Media Summary: FEEDSTRINGS enables feeding of string cells. Works in ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal ... UNDEFINEDCELLVALUE returns the default numeric cube value. Works in

Tm1 Function Cellvaluen Rule - Detailed Analysis & Overview

FEEDSTRINGS enables feeding of string cells. Works in ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal ... UNDEFINEDCELLVALUE returns the default numeric cube value. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in

ATTRN returns the numeric attribute for a specified element of a dimension. Works in ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. DB retrieve a value from a cube cell. Works in ELEMENTLEVEL returns the level of an element within a dimension. Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

ELCOMP returns the name of child of a consolidated element. Works in ELISANC determines if an element is ancestor of another element or not. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in

Photo Gallery

TM1 Function, CellValueN (Rule)
TM1 Function, CELLVALUES (Rule)
TM1 Function, FEEDSTRINGS (Rule)
TM1 Function, ISUNDEFINEDCELLVALUE (Rule)
TM1 Function, UNDEFINEDCELLVALUE (Rule)
TM1 Function, DIMENSIONATTRS (Rule)
TM1 Function, CUBEATTRN (Rule)
TM1 Function, ELEMENTCOMPONENTCOUNT (Rule)
TM1 Function, ATTRN (Rule)
TM1 Function, ELEMENTATTRN (Rule)
TM1 Function, ELEMENTISCOMPONENT (Rule)
TM1 Function, STET (Rule)
Sponsored
Sponsored
View Detailed Profile
TM1 Function, CellValueN (Rule)

TM1 Function, CellValueN (Rule)

CELLVALUEN

TM1 Function, CELLVALUES (Rule)

TM1 Function, CELLVALUES (Rule)

CELLVALUES

Sponsored
TM1 Function, FEEDSTRINGS (Rule)

TM1 Function, FEEDSTRINGS (Rule)

FEEDSTRINGS enables feeding of string cells. Works in

TM1 Function, ISUNDEFINEDCELLVALUE (Rule)

TM1 Function, ISUNDEFINEDCELLVALUE (Rule)

ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal ...

TM1 Function, UNDEFINEDCELLVALUE (Rule)

TM1 Function, UNDEFINEDCELLVALUE (Rule)

UNDEFINEDCELLVALUE returns the default numeric cube value. Works in

Sponsored
TM1 Function, DIMENSIONATTRS (Rule)

TM1 Function, DIMENSIONATTRS (Rule)

DIMENSIONATTRS returns a string attribute for a specified dimension. Works in

TM1 Function, CUBEATTRN (Rule)

TM1 Function, CUBEATTRN (Rule)

CUBEATTRN returns a numeric attribute for a specified cube. Works in

TM1 Function, ELEMENTCOMPONENTCOUNT (Rule)

TM1 Function, ELEMENTCOMPONENTCOUNT (Rule)

ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in

TM1 Function, ATTRN (Rule)

TM1 Function, ATTRN (Rule)

ATTRN returns the numeric attribute for a specified element of a dimension. Works in

TM1 Function, ELEMENTATTRN (Rule)

TM1 Function, ELEMENTATTRN (Rule)

ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in

TM1 Function, ELEMENTISCOMPONENT (Rule)

TM1 Function, ELEMENTISCOMPONENT (Rule)

ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.

TM1 Function, STET (Rule)

TM1 Function, STET (Rule)

STET cancels the effect of

TM1 Function, SKIPCHECK (Rule)

TM1 Function, SKIPCHECK (Rule)

SKIPCHECK forces

TM1 Function, DB (Rule)

TM1 Function, DB (Rule)

DB retrieve a value from a cube cell. Works in

TM1 Function, ELEMENTLEVEL (Rule)

TM1 Function, ELEMENTLEVEL (Rule)

ELEMENTLEVEL returns the level of an element within a dimension. Works in

TM1 Function, CONSOLIDATEDMIN (Rule)

TM1 Function, CONSOLIDATEDMIN (Rule)

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

TM1 Function, ELCOMP (Rule)

TM1 Function, ELCOMP (Rule)

ELCOMP returns the name of child of a consolidated element. Works in

TM1 Function, ELISANC (Rule)

TM1 Function, ELISANC (Rule)

ELISANC determines if an element is ancestor of another element or not. Works in

TM1 Function, CONSOLIDATECHILDREN (Rule)

TM1 Function, CONSOLIDATECHILDREN (Rule)

CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in

TM1 Function, ELEMENTISPARENT (Rule)

TM1 Function, ELEMENTISPARENT (Rule)

ELEMENTPARENT returns the parent of an element in the dimension. Works in

Related Video Content

Ticketmaster US information

We would like to show you a description here but the site won’t allow us.

TM1 Sales information

TM1 Sales JavaScript has been disabled on your browserenable JS

What is TM1? - IBM information

Jun 7, 2023 · TM1 is a multidimensional, in-memory OLAP database with a cell-orientated structure used to create...

IBM Planning Analytics information

Powered by the IBM® TM1® database, IBM Planning Analytics helps you unify your business planning in one governed...

IBM Planning Analytics - Wikipedia information

The database server component of the software platform retains its historical name TM1. Data is stored in in-memory …