Hi There
I am loading data from R/3 to ODS to Cube in the background.In Process Chain,They have done like first loaded to ods and activated then they have been loaded from ODS to Icube and deleted indexes and created indexes then compressed.
How it could work and what is the use delete and generate index variant in the PC's?
Thanks in advance.
Regards,
Chandu.
Hi Chandu,
The chain looks correct. Though you may have the delete indexes step before the cube load and also Compression step before the create indexes step.
The indexes are meant faster retrieval of data from the cube. Since the indexes are created for the data existing in the cube they need to deleted and recreated each time the cube is updated with new data.
Bye
Dinesh
Hi,
The user of index on infoprovider is to improve the performance when bex query is executed.
Deleting of index is done to align the new data in the cube. After the load is finished creation of index is done.
Hope this helps!!!
Add a comment