dbTalk Databases Forums  

AS2005: ROLAP dimension problems still here...

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


Discuss AS2005: ROLAP dimension problems still here... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default AS2005: ROLAP dimension problems still here... - 07-27-2006 , 08:19 AM






Hi,

I continue to have a big issue when I try to setup a dimension in ROLAP
mode.

I have completly deleted my dimension and the associated cube.
I recreate the dimension.
and when I activate the ROLAP mode and if the ROLAP proactive caching the
server crash!

if I activate only the ROLAP mode option and save the dimension, the
dimension switch back to MOLAP mode!!!!!
sometimes the server crash, sometimes no!

My dimension contain a parent-child hierarchy.
if I create the dimension without the parent-child, then the Rolap option is
activated (doesn't works, but activated)

what is the problem?
what can I do?

another point, when I try to change the proactive caching option using
Management Studio, the interface disallow me to save the change if I select
the ROLAP or Real time HOLAP option!
while under visual studio, I can select these options (which cause the
server to crash)
When I try to save under mgmt studio, The error is:
TITLE: Storage Settings
------------------------------
The storage mode for a dimension must be either MOLAP or ROLAP.

Thanks.

Jerome.



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.