Hi LinusH, Yes, I am accessing an OLAP cube by WRS,and it's the cube drill-thru table. The data contains 1,74,868 rows, i am trying to drill a data of 92329 rows and 208 columns which results in error. I have done it in Base SAS using where clause and every time the resultant varies. NOTE: PROCEDURE SQL used (Total process time): real time 3.63 seconds user cpu time 1.07 seconds system cpu time 2.04 seconds memory 1082.37k OS Memory 7608.00k Timestamp 06/13/2014 01:26:23 PM NOTE: PROCEDURE SQL used (Total process time): real time 3.07 seconds user cpu time 0.88 seconds system cpu time 2.18 seconds memory 983.12k OS Memory 7608.00k Timestamp 06/13/2014 01:27:18 PM NOTE: PROCEDURE SQL used (Total process time): real time 3.99 seconds user cpu time 0.92 seconds system cpu time 1.90 seconds memory 983.12k OS Memory 7608.00k Timestamp 06/13/2014 01:38:35 PM I have done the same in SAS EG using where clause. NOTE: PROCEDURE SQL used (Total process time): real time 2.80 seconds user cpu time 0.88 seconds system cpu time 1.90 seconds memory 985.50k OS Memory 18476.00k Timestamp 06/13/2014 01:28:18 PM NOTE: PROCEDURE SQL used (Total process time): real time 2.64 seconds user cpu time 0.90 seconds system cpu time 1.73 seconds memory 990.59k OS Memory 18476.00k Timestamp 06/13/2014 01:28:41 PM NOTE: PROCEDURE SQL used (Total process time): real time 2.79 seconds user cpu time 0.96 seconds system cpu time 1.82 seconds memory 983.43k OS Memory 18476.00k Timestamp 06/13/2014 01:29:02 PM Every month data will double as to maintain historic data i cannot drill 10 rows of CE Product which can be seen in above picture from a total records of 66,00,000 lakhs data. The same is performed in EG NOTE: PROCEDURE SQL used (Total process time): real time 23:41.82 user cpu time 15.91 seconds system cpu time 36.72 seconds memory 1004.56k OS Memory 18476.00k Timestamp 06/17/2014 02:31:10 PM
... View more