[#4874] - Missing rows in drill-through table

Category:
Bug report
Priority:
Urgent
Status:
New
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Not Attempted
Assigned to:

I have NULL values in some rows of a column in my fact table, which contains a foreign key to a dimension table. So some of my rows have no connection to this dimension. I also have some other dimension tables and corresponding columns in my fact table.
When I make a drill-through in my analysis, only the rows without NULL values are shown. The ones with NULL that should be shown in the drill-through are missing.
However, the sum of my sales is shown correctly (the sum of all rows) in the analysis.
I attached the view of my drill-through and the rows I expected to see in it.

AttachmentSize
Image icon drill-through.png7.61 KB
Image icon expected_drill_through.png7.08 KB
planetzone's picture
Joined: Mar 29 2010 - 8:12am
Last seen: 8 years 3 months ago
Feedback
randomness