Mode Page (Essbase Options Dialog Box)

The Mode page controls Advanced Interpretation, Free Form retrieval, Update mode, and Formula Preservation settings.

Dialog Box Items

Advanced Interpretation—Select to retrieve data into a spreadsheet using optimized querying. This is the default option.
Free Form—Select to enter report script commands into the report.
Note:
If you are connected to an application and database that supports duplicate member names, you cannot perform Free-Form retrievals.
Template Retrieve—Select to define reports using the Essbase report script command language. Report script commands let you select data items and place them in a row or column of the worksheet. The major difference between template retrieve mode and the standard retrieval mode is its ability to dynamically query branches of members in dimension trees. For example, if you must create a report that shows every product, including those added since the last retrieval, standard retrieval mode only reflects these changes when you zoom in on the product.
- In Template Retrieve mode, the Zoom, Keep Only, Remove Only, and Pivot options are unavailable.
- If you are connected to an application and database that supports duplicate member names, you cannot use Template Retrieve mode.
Update Mode—Select to automatically lock the corresponding database area with each retrieval. You must disable Update mode to stop locking blocks automatically.
Note:
Update mode applies only to block storage databases.
When you are in Update mode, the Send command (which updates the server with data values from your spreadsheet) does not automatically unlock data after the send.
- Retain on Retrieval—Select to define retrievals which retain formulas in the worksheet.
- Select Advanced Interpretation to enable Retain on Retrieval.
- Select the Retain on Retrieval and Essbase disables the #Missing Rows and Zero Rows suppress options on the Display page.
  By default, a retrieve overwrites formulas in the retrieval area of a worksheet with data values. The retrieval process also eliminates formulas in cells outside the retrieval area.
Retain on Keep and Remove Only—Select to retain formulas in the worksheet after a Keep Only or Remove Only operation.
Note:
You must select Retain on Retrieval to enable the Retain on Keep and Remove Only options.
Retain on Zooms—Select to retain formulas in the worksheet after a Zoom In operation. This option applies to zooming in and out on a member.
- If you select Retain on Retrieval, Retain on Zooms is enabled.
- If you select Retain on Zooms, the Remove Unselected Groups option on the Zoom page is not available.
Formula Fill—Select to replicate the formulas and formatting styles found in the underlying region.
Formula Fill becomes available when you select Retain on Zooms.