dbTalk Databases Forums  

Help--Cube not processing

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Help--Cube not processing in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
debora orf
 
Posts: n/a

Default Help--Cube not processing - 12-30-2003 , 10:35 AM






I have a cube with 2 dimensions of each 3 levels + 1 time
dimension. Fact table is close to 2 million rows.

If I add a fourth level to one of the dimensions with 3
levels, the member count of the lowest level is 452828.

When the cube processes it hangs at either the commit
stage or writing out the last aggregation. I've tried the
VLDM suggestions as per the knowlege base, but I don't
think a dimension with a member count of 452858 would be
handed off to the VLDM. I'm not seeing the vldm on the
task manager either when the process hangs.

I'm not sure what is going on with this problem. If i
remove the fourth level, everything processes fine.

Any help would be appreciated

Thanks,

--deb

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.