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 these steps:

Procedure

  1. Remove all visualizations in the Spotfire analysis.
  2. Define the slicers that are needed by filtering the appropriate dimensions in the Data panel.
    When you define your slicer member in a hierarchy filter you:
    1. Locate and select the slicer member in the filter for the hierarchy.
    2. Right-click on the slicer member and select Deselect Other Values from the pop-up menu.
  3. Create the visualization (spreadsheet) by clicking the Cross Table button in the toolbar.
  4. Specify your measures and dimensions on the various axes in the cross table (spreadsheet).

Result

The cube data is ready to be analyzed.
Tip: If you always want to view a cross table when you create a new Spotfire analysis, you can make the cross table your default visualization (the visualization that is shown when you bring in new data). To do that, select Tools > Options, go to the Document page, and set Initial visualization when loading data to Cross Table. If you want the filter panel to be automatically displayed, you can select the Filters panel open by default check box in the same dialog.