dbTalk Databases Forums  

MS-OLAP Issue...

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


Discuss MS-OLAP Issue... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jags_32@yahoo.com
 
Posts: n/a

Default MS-OLAP Issue... - 10-12-2005 , 02:47 PM






We are encountering a very peculiar error in our DW environment. The
OLAP database on our PRODUCTION Server contains many cubes and one such

cube was processed as part of a job which ran to completion. However,
the data the cube reports is wrong and totally different than the one
we get running a direct SQL against the underlying database. We moved
this OLAP database to a different (DEV) server, reprocessed the cubes
(without changing the datasource) and this cube reports the correct
data!! Has anyone encountered such an issue and if so, what exactly the

problem here. We are in touch with MicroSoft but they do not have any
answers yet. Thanks in Advance.


Thanks
Jagannathan Santhanam


Reply With Quote
  #2  
Old   
Paul
 
Posts: n/a

Default RE: MS-OLAP Issue... - 10-13-2005 , 09:46 AM






Hi,
Have you installed SP4? if not check it out as it may cover your issue.
Ta
Paul

"jags_32 (AT) yahoo (DOT) com" wrote:

Quote:
We are encountering a very peculiar error in our DW environment. The
OLAP database on our PRODUCTION Server contains many cubes and one such

cube was processed as part of a job which ran to completion. However,
the data the cube reports is wrong and totally different than the one
we get running a direct SQL against the underlying database. We moved
this OLAP database to a different (DEV) server, reprocessed the cubes
(without changing the datasource) and this cube reports the correct
data!! Has anyone encountered such an issue and if so, what exactly the

problem here. We are in touch with MicroSoft but they do not have any
answers yet. Thanks in Advance.


Thanks
Jagannathan Santhanam



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.