Navigating Through Worksheets Without Retrieving Data

The Navigate Without Data option enables you to perform navigational operations such as Pivot, Zoom In, Zoom Out, Keep Only, and Remove Only without retrieving data into the worksheet.

This feature is useful when dealing with Dynamic Calc members, which are usually specified by the application designer. When Navigate Without Data is selected, Essbase does not dynamically calculate values (that is, calculate the database during retrieval) while you are creating the spreadsheet report.

To navigate through the worksheet without retrieving data:

Select Essbase, and then Options.
In Essbase Options, select Global.
Under Mode, select Navigate Without Data.
Click OK.

To turn off Navigate Without Data when you are ready to retrieve data:

Select Essbase, and then Options.
In Essbase Options, select Global.
Under Mode, clear Navigate Without Data.
Click OK.
Select Essbase, and then Retrieve.

Note:

You turn Navigate Without Data on and off by selecting or clearing the Navigate Without Data option or using the toolbar icon.

Navigating without data also works with the Keep Only and Remove Only commands.