TM1 Function for TM1, TM1RPTROW

TM1RPTROW returns the row set in a Dynamic Report. Use MDX, a set/subset or hardcode a list of elements in Excel to return members to the row.

Available In

Excel

Definition

TM1RPTROW returns the row set in a Dynamic Report. Use MDX, a set/subset or hardcode a list of elements in Excel to return members to the row. Change how the row appears to users by setting the element’s indentation, whether to expand consolidations above or below, or allow drilling on consolidations. Used for Dynamic Reports (Active Form).

Syntax

TM1RPTROW(TM1RptView, TM1ServerName:Dimension, SetName, ElementList, AliasOverride, ExpandAbove, MDXOverride, IndentRate, IndentCharacter, ConsolidationDrilling)

TM1ServerName = Name of the TM1 Server
Dimension = dimension used for the row
TM1RptView = reference to the TM1RptView function from a Dynamic Report
Dimension = Name of the Dimension (REQUIRED)
SetName = Set name (OPTIONAL)
ElementList = An array of elements. For example {“4”;”40”;”400”} (OPTIONAL)
AliasOverride = Name of an alias (OPTIONAL)
ExpandAbove = A Boolean field. 1 for consolidations to expand above or 0 to expand below. As a default, it is set to 0 (OPTIONAL)
MDXOverride = An MDX expression (OPTIONAL)
IndentRate = Enter a number to indicate the indentation applied to each level. A value of 0 applies no indentation. As a default, the indentation of 1 is applied (OPTIONAL)
ConsolidationDrilling = turn on or off drilling down or up consolidations. A value of 0 prevents drilling, while 1 allows drilling. As a default, drill is applied (OPTIONAL)

Video Demo

In a Dynamic Report, change TM1RPTROW to:
•use a set called Components from the Product Type dimension
•use a hardcoded list in Excel
•use an MDX to obtain all children from All Products consolidation.