dbTalk Databases Forums  

Virtual cubes not processed

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


Discuss Virtual cubes not processed in the microsoft.public.sqlserver.olap forum.



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

Default Virtual cubes not processed - 02-06-2004 , 11:42 AM






I have an application which processes my OLAP database using DSO. My olap
database consists of 4 cubes and 1 virtual cube. After processing all cubes,
including virtual cube, I archive and then restore the db to a production
server. Eeverytime I do this however, the virtual cube shows up as "Not
Processed". The physical cubes are fine. Any idea on why the virtual cube
loses it's "Processed" state? If I reprocess it on the production server, it
displays data just fine, so I know the cube isn't corrupted.

Any help would be appreciated!

Frank



Reply With Quote
  #2  
Old   
Bas Kersten [MSFT]
 
Posts: n/a

Default RE: Virtual cubes not processed - 02-10-2004 , 03:36 AM






Hi Frank,

This is interesting did you already try to clean the reprository for this
Virtual dimension. Could you test something like this.

-Copy this virtual dimension trough the AS manager to another server will
only copy metadata (simply select Virt. d. and r. click copy)
-delete this virtual dimension on system where the problem is seen
-paste the virtual dimension back trough the AS manager (simply select
Virt. d. and r. click paste)
-retry test

Please let me know if it works?
HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."


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.