Lesson: Navigating Through a Worksheet Without Retrieving Data

  To navigate through the worksheet without retrieving data:

1. Select Essbase, and then Navigate Without Data.

   Essbase displays a check mark next to the menu item.

2. In cell D2, double-click the secondary mouse button to drill up on Qtr2.

   Essbase shows the collapsed Year dimension but withholds retrieving data that is changed as a result of drilling up. The cells that normally display data (D3 through D14) are empty.

   

3. In cell D2, drill down (double-click) on Year by pressing Alt.

   Essbase drills down without retrieving data.

4. In cell C3, select Actual, then select Essbase, and then Pivot.

   Essbase executes the pivot but does not retrieve data.

   

   Note:

   You get the same result by pivoting any Scenario members.

5. In cell G1, click the secondary mouse button on Market and drag Market to product 100 (cell A4).

   Essbase executes the pivot without retrieving data:

   

  To navigate without data when using the Keep Only or Remove Only command:

1. Select Qtr1 (cell D2) and Qtr2 (cell E2), then select Essbase, and then Keep Only.

   Essbase retains only the selected members and does not retrieve data:

   

2. Select products 300 (cell B7), 400 (cell B9), and Diet (cell B11), then select Essbase, and then Remove Only.

   Essbase executes the Remove Only command without querying the database for information:

   

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

1. Select Essbase, and then Navigate Without Data.

   Essbase removes the check mark next to the menu item.

2. In cell A3, drill down (double-click) on Market.

   Essbase drills down on the Market dimension and retrieves data into the worksheet: