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

Tm1 Function Tabdim Rule - Detailed Analysis & Overview

FEEDSTRINGS enables feeding of string cells. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in TIMST Returns a formatted date/time in a string format. Works in DIMIX returns the index of the dimension's element 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

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. DB retrieve a value from a cube cell. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in DIMNM returns an element's primary name based on an index in a dimension. Works in CAPIT capitalize the first letter of every word in a string. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in

ATTRS returns the string attribute for a specified element of a dimension. Works in TIMVL returns a formatted date/time in a string format. Works in DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in Excel. Syntax ... UNDEF returns the undefined value. Works in DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format. Works in

Photo Gallery

TM1 Function, TABDIM (Rule)
TM1 Function, TABDIM (Excel)
TM1 Function, FEEDSTRINGS (Rule)
TM1 Function, DIMENSIONATTRS (Rule)
TM1 Function, TIMST (Rule)
TM1 Function, DIMIX (Rule)
TM1 Function, ATTRN (Rule)
TM1 Function, ELEMENTATTRN (Rule)
TM1 Function, HIERARCHY (Rule)
TM1 Function, DB (Rule)
TM1 Function, CONSOLIDATECHILDREN (Rule)
TM1 Function, DIMNM (Rule)
Sponsored
Sponsored
View Detailed Profile
TM1 Function, TABDIM (Rule)

TM1 Function, TABDIM (Rule)

TABDIM

TM1 Function, TABDIM (Excel)

TM1 Function, TABDIM (Excel)

TABDIM

Sponsored
TM1 Function, FEEDSTRINGS (Rule)

TM1 Function, FEEDSTRINGS (Rule)

FEEDSTRINGS enables feeding of string cells. Works in

TM1 Function, DIMENSIONATTRS (Rule)

TM1 Function, DIMENSIONATTRS (Rule)

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

TM1 Function, TIMST (Rule)

TM1 Function, TIMST (Rule)

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

Sponsored
TM1 Function, DIMIX (Rule)

TM1 Function, DIMIX (Rule)

DIMIX returns the index of the dimension's element 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, 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, DB (Rule)

TM1 Function, DB (Rule)

DB retrieve a value from a cube cell. 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, DIMNM (Rule)

TM1 Function, DIMNM (Rule)

DIMNM returns an element's primary name based on an index in a dimension. Works in

TM1 Function, CAPIT (Rule)

TM1 Function, CAPIT (Rule)

CAPIT capitalize the first letter of every word in a string. Works in

TM1 Function, ELEMENTISPARENT (Rule)

TM1 Function, ELEMENTISPARENT (Rule)

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

TM1 Function, ATTRS (Rule)

TM1 Function, ATTRS (Rule)

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

TM1 Function, TIMVL (Rule)

TM1 Function, TIMVL (Rule)

TIMVL returns a formatted date/time in a string format. Works in

TM1 Function, DBRA (Excel)

TM1 Function, DBRA (Excel)

DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in Excel. Syntax ...

TM1 Function, UNDEF (Rule)

TM1 Function, UNDEF (Rule)

UNDEF returns the undefined value. Works in

TM1 Function, DATES (Rule)

TM1 Function, DATES (Rule)

DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format. 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...