SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

malachi151
Posting Yak Master

143 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:


SELECT 
	[Measures].[Observation Count] ON COLUMNS
FROM
	[Cube]


I get 2,089,887

When I do:


SELECT 
	COUNT(*)
FROM
	Table


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: http://practicaltsql.net/
Twitter: @RGPSoftware

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

micnie_2020
Posting Yak Master

Malaysia
223 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:-
http://www.java2s.com/Code/SQLServer/Analytical-Functions/BasicCUBEQuery.htm

Hope it's help you.

Thank you.

Regards,
Micheale
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000