During loading, perform steps in below order −

First load the master data in the following order: First attributes, then texts, then hierarchies.

Load the master data first and then the transaction data. By doing this, you ensure that the SIDs are created before the transaction data is loaded and not while the transaction data is being loaded.

To optimize performance when loading and deleting data from the InfoCube −

• Indexes
• Aggregates
• Line item and high Cardinality
• Compression

To achieve good activation performance for DataStore objects, you should note the following points −

Creating SID Values

Generating SID values takes a long time and can be avoided in the following cases −

Do not set the 'Generate SID values' flag, if you only use the DataStore object as a data store. If you do set this flag, SIDs are created for all new characteristic values.

If you are using line items (document number or time stamp, for example) as characteristics in the DataStore object, set the flag in characteristic maintenance to show that they are "attribute only".