I am trying to create a table from an Excel source where there are no null values. I looked at the preview and it shows the correct values but when I bring the values into a table they all show as nulls. Suppressing nulls doesn't help as there are no null values in the source. I have tried both general and number formats in Excel and they still show up nulls in the table whether straight or pivot. I'm at my wits end. I have data from the same source file on another tab that I used in another table that display fine. Help
Using your previous QVW, I've seen data for all three month if you were using Month field instead of ReceiptMonth as dimension.
As said, you seem to have issues caused by your dimension fields not correctly linked to your facts (I mentioned two things I noticed, synthetic keys and key fields with non - matching values). Have you taken care of both issues?
Stefan, Thanks for your help on this issue. Based on your suggestion about key fields with non matching value, I was able to track down an issue with the source data. Since I had to use Receipt date as it was a filter across multiple tabs, I found out that the sample receipt date I was using across all vendors did not occur for all vendors so I just added already occurring dates in the Fact table to the source table and things turned out okay. Thanks again.
