Loading Transaction Data 

The InfoCube can be loaded in parallel by either portioning by calendar year/month (time characteristic 0CALMONTH) or by structuring a MultiCube. Note that each InfoCube of a MultiCube contains the data of one year only

In BW, you must ensure that the package size in the ROIDOCPRMS table is large enough (between 20,000 and 50,000 kB) to pre-aggregate the data while it is being loaded to the PSA. The value can also be maintained in the scheduler for the 0UC_ISU_CONSUMPTION DataSource. To do this, choose Scheduler ® Data S. Default data transfer from the menu. Billing may result in the occurrence of identical records for the same key; these can be pre-aggregated during PSA loading

The following notes apply to both the initial and delta load:

·        Delete the secondary indexes for the fact table before the load and then restructure them.

·        Activate the number range buffering for the dimension table. For a detailed description see the SAP service market place, under http://service.sap.com/bw® Performance ® ASAP Performance Tuning.