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
Result
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
, 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.
Copyright © TIBCO Software Inc. All rights reserved.