Skip to Content
0
Former Member
Mar 18, 2009 at 02:49 PM

Problem in loading large data in cube

59 Views

Hi All,

I have to load 4 Million records in cube , which is meant for data backup only .

It does'nt have any reports based on it.

The background job BI_BTCH* loads cube in 1500 sec and make it available for reporting.

sometimes, it runs for 25000 sec even if all processing is complete.

My questions are :

1) What parameters can be set , to load it faster ?

2) What can be the reason for job to run for more time ?

Thanks