Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Unanswered: 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?

  2. #2
    Join Date
    Sep 2002
    Location
    Chicago
    Posts
    3

    Re: Cube count not equal to total record count

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •