Cube count not equal to total record count

For some reason, the record count (metadata) from OLAP is not equalling the total record count of the fact table if I count them in another application...any ideas of why?Originally posted by pdzubinski
For some reason, the record count (metadata) from OLAP is not equalling the total record count of the fact table if I count them in another application...any ideas of why?
--------------------------
If NULLS exist in your fact table and they are linked in your snoflake you will loose data b/c there is no valid link. I update all NULL values to NA and include NA in all tables to prevent this. Good Luck.

-Carla