|
This manual is in pilot operation.
|
|
Unless otherwise specified, the examples of expressions given in this section demonstrate non-member selection dialects. Member selection expressions and other dialects may interpret the same expression differently because objects specified by label constants differ, as explained here.
|
To use an object, first specify the object and then call a "method" associated with it. Methods are means to retrieve information related to the object. Using methods, one can obtain information such as the object’s label or name, or, if it is a cell range object, the total of the cell values within the range.
To call a method, follow the expression that specifies the object with a .
(period), and then write the method name. If arguments are to be passed, they are enclosed in parentheses following the method name (some methods do not require arguments). A method always returns a single value, which can be further used for calculations or conditions assessments.
Here are examples of using objects and methods:
1 |
The name of the 'current member' of the 'Accounts' dimension |
#ACCOUNT!@CUR!#ACTIVE.Label (1)
1 |
The label of the property '#ACTIVE/Is Active' value ('TRUE/In use' or 'FALSE/Not in use') for the 'current member' of the 'Accounts' dimension. |