Minimizing the strain on the Oracle Essbase database

This topic provides some tips on reduce the strain on your Essbase database, when you work with Essbase data in Spotfire. 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.

About this task

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

Procedure

Remove all visualizations in the Spotfire analysis.
Define the slicers that are needed by filtering the appropriate dimensions in the Data in analysis flyout.
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.
To create a visualization, click Visualization types and select Cross table.
Specify your measures and dimensions on the various axes in the cross table visualization.

Results

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 on the menu bar, 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.