Add tokens for Essbase substitution variables.
| Overload Name | Description |
|---|---|
| General | Add a token for one or more Essbase substitution variables. |
Add a token for one or more Essbase substitution variables.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| EssbaseConnectionID | The Essbase connection ID. |
| Username | The username to use. |
| Password | The password to use. |
| MatchType |
Specify how to match the value entered for SubstitutionVariable.
Specify one of the following values or an arbitrary value:
<blank>ExactRegularExpression
|
| SubstitutionVariable | The substitution variable name, or a regular expression, depending on the value of MatchType. |
| Scope |
Specifies the scope of the substitution variables for which tokens are added. The default scope is Any, which queries for the most locally scoped variables.
Specify one of the following values or an arbitrary value:
<blank>AnyServerApplicationCube
|
| TokenName |
The name of the token to create, like [T.Product]. If TokenName contains " |
| TokenType |
Specify whether to create an application or view token.
Specify one of the following values or an arbitrary value:
<blank>ApplicationView
|
| SyncTokens (8.1) |
Whether to sync the token table after adding the tokens. If not specified TRUE will be used.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|