Edit OLAP Formula wizard
To open the Wizard, click on the Objects toolbar.
You can create formulas with the Edit OLAP Formula wizard, or with the Insert Function dialog.
We recommend that you use the Edit OLAP Formula wizard to create formulas such as ROC, in which the order of the referenced dimensions is important.
The layout of the Edit OLAP Formula dialog varies according to the type of formula you select from the Formula type list.
This table shows the formulas that are created by selecting different formula types and options. For example, to create a ROC formula, select from the Formula type list and select Fixed mode:
| Formula type | Options | Resulting formula |
|---|---|---|
| Cell values | CELLGET | |
| Allow writeback | Writable CELLGET | |
| Fixed mode | ROC | |
| Fixed mode + Allow writeback | RWC | |
| Cell notes | NOTEGET | |
| Fixed mode | RON | |
| Fixed mode + Allow writeback | RWN | |
| Cell properties | CELLPROPERTYGET | |
| Allow writeback | Writable CELLPROPERTYGET | |
| Slice values | SLICEGET | |
| Allow writeback | Writable SLICEGET | |
| Relational values | RDB | |
| Allow writeback | RWDB | |
| Attributes | ROA | |
| Allow writeback | RWA | |
| KPI values | ROK |