Essbase provides statistics on the size and number of incremental data slices, and the cost of querying the incremental data slices.
The time it takes for a query to access all of the incremental data slices is expressed as a percentage (between .01 and 1.0 inclusive). If a database has a main slice and multiple incremental data slices, a query statistic of 0.66 means that two-thirds of the query time was spent querying the incremental data slices and one-third was spent querying the main data slice. If the cost of querying the incremental data slices is too high, you can merge the slices.
To view the incremental data slice statistics, see “Viewing Aggregate Storage Statistics” in the Oracle Essbase Administration Services Online Help.