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 |