cancel
Showing results for 
Search instead for 
Did you mean: 

Data laods taking more time to complete

Former Member
0 Kudos

Hi,

we have some sale stats cubes which are laoding daily on avg Million records.

We are creating indexes after that then creating aggregates.

Both of these process are taking 2-3 hrs each.. even though we have 0 records in weekends its taking same time toc omplete.

Can anyone suggest us what will be better way to create indexes and roll up data?

Thanks

Sivaprasad

Accepted Solutions (0)

Answers (1)

Answers (1)

dennis_scoville4
Active Contributor
0 Kudos

Are you compressing the InfoCubes after a specific period of time (e.g. requests 30 or more days old)? Compression will help reduce the number of aggregates and index addresses to create and therefore reduce the runtimes for each.