Forum Discussion
Missing detail lines in Table Matrix
I have found the issue. I have report level filters. The report level filter is causing the omission of detail lines from the detail visualization table SalesBudget which is attached to the star schema. There is not an omission of data in the Sales Budget Data Summary SUMMARIZECOLUMNS derived table visualization since it is not attached to the star schema even though it summarizes over a table in the star schema.
I would have expected that the result set totals would have been the same. Using the SUMMARIZECOLUMNS could prove to be problematic when there are filters applied and aggregation is needed.
More info - I tested the filter theory by putting the Visualizations on the same page in the report. It did not make any difference, the summary visualization total (CORRECT) was still greater that the detail visualization total (INCORRECT).
I attempted to add a graphic to this post using the Photos tool but it will not accept the BMP that I have.
Thank you for reviewing my original issue.
I have found the issue. I have report level filters. The report level filter is causing the omission of detail lines from the detail visualization table SalesBudget which is attached to the star schema. There is not an omission of data in the Sales Budget Data Summary SUMMARIZECOLUMNS derived table visualization since it is not attached to the star schema even though it summarizes over a table in the star schema.
I would have expected that the result set totals would have been the same. Using the SUMMARIZECOLUMNS could prove to be problematic when there are filters applied and aggregation is needed.
Anonymous,
If you have solved the issue, you can accept your reply as answer to close this thread.
Regards,
Lydia