Values change every time

Jan 27, 2009 at 1:58 PM
Dear all,

i have downloaded and installed the software.
Unfortunately, each time i run a query against my cube, the results are not the same like the previous time. I don't know
how to interpret this. There are huge differences between two runs, and it doesn't allow me to state which calculated members
are slow and which not.

You got any idea to help me?

Thanks a lot,

laxroth
Coordinator
Jan 28, 2009 at 5:15 PM
It's impossible to identify the problem given the information you gave us. It could be other people/processes using the server or proactive caching or lazy aggregations or the disk cache or network issues.

You might have more luck posting your question to the Analysis Services forum and giving all the information you have and asking for help tracking down inconsistent performance.
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/