Loading dimension data into Hyperion Essbase

You can use the Pack for Hyperion Essbase to sequentially load dimension data into Hyperion. The Pack does not support loading dimension data in parallel.

1. Select dimension data as the Data type and click Configure Metadata to start the import wizard.
2. Click Outline, click Next, and select member properties that you want to insert new or update existing members in the outline.
3. Click Import. The columns grid of the input link and reject link (if present) are populated with the appropriate columns.
4. Select the dimension data write mode.
   • Select Insert to insert new members.
   • Select Update to update existing members with new property values.
   • Select Upsert to insert new members if they don't yet exist in the outline, or update them if they already exist in the outline.
5. Click Run to load the selected data in to Hyperion Essbase.