Minimizing the Strain on the Oracle Essbase Database


This topic provides some tips on how to put minimum strain on your Essbase database. You can mimic the workflow from Smart View use in Excel by first removing all visualizations, then filtering (slicing) the data, and finally, configuring your visualization.

Mimic the workflow where you configure your visualization or spreadsheet and then refresh to see results, using the steps below.

Suggested workflow:

  1. Remove all visualizations in the Spotfire analysis.

  2. Define the slicers that are needed by filtering the appropriate dimensions in the Data in analysis flyout.

    Comment: When you define your slicer member in a hierarchy filter you:
    a) Locate and select the slicer member in the filter for the hierarchy.
    b) Right-click on the slicer member and select Deselect Other Values from the pop-up menu.

  3. Create the visualization (spreadsheet) by clicking Visualization types    on the authoring bar, and selecting Cross table.

  4. Specify your measures and dimensions on the various axes in the cross table (spreadsheet).

See also:

Spotfire for Oracle Smart View Users