Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Missing data in cube
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

152 Posts

Posted - 02/06/2013 :  14:57:11  Show Profile  Visit malachi151's Homepage  Reply with Quote
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:

	[Measures].[Observation Count] ON COLUMNS

I get 2,089,887

When I do:


I get 2,784,122

I'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:
Twitter: @RGPSoftware

Edited by - malachi151 on 02/06/2013 16:34:28

Posting Yak Master

232 Posts

Posted - 02/06/2013 :  21:43:46  Show Profile  Reply with Quote
Please have a look at this post:-

Hi Malachi,

Please have a look:-

Hope it's help you.

Thank you.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000