Changing Performance Settings for the Data Source Dimension

By default, the Data Source dimension is configured as "Sparse" because that setting provides better performance.

Legacy applications, created prior to 19.05, will have the Data Source configured as "Dense". It is recommended that the Data Source dimension for legacy applications be reconfigured to "Sparse".


Changing the performance settings requires a database refresh. Because this refresh will result in an Essbase Database restructure, it may take a long time to complete (potentially hours, depending on your system). Consider updating the performance settings during a down period when other users are not using the system. BEFORE you initiate the database refresh:

  • Ensure there are no active users on the system.
  • Ensure this action will not overlap with the Automatic Maintenance Window.

To verify the current performance setting for your applications:

  1. From the Home page, click the Navigator icon Navigator icon.
  2. Under Create and Manage, select Dimensions, and then select the Performance Settings tab.
  3. Select the required cube.
  4. For the Data Source dimension, under Density, the current setting displays as Dense or Sparse.

To set performance settings:

  1. From the Home page, select Application, and then Configuration.
  2. On the Configure screen, select Performance Settings.
    Performance Settings for Data Source
  3. Select the Data Source dimension density that you require:
    • Sparse (Recommended)
    • Dense

    By default, the density is set to Sparse.

  4. Click Save to refresh the database.
  5. On the Refresh Database dialog box, click OK.
  6. Optional: From the Home page, select Applications, and then Jobs to check the status of the refresh.