TM1RPTROW
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)