dbTalk Databases Forums  

MSAS 2005 Cube Partition Issue

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


Discuss MSAS 2005 Cube Partition Issue in the microsoft.public.sqlserver.olap forum.



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

Default MSAS 2005 Cube Partition Issue - 07-18-2006 , 02:55 PM






Hi,

I have a cube that has 10 monthly partitions. I processed the whole cube.
The build was successful. There were no errors. But when I browsed the cube,
I see data in all the partitions except the 1st one.

I re processed the 1st partition alone. It took good 10 minutes to read 2.8
Million rows, aggregated data and the size was 150 MB.

Again, it won’t show data just for the first one. This time I deleted the
partition, re-created it and processed it again.

The build was successful. But still no data. Please let me know what could
be the reason for this. Can I find any thing in the XMAL script for this
partition that has a corrupted tag?

Would restarting the MSAS service help?

Thanks in advance for your help.

Prasad.

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.