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!There should be no NULLs field in fact table. insert nulls or something in dimension table|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment