Appearance
Show Formulas
Shows the formulas.
Permissions
| Command Kind | Needed User Kind |
|---|---|
| Read | All |
Parameters
| Name | Type | Description | Required | Default | Values |
|---|---|---|---|---|---|
| Dimension | string | Name of the dimension ([Dimension]). | yes | ||
| Find | string | Value to search for in name and captions. | no | ||
| MaxRecords | integer | Maximum number of records to be returned. The default value is 500000. | no | 500000 | |
| Sort | string | Sorts the output by name or caption ([Field].[Caption1]). The field can be [Formula]/[Name], [Caption1], [Caption2], [Caption3], [Caption4], [Caption5], [Caption6], [Caption7], [Caption8], [Caption9], [Caption10]. Sort can be Ascending (Asc) or Descending (Desc), e.g. [Caption1].[Ascending] | no |
Result
| Name | Type | Description |
|---|---|---|
| Formula | string | Name of the formula. |
| Caption1 | string | Caption 1 |
| Caption2 | string | Caption 2 |
| Caption3 | string | Caption 3 |
| Caption4 | string | Caption 4 |
| Caption5 | string | Caption 5 |
| Caption6 | string | Caption 6 |
| Caption7 | string | Caption 7 |
| Caption8 | string | Caption 8 |
| Caption9 | string | Caption 9 |
| Caption10 | string | Caption 10 |
| Default | boolean | If 'True' the formula name '<Default>' is a reference to this formula. |
| Sums | integer | Number of sums of the formula. |
| Items | integer | Number of items of the formula. |
Code
text
SHOW FORMULAS
DIMENSION=[string, Needed]
FIND=[string]
MAXRECORDS=[integer, default=500000]
SORT=[string]