SET commands tell Integration Server which data sources are involved in a load operation. LOAD commands tell Integration Server to execute a load operation.
To perform a successful member and data load, the SET commands must be executed before the LOAD commands. |
SET commands provide Integration Server with the location of the source databases, Essbase Server, and OLAP Metadata Catalog. The commands can be issued in any order, but you must issue all three SET commands before executing a LOAD command.
The STATUS command (see STATUS) does not check or validate the syntax for SET commands.
LOAD commands use the information from the SET commands to load members, data, or both. Use the LOAD commands as follows:
Loads members into an Essbase outline. You must load members before you load data. | |
Loads data into an Essbase database. You cannot load data without loading members. | |
LOAD commands for small outlines (fewer than 1000 members) take a few seconds to execute. Larger outlines (1000 or more members) take a few minutes to a few hours, depending on the amount of data being loaded, the configuration of the metaoutline, and the computer system capabilities. After executing LOAD commands, wait a few seconds until the command prompt (->) is displayed and then use the STATUS command to check the success or failure of the command execution.
See Peforming Member Loads Using Integration Services Shell for a sample sequence of commands for loading members.
See Loading Data Using Integration Services Shell for a sample sequence of commands for loading data.