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 |
|
malachi151
Posting Yak Master
152 Posts |
 Posted - 2013-02-06 : 14:57:11
|
I have a cube that pulls from a database, and the fact table is based on a direct table in the DSV, not a Named Query, but the cube somehow doesn't contain all of the records that are in the database table, and I can't figure out why.If I simply do a straight count of the records in the cube and in the table I get two different numbers:SELECT [Measures].[Observation Count] ON COLUMNSFROM [Cube] I get 2,089,887When I do:SELECT COUNT(*)FROM Table I get 2,784,122I'm expecting the same exact number here.In addition, the missing records are somehow associated by certain dimensions.I notice, for example, than when I look at a single customer by state, that for that customer who has records in 48 states, the count of records in each state exactly matches the count of records by state for that customer in the database, EXCEPT for 4 states that are completely missing.In other words, if any records from that state exist in the cube, then all of them do, but for 4 states none of them do.This is why I got just a total count to make sure that it wasn't something with the dimension, but the total counts are off as well.In addition, I did the joins to the state dimension in the database exactly how they are done in the DSV in the cube and I get the correct number of records when doing it in the database.Any ideas on what the issue might be, or how I can better troubleshoot this?--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
micnie_2020
Posting Yak Master
232 Posts |
|
|
|
|
|
|
|
Missing data in cube