Media Summary: DATE returns the date in a string yy-dd-mm format. Works in TIMST Returns a formatted date/time in a string format. Works in TODAY returns the current date in a string yy-dd-mm format. Works in

Tm1 Function Day Rule - Detailed Analysis & Overview

DATE returns the date in a string yy-dd-mm format. Works in TIMST Returns a formatted date/time in a string format. Works in TODAY returns the current date in a string yy-dd-mm format. Works in CELLVALUES returns the string value of the specified element in 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

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. SUBST returns the substring of a specified string. Works in NOW returns the current Time in a serial number format. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in TIMVL returns a formatted date/time in a string format. Works in

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in

Photo Gallery

TM1 Function, DAY (Rule)
TM1 Function, DATE (Rule)
TM1 Function, DATES (Rule)
TM1 Function, TIMST (Rule)
TM1 Function, TODAY (Rule)
TM1 Function, CELLVALUES (Rule)
TM1 Function, LONG (Rule)
TM1 Function, DIMENSIONATTRS (Rule)
TM1 Function, HIERARCHY (Rule)
TM1 Function, SUBST (Rule)
TM1 Function, NOW (Rule)
TM1 Function, ATTRN (Rule)
Sponsored
Sponsored
View Detailed Profile
TM1 Function, DAY (Rule)

TM1 Function, DAY (Rule)

DAY

TM1 Function, DATE (Rule)

TM1 Function, DATE (Rule)

DATE returns the date in a string yy-dd-mm format. Works in

Sponsored
TM1 Function, DATES (Rule)

TM1 Function, DATES (Rule)

DATES

TM1 Function, TIMST (Rule)

TM1 Function, TIMST (Rule)

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

TM1 Function, TODAY (Rule)

TM1 Function, TODAY (Rule)

TODAY returns the current date in a string yy-dd-mm format. Works in

Sponsored
TM1 Function, CELLVALUES (Rule)

TM1 Function, CELLVALUES (Rule)

CELLVALUES returns the string value of the specified element in 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, 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, SUBST (Rule)

TM1 Function, SUBST (Rule)

SUBST returns the substring of a specified string. Works in

TM1 Function, NOW (Rule)

TM1 Function, NOW (Rule)

NOW returns the current Time in a serial number format. 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, FEEDERS (Rule)

TM1 Function, FEEDERS (Rule)

FEEDERS flag

TM1 Function, CONSOLIDATEDMIN (Rule)

TM1 Function, CONSOLIDATEDMIN (Rule)

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

TM1 Function, STET (Rule)

TM1 Function, STET (Rule)

STET cancels the effect of

TM1 Function, TIMVL (Rule)

TM1 Function, TIMVL (Rule)

TIMVL returns a formatted date/time in a string format. 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, CONSOLIDATEDAVG (Rule)

TM1 Function, CONSOLIDATEDAVG (Rule)

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

TM1 Function, CUBEATTRN (Rule)

TM1 Function, CUBEATTRN (Rule)

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

TM1 Function, ATTRS (Rule)

TM1 Function, ATTRS (Rule)

ATTRS returns the string attribute for a 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’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...