We have implemented a calculated members which involves multiple calculated members called in a nested e.q.
Cal1 calls Cal2 and Cal2 calls Cal3 and
Cal3 calls Cal4 . And when browing
Cal1 through Excel it takes around 30 mins for getting result from a Partition having row count around 5 million.
Follwing are the information on the scenario I am having:
We are having partitioning in the cube. one partition contains around 4-6 million records Processers on Query Server: 4 quad core RAM on the Query Server: 64 GB Calculated members having simple calculation logics are giving results in no time.
There is a Calculated members which calls 6 intermediate calculated in nested way and with small Data Set like 5-6 k rows it is running fine.
Any help will be much appreciated.
View Complete Post