List of Text Expression Dialects
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 |
|
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 |
|
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) |
|
Usable |
Usable |
||||||||
8) |
"Formula" in Cell Specification, |
Not Usable |
|||||||||||
9) |
"Column/Row Title" |
|
Member linked to column/row |
Not Usable |
|||||||||
10) |
"Loop item title" |
Member linked to each loop item |
|||||||||||
11) |
"File Header" in Export Specification |
|
Member linked to document |
||||||||||
12) |
"Unit Indication" in Report Format |
||||||||||||
13) |
"Derived fields > Expression" in Import Specification |
Field Object |
Not Usable |
|
|||||||||
(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 |
Priority Order (*1) |
② Loop Item |
(1) Members (in the member list) that are the source of the loop item |
Priority Order (*1) |
③ Column/Row of Document |
(1) Members specified by the "Column/Row Specification" of the form |
Priority Order (*1) |
④ Document Cell |
(1) Members specified by the "Cell Specification" in the form |
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.