List of Text Expression Dialects

Designer Administrator
This manual is in pilot operation.

Text expressions have "dialects" based on the object used and the location of use. The types of dialects and the differences in specifications for each dialect are as follows:

Object Used

Location of Use

Object Specified by Label Constants

Content of Dimensions

Usability of Ledgers

Usability of Ledger Editions

Dialect-specific Functions (*2)

Dimension Variables

Member Variables

Cell Range Specifier

Current Dimension

Current Member

Point of View Member

Responsibility Key Member

Unary Format

Binary Format

Member List

1)

Member Selection Expression

Member Property Object (of target member)

Only includes target dimensions of the member list (*1)

Not Usable

Not Usable

@relative_position(*3)
@participant_label(*4)
@depth(*6)
@height(*6)
@find_in_path(*8)

Dimension to which the member list applies

Target member

Member linked to document (*9)

Member specified by "Responsibility Keys" in Participants

Not Usable

2)

Member Selection Expression ("Input Condition" in Form Parameter)

Member linked to document

3)

Member Selection Expression ("Input Condition" in Loop Specification )

Member linked to higher order loop item

Ledger Mask

4)

Ledger Mask Conditions

Dimension Object

Includes dimensions other than Relative Periods and Views

Usable

(None)

(Empty) *5

Member linked to the ledger cell whose accessibility is checked

(Empty) *5

(Empty) *5

Not Usable

Access Permission Type

5)

Read/Write Permission Area Definition Expression

Usable

@participant_label

Member specified by "Responsibility Keys" in Participants

Member specified by "Responsibility Keys" in Participants

Form

6)

Local Ledger Mask Expression

Includes all dimensions within the application

Member linked to document cell

Member linked to document

Member specified by "Responsibility Keys" in Participants *4

Not Usable

7)

"Formula" in Column/Row Specification

Usable (*7)

@participant_label
@depth(*6)
@height(*6)

Usable

Usable

8)

"Formula" in Cell Specification,
"Validation Rules",
"(Validation) Message",
"Drill-down Executable Condition"

Not Usable

9)

"Column/Row Title"
in Column/Row Specification,
"Drill-down Executable Condition"

@participant_label
@depth(*6)
@height(*6)

Member linked to column/row

Not Usable

10)

"Loop item title"
in Loop Specification,
"Drill-down Executable Condition"

Member linked to each loop item

11)

"File Header" in Export Specification

@participant_label

Member linked to document

12)

"Unit Indication" in Report Format

13)

"Derived fields > Expression" in Import Specification

Field Object

Not Usable

@participant_label
@field_key

(Excel-Link)

14)

"Text Value Display Condition" in Linked Region Settings

Dimension Object

(None)

Member linked to Excel cell

(Empty) *5

(Empty) *5

*1 Member lists defined within forms include all dimensions in the application.
*2 In addition to the dialect-specific functions, there are functions that can be used in all expressions.
*3 Usable only for the Fiscal Years and Relative Periods dimensions.
*4 When the member list or form is launched by the designer, @participant_label returns a blank string, and the Responsibility Key Member becomes empty. Additionally, the same applies to member lists specified as Iteration conditions in Excel-Link > Sheet Attributes > Template Processing.
*5 An empty value is a dummy object representing a non-existent target, with all label, name, and property values being blank strings.
*6 Functions, depth and height without arguments, used only in Member Selection Expressions (fusion_place >=v12.1), differ from similarly named functions with arguments used in formulas in Column/Row Specification and Cell Specification within forms.
*7 fusion_place >=v12.2
*8 fusion_place >=v15.0
*9 In the Member Selection Expression of a parameter, the selected value of another parameter cannot be referenced.

Additional information

1. Member variables

"Current Member," "Point of View Member," and "Responsibility Key Member" are members obtained by applying the @CUR function, @POV function, and @RKEY function to dimension objects, respectively.

The specific member obtained varies depending on the situation when the formula/ expression is executed, and they are collectively called member variables.

2. Member linked to each object

The "member linked" to each object is obtained from the following sources.

Object Source of member linked to each object Member arbitration method

① Document

(1) Members specified by the user as parameters when creating documents
(2) Members specified in the "Default Settings" within the form

Priority Order (*1)

② Loop Item

(1) Members (in the member list) that are the source of the loop item
(2) If there are multiple loops, the member is specified by (1) for the loop item enclosed by another loop item (smaller loops take priority).
(3) Members linked to document *1

Priority Order (*1)

③ Column/Row of Document

(1) Members specified by the "Column/Row Specification" of the form
(2) Members linked to the loop item to which the column/row belongs (see above ②)
(3) Members linked to document *1

Priority Order (*1)

④ Document Cell

(1) Members specified by the "Cell Specification" in the form
(2) Members linked to column/row *2

Priority Order + Column/Row Arbitration (*2)

⑤ Ledger Cell

(1) Members specified when accessing the ledger

―

⑥ Excel Cell

(1) Members specified as keys for each cell, by rows/columns, or specific cells on the Excel sheet

―

*1 If members are specified in multiple sources for a single dimension, the source with the earlier number takes priority.
*2 If members are specified in multiple sources for a single dimension, the member specified in the Cell Specification takes priority. Whether the column or row takes priority can be specified in the "Arbitration Rules" of the Cell Specification. If not specified, the row takes priority.