dbTalk Databases Forums  

Storage design wizard freezing (not repsonding) AS2K

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


Discuss Storage design wizard freezing (not repsonding) AS2K in the microsoft.public.sqlserver.olap forum.



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

Default Storage design wizard freezing (not repsonding) AS2K - 08-04-2006 , 11:27 PM






Hello,

I have a cube for which the storage design wizard freezes at a particular
number of aggregations. It is exactly repeatable - always stopping at the
same number of aggregations. It happens when I add a new virtual dimension.
When I remove that dimension, it will continue on beyond that point with no
problems.

If I stop design storage at a smaller number of aggregations, the cube
processes fine and works fine.

Any ideas how to touble-shoot this one?

Thanks
--
Les Russell

Reply With Quote
  #2  
Old   
Bernhard Saemmer
 
Posts: n/a

Default RE: Storage design wizard freezing (not repsonding) AS2K - 08-07-2006 , 02:58 AM






Hi,

how big is Your cube?

It's a thing of patience I think.

I had a cube which storage design time needed about 4 days and proccessing
itself needed 9 hours.

Give it a try over weekend.

After all I don't know whether it's a thing of virt. Dimensions.

Greetings
Bernhard


--
CS Result GmbH
Bischof-von-Henle-Str. 2
93051 Regensburg


"Les" wrote:

Quote:
Hello,

I have a cube for which the storage design wizard freezes at a particular
number of aggregations. It is exactly repeatable - always stopping at the
same number of aggregations. It happens when I add a new virtual dimension.
When I remove that dimension, it will continue on beyond that point with no
problems.

If I stop design storage at a smaller number of aggregations, the cube
processes fine and works fine.

Any ideas how to touble-shoot this one?

Thanks
--
Les Russell

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.