用于Excel的TM1函数,TM1RPTROW

TM1RPTROW返回动态报告中的行集。使用MDX,一个集合/子集或在Excel中硬编码一个元素列表来返回成员的行。

可提供

Excel

定义

TM1RPTROW返回动态报告中的行集。使用MDX,一个集合/子集或在Excel中硬编码一个元素列表来返回行的成员。通过设置元素的缩进,是否在上面或下面展开合并,或允许对合并进行钻探,来改变该行在用户面前的显示方式。用于动态报告(Active Form)。

语法

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)

视频演示

在一个动态报告中,将TM1RPTROW改为。
-使用产品类型维度中的一个叫做组件的集合
-使用Excel中的一个硬编码列表
-使用一个MDX从所有产品合并中获得所有子项。