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.