Dear Team,
We have performed a selective deletion from our sales infocube i.e. ZSD_C03, while loading back the data it takes a huge amount of time.
Initially, we try to load for one sales org and billing date greater than equal to 01.04.2010 it took 24+ hours but hardly loaded 210+ requests out of 2500+ requests in PSA, later we canceled this load
Then we try to load one sales org and billing date greater than equal to 01.04.2016 after running for more than 15 hours it has hardly loaded 500+ requests though it has only added 64 records, after this, we have stopped the data load assuming something is going wrong.
Then we have identified which dimension is the heaviest in the infocube via SAP_INFOCUBE_DESIGNS and changed its properties to High Cardinality at the same time we have dropped the indexes again.
After this, we have again started the data loading from PSA to infocube with only one-year data i.e. one sales org and billing date greater than equal to 01.04.2018, this particular data loading is running for more than 09 hours now but only 64 records have been extracted and 20 of them are added.
When I check in SM50 about this data load it is showing Executed Program as CL_RSBM_ERROR_HANDLER_DATA====CP & Current action info RSBERRORLOG
If possible, Please help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.