Hi,
I have SQL Server 2005 SP1 Hot Fix 2153.
I created one small OLAP cube and when browse it, speed was acceptable.
(with "Browse" tab)
When I creates report, which referent to the cube, msmdsrv.exe (AS
component) take 100% from CPU.
When I delete fact table, re-process cube and tryed to ada it again in a
report, situation was a same.
Do you have an idea why that happens ?

Thanks
Siol En


*** Sent via Developersdex http://www.developersdex.com ***

what is the MDX query used?
what's appends when you run the same query on the server using the
management console?

"Siol En" <siol_en (AT) hotmail (DOT) com> wrote