Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: NULL values in Cube Dimension

    I have a fact table with a simple integer lookup key into a basic dimension table. However, some of the fact lookup key fields are NULL. I would like the Analaysis Services reports to show this NULL category. Instead, Analysis Services discards any NULL entries and the records are completely absent from the reports. What is the best way to achieve this?

    Thank you!

  2. #2
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    There should be no NULLs field in fact table. insert nulls or something in dimension table

  3. #3
    Join Date
    Oct 2003
    Posts
    268
    That makes sense; I can work around that. Thanks for the help!!

    Originally posted by rafala
    There should be no NULLs field in fact table. insert nulls or something in dimension table

Posting Permissions

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