Forum Discussion
empty report when filtering
Hi Anonymous,
the question is your Open Debt colum, you are using a summarize option (SUM) in this case this is calculating the sum of the values however for the specif code you are refering of Banner ID that column is null in this case this don't sum as 0 since all values as null it doesn't appear on your table.
If you go to your last column in the table and select the don't summarize the A00010140 will appear but with blank / null values.
One question I didn't understood why are you appending merging all you table into a giant one and not making relationship between tables and uisng measure to make your calculations?
Regards,
MFelix
Hi Anonymous,
Looking at the images you attached, you have Blanks in the BannerID is this correct or this column should have always ID's?
Asking this because you can be having this result if this column is related with other in your model and there are some values missing from your dimension table, then when you filter out the result it gives you blanks.
Regards,
MFelix
Hi MFelix,
Thanks for weighing in,
The blank values are correct in the way the query is currently written. A change to the view to be left outer on a few tables will resolve that issue.
This although is unrelated to my current issue. When filtering on the value A00010140 I receive an empty report, but the data clearly shows as available in the data view.
In the case of how this data is structured, I have merged my queries into one. The functionality of data sets is rather limiting and would not allow for a star schema due to unavoidable 1 to many situations in the data.