Options
The Options parameter builds the toolbar and menu. This parameter is optional. The syntax is:
Options=values
You can specify multiple values. The order of the values determines the order of appearance in the toolbar and in the menu. (The menu is always last.) For example:
&Options=epcrxyadwslfz
| Value | Toolbar button |
|---|---|
| b | Print. Must be used in conjunction with the FR parameter. |
| c | Calculator |
| e | Excel Report |
| h | Submit for Approval |
| i | Approve |
| j | Reject |
| k | Enter/Review Approval Notes |
| m | Hint |
| p | Phasing |
| r | Refresh Data |
| t | Toggle. Use this in conjunction with the NextType parameter. If a NextType is not specified, chart is assumed. |
| u | Autorefresh |
| v | Display Name - Description. Use this option to customize the display of dimension and member names. Only the inner most dimension is affected in a nested dimension setting. If custom text is specified for the down dimension, the custom text is displayed when Display Description is selected. |
| x | Save Data |
| y | Save Data with Local Consolidation |
| Value | Menu command | Data source |
|---|---|---|
| a | Annotation Report | Relational |
| d | Descendants Annotation Report | Relational |
| f | Show Account Details | Relational |
| g | SQL Drill through | Relational |
| n | Number Format menu | Relational |
| s | Save Scenario / Restore Scenario | Relational |
| w | Worksheet Lines | Relational |
| z | Report Definition command | Relational |