Media Summary: ATTRS returns the string attribute for a specified element of a dimension. Works in FEEDSTRINGS enables feeding of string cells. Works in TIMST Returns a formatted date/time in a string format. Works in

Tm1 Function Stet Rule - Detailed Analysis & Overview

ATTRS returns the string attribute for a specified element of a dimension. Works in FEEDSTRINGS enables feeding of string cells. Works in TIMST Returns a formatted date/time in a string format. Works in CELLVALUES returns the string value of the specified element in a specified cube. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. CUBEATTRN returns a numeric attribute for a specified cube. Works in

LONG returns the length of the string. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in UNDEF returns the undefined value. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in EXP returns the natural anti-log of a number. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in NOW returns the current Time in a serial number format. Works in ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in

Photo Gallery

TM1 Function, STET (Rule)
TM1 Function, ATTRS (Rule)
TM1 Function, FEEDSTRINGS (Rule)
TM1 Function, TIMST (Rule)
TM1 Function, CELLVALUES (Rule)
TM1 Function, HIERARCHY (Rule)
TM1 Function, CUBEATTRN (Rule)
TM1 Function, LONG (Rule)
TM1 Function, DIMENSIONATTRS (Rule)
TM1 Function, CONSOLIDATEDMIN (Rule)
TM1 Function, CONSOLIDATEDAVG (Rule)
TM1 Function, UNDEF (Rule)
Sponsored
Sponsored
View Detailed Profile
TM1 Function, STET (Rule)

TM1 Function, STET (Rule)

STET

TM1 Function, ATTRS (Rule)

TM1 Function, ATTRS (Rule)

ATTRS returns the string attribute for a specified element of a dimension. Works in

Sponsored
TM1 Function, FEEDSTRINGS (Rule)

TM1 Function, FEEDSTRINGS (Rule)

FEEDSTRINGS enables feeding of string cells. Works in

TM1 Function, TIMST (Rule)

TM1 Function, TIMST (Rule)

TIMST Returns a formatted date/time in a string format. Works in

TM1 Function, CELLVALUES (Rule)

TM1 Function, CELLVALUES (Rule)

CELLVALUES returns the string value of the specified element in a specified cube. Works in

Sponsored
TM1 Function, HIERARCHY (Rule)

TM1 Function, HIERARCHY (Rule)

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.

TM1 Function, CUBEATTRN (Rule)

TM1 Function, CUBEATTRN (Rule)

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

TM1 Function, LONG (Rule)

TM1 Function, LONG (Rule)

LONG returns the length of the string. Works in

TM1 Function, DIMENSIONATTRS (Rule)

TM1 Function, DIMENSIONATTRS (Rule)

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

TM1 Function, CONSOLIDATEDMIN (Rule)

TM1 Function, CONSOLIDATEDMIN (Rule)

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

TM1 Function, CONSOLIDATEDAVG (Rule)

TM1 Function, CONSOLIDATEDAVG (Rule)

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

TM1 Function, UNDEF (Rule)

TM1 Function, UNDEF (Rule)

UNDEF returns the undefined value. Works in

TM1 Function, ELEMENTTYPE (Rule)

TM1 Function, ELEMENTTYPE (Rule)

ELEMENTTYPE returns element type information of an element in the dimension. Works in

TM1 Function, CONSOLIDATEDCOUNTUNIQUE (Rule)

TM1 Function, CONSOLIDATEDCOUNTUNIQUE (Rule)

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in

TM1 Function, EXP (Rule)

TM1 Function, EXP (Rule)

EXP returns the natural anti-log of a number. Works in

TM1 Function, SKIPCHECK (Rule)

TM1 Function, SKIPCHECK (Rule)

SKIPCHECK forces

TM1 Function, ELEMENTCOMPONENTCOUNT (Rule)

TM1 Function, ELEMENTCOMPONENTCOUNT (Rule)

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

TM1 Function, NOW (Rule)

TM1 Function, NOW (Rule)

NOW returns the current Time in a serial number format. 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

Related Video Content

Ticketmaster US information

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

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 - Wikipedia information

IBM Planning Analytics powered by TM1 (formerly IBM Cognos TM1, formerly Applix TM1, formerly Sinper TM/1 [1]) is a...

What is TM1/Planning Analytics? History, Components and Uses information

Aug 18, 2008聽路 Here we explain what TM1 is, outline it's history, how it has developed under IBM, what the core...

TM1 Events | Ticketmaster information

Dec 12, 2019聽路 TM1 Events Quickly create, manage inventory, and publish events using TM1 Events. From real-time...