I have loaded a infocube with huge number of records, load is a from a Standard DSO to cube, there were 900 requests in the DSO, so I did not prefer the delta load as request by request, instead data is loaded from active data table. it ended of having 500 million records in one request and took 9 hours.
After that, I started the compression of the request, it was running for 3 days, basis Cancelled the job at last. After that I am trying to go to Manage tab of the cube, it is not responding, I can't display the data in cube by LISTCUBE also, it is spinning for a long time and not responding.
I have performed a RSRV check 'Data base indices of an Infocube', it failed with an error as, ****/bic/E fact table index is not valid. I have tried to correct the error by running repair, the action is taking long time but did not complete the job and getting to dump as it timed out.
I requested Basis team to re generate the Index, they were not able to do that because they are getting a message that, index is not created so can't be built.
Could you please let me know, how do I correct this issue?