Hi All,
Is there a way to improve the speed of creating index to cubes? I have process chain which does data load to PSA->DSO->cube it takes only 2 minutes to do it while the creation of index takes 10 minutes.
Is it possible to speed up index creation? I know for reporting cube index will speed up the execution other than is it mandatory to do this step delete index and create index in process chain? what if I schedule this step as a sperate process on nightly basis only creating the index.
without deleting index will the load take more time? Let me test it.
Thanks,
Anand