Optimizing Data Loads

You can choose to optimize your data loads, a process which ignores any joins and, instead, uses the fact table columns as the data source bindings.

Note:

If you choose to optimize data loads, you should be aware of the possible effects on tables selected as alias tables. See Selecting Tables as Alias Sets.

  To optimize data loads:

  1. Access the dimension properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Dimension Properties Tabs.

  2. Select the Outline Build tab.

  3. Locate the Optimize data load group.

  4. Select Optimize data load.

    Note:

    This option will be ignored if the data load bindings were overridden in the Cube Schema wizard.