ITPub博客

首页 > Linux操作系统 > Linux操作系统 > financial reporting —— MemberName 操作

financial reporting —— MemberName 操作

原创 Linux操作系统 作者:yingzhl 时间:2013-09-26 17:02:37 0 删除 编辑
1.比如要在表头下面显示某某年度,用到

( <>度 )
其中"Grid1"表示表格
A 表示A列
"Year"表示取A列的年份
最后效果是  (2013年度)


2.要在C列取A列的值,(例如A列是Entity),C列设为文本列,直接取
<>   即可

关于memberalias的官档

MemberName

MemberName is a text function. Based on the syntax used, it returns the name of the member assigned to a dimension in the row, column, page, or Point of View (POV).

The following syntax returns the name of a row heading, column heading or page. The syntax can be deployed from any heading cell, text cell or text box object and can reference any grid in a current report.

<"GridName", Row/Col/Page, "DimName")>>

The following syntax returns the name in a row heading, column heading, or page. The syntax can be deployed from any row, column or page heading in a grid that is designated as a custom heading. To designate a custom heading, click the page, row heading or column heading, then select Custom Heading on the property sheet. You can add the function in the space provided below the custom heading.

<"DimName")>>

The following syntax returns the name of a grid or user POV. The syntax can be deployed from any text cell or text box object and can reference any grid and corresponding POV in a current report.

<"GridName", "POV DimName")>>

where:

GridName is the name of the grid.

Row/Col/Page is the numeric identifier of the row, the alphabetical identifier of the column, or the numeric identifier of the page.

DimName is the name of a dimension in the grid row, column, or page.

POV DimName is the name of the dimension on the grid or user POV.

Example:

The following examples yield the name that is assigned to the Product dimension in Grid1, column A:

<>

<>

The following example yields the name for the Year dimension. The syntax is placed on the grid's custom heading:

<>

The following examples yields the name for the Scenario dimension for the POV associated with Grid1:

<>

<>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29182304/viewspace-773426/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2013-09-26

  • 博文量
    2
  • 访问量
    4537