dbTalk Databases Forums  

Very strange cube data problem

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


Discuss Very strange cube data problem in the microsoft.public.sqlserver.olap forum.



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

Default Very strange cube data problem - 09-15-2003 , 02:48 AM






Hi
Please help me, im having a VERY strange error showing up
in the cubes. The problem only occures in some weeks (we
are using partitions and have splitted the cube up by
week).
It sows up like:
Group1 Group2 Group3 total Grandtotal
Store1 12234 12234 12234 12234 12234
Store2 34564 34564 34564 34564 34564
Store3 13422 13422 13422 13422 13422
...
...
...

It seems to calculate wrong. As you see above all figures
are the same and that is not correct.
The data in the dataware house tables are correct.
Both the client (OWC and Excel) shows wrong figures. So
does the cube in AS. For example; the sum of the children
can be more than the parent!(that shoulnt be possible,
correct?!?)

The only thing that has been installed is the sequrity
patch kb824146 last Thursday. The morning after did the
strange errors occur.
Could you give me a clue? Is the OLAP-database corrupt? Is
there any way to confirm that?
Could the patch give me problems?
The same problem seems to occure in more then this cube

PLEASE HELP!

Jesper

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

Default Re: Very strange cube data problem - 09-15-2003 , 12:51 PM






I dont have a clue as to why this happened, but a full processing of the
cube should get rid of this discrepancy, as it did for me in the past.

- Raj

"Jesper" <Abrahamshill (AT) hotmail (DOT) com> wrote

Quote:
Hi
Please help me, im having a VERY strange error showing up
in the cubes. The problem only occures in some weeks (we
are using partitions and have splitted the cube up by
week).
It sows up like:
Group1 Group2 Group3 total Grandtotal
Store1 12234 12234 12234 12234 12234
Store2 34564 34564 34564 34564 34564
Store3 13422 13422 13422 13422 13422
..
..
..

It seems to calculate wrong. As you see above all figures
are the same and that is not correct.
The data in the dataware house tables are correct.
Both the client (OWC and Excel) shows wrong figures. So
does the cube in AS. For example; the sum of the children
can be more than the parent!(that shoulnt be possible,
correct?!?)

The only thing that has been installed is the sequrity
patch kb824146 last Thursday. The morning after did the
strange errors occur.
Could you give me a clue? Is the OLAP-database corrupt? Is
there any way to confirm that?
Could the patch give me problems?
The same problem seems to occure in more then this cube

PLEASE HELP!

Jesper



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.