Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jerrymits
Starting Member
2 Posts |
 Posted - 2009-06-04 : 12:55:33
|
| Using SQL Server 2005. Apologies for the crude terminology, I am new to this technology and am trying to find my feet.We have a cube which essentially sits on top of the DB, which we use for reporting.It seemed to be working fine until very recently, but after some new data was added, it seems to be incorrectly stored in the cube. The results I see when I browse the cube are exactly 3 times the original values stored in the database. It seems as though somewhere the data is being modified between the database and the cube. Any ideas where I should be looking, to try and debug this problem? Many thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-04 : 13:24:43
|
| i think the problem is the way you set up relation between two or more dimension. it would be better to see how you've set the relationship in your cube by opening the definition in analysis service project. between are you using views of taking tables directly in cube definition? |
 |
|
|
jerrymits
Starting Member
2 Posts |
Posted - 2009-06-05 : 10:32:37
|
| Thanks for the response. It was actually a stupid mistake on my part. There were duplicate rows in the underlying database - these were getting added up, and the sum was displayed in the cube. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-05 : 13:34:18
|
| ok...glad that you found it out |
|
|
|
|
|
|
Data different in cube to the underlying DB