fact table count

#1

Hello,

I created a nice OLAP cube and wanted to verify the data. When verifying I
discovered that some results aren't correct. It seems like Analysis misses
some records of the fact table.

Select count(*) from fact_table --> 14166
In Analysis --> properties fact_table it sais fact table size = 14162

Question: Where are the missing records?

Regards,

Rob

#2

I found the problem. I missed some members in a dimension table.

Thanx anyway.

Rob

"Rob" <legedoos__ANTISPAM__ (AT) hotmail (DOT) com> schreef in bericht
news:2iqov2FqhmgpU1 (AT) uni-berlin (DOT) de...

Quote:

Hello,

I created a nice OLAP cube and wanted to verify the data. When verifying I
discovered that some results aren't correct. It seems like Analysis misses
some records of the fact table.

Select count(*) from fact_table --> 14166
In Analysis --> properties fact_table it sais fact table size = 14162

Question: Where are the missing records?

Regards,

Rob

#3

You can have missing records if they are linked to
missing members in dimension(s).

Abhinav Kumar
akumar (AT) itmag (DOT) com.au

Quote:

-----Original Message-----
Hello,

I created a nice OLAP cube and wanted to verify the
data. When verifying I
discovered that some results aren't correct. It seems
like Analysis misses
some records of the fact table.

Select count(*) from fact_table --> 14166
In Analysis --> properties fact_table it sais fact table
size = 14162

Question: Where are the missing records?

Regards,

Rob

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

fact table count

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

fact table count - 06-10-2004 , 04:45 AM

Re: fact table count - 06-10-2004 , 05:59 AM

fact table count - 06-10-2004 , 07:31 PM