Hi Mark,

When I calculate time to execute MDX query using steps I mentioned in my previous message, the query takes 12 minutes to execute.

Using perfmon I observed that query is...

Hi Mark,

Thanks for reply.

How can I use "set statistics time on" for MDX query?

Hi Mark,

Steps I followed to check performance improvement:

1. Execute MDX query and record time to execute.

2. Create 10000 entries in QueryLog table with dataset used in previous query and duration...