SSAS 2005 - Hash

09-May-08 07:42:43
Hi,

I have made the cube using BIDS 2005. it has 25 dimensions and around
80 measure groups. The database size is not more than 140 MB.

Till now it processing fine. However from last few days, when I try to
process the database fully, processing of database goes indefinitely.
It continues to show "Deploying and processing". It never completes
the processing of cube.

Any ideas why this is the case?

Thanks.
button
 
 

SSAS 2005 - nolt

10-May-08 05:10:56
The suggestion is using SQL Server Profiler to monitor AS2005 when
processing
to see where is blocked.
maybe the block is Database Engine (Query), I/O, else. The Profiler may tell
you where is it
button
 

SSAS 2005 - Hash

12-May-08 07:04:56
I have run the profiler to monitor AS2005 when processing the cubes.
it is showing this msg:



I am not able to understand. can you please tell me what is it?

Thanks.
Harsh
button
 


BOTTOMCOUNT MDX function