Cache Warming

Hi,

I have a cube, which is having a lot of calculated measures.

There are some MDX queries which fetches data from the cube, and aggregates data through a parent -child hierarchy.

It is taking considerable amonut of time.

So , for improving the performance i have written a c# program which executes all the possible MDX queries just after the daily refresh of the cube. As expected it was really giving noticable performnace improvement.

But the problem started when i deployed the cube and the cache warmer into another server, where the cache warmer is executed by Sql Agent, with the service account which is a local admin on that box. The warmer program executed fine, but i am no longer able to find the performance improvement. I understand that , the global cache will be shared across the users only if the users are having same security role in the cube.

So i added the sqlagent service account to the role whiich execute the MDX in the application. But still it is not helping me

Please help me.

Also i would like to know, whether clearing the cache everyday would help in any way in this scenario.

Regards,

Jiju

Somebody please tell me whether I am doing any blunder stuff here, at least

Regards,

Jiju