TM1RPTROW

TM1RPTROW sets the Dynamic Report control row definition. The control row definition governs the behavior of all rows in the Dynamic Report.

Syntax

TM1RPTROW(SAFID, ServerDimension, [SetName], [ElementList],
[AliasOverride], [ExpandAbove], [MDXOverride], [IndentRate], [AllowDrilling])

Argument

Description

Required/Optional

SAFID

A reference to a cell that contains a TM1RPTVIEW formula.

Required

ServerDimension

A dimension, specified using the format server:dimension.

Required

SetName

A named set. If this argument is empty, all elements of the dimension are used.

Optional

ElementList

An array of values that specifies a list of members to constitute a set. For example, ElementList can reference a cell range.

When this argument is supplied, the named set specified by the SetName is ignored.

If this argument is empty, the members from the set specified by the SetName are used.

Optional

AliasOverride

A string that defines the alias used for the set.

When this argument is supplied, it overrides the default alias property defined by the set specified by the Set argument.

If this argument is empty, the alias from the set specified by the set argument is used.

Optional

ExpandAbove

A Boolean flag to turn on or off the subset Expand Above property. When this argument is supplied, it overrides the default ExpandAbove property defined by the subset specified by the Subset argument.

If the argument value is 1, consolidated members expand upward when drilling.

If the argument value is 0, consolidated members expand downward when drilling.

If this argument is empty or omitted, the Expand Above property from the subset specified by the Subset argument is used.

Optional

MDXOverride

An MDX statement that applies to the set specified by the Set/SetMembers argument.

When this argument is supplied, it overrides the default MDX filter defined by the set specified by the set argument.

If this argument is empty or omitted, the members from the set specified by the set argument are used.

Optional

IndentRate

An integer value to indicate how many indentations are applied to each level when drilling down on a consolidated member. If the argument value is 0, no auto-indentation is performed.

If this argument is empty or omitted, one indentation is applied to each level as you drill down on a consolidated member.

Optional

AllowDrilling

A Boolean flag to turn on or off drilling on consolidated members.

When this argument value is 1, you can drill down on consolidated members in the Dynamic Report.

When this argument value is 0, you cannot drill down on consolidated members in the Dynamic Report.

If this argument is empty or omitted, the default behavior is to allow drilling on consolidated members.

Optional

Example

TM1RPTROW($B$9,"SData:region",,"$B$17:$B$18",,1,"",5, 0)
TM1RPTROW($B$16,"GO_New_Stores:Retailers",,,,,B$15)