TM1 Function for Excel, 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.