Data is as expected when viewing my custom table, but becomes duplicated when my dashboard actually queries. Let me paint you a picture.
The cube. SubjectOrders is a custom table that groups Order lines by three fields. So any orders with the same subject, assoc, and job have their amounts summed into OrderPrice.
Previewing the table or querying the table in the runner gives me the correct expected results.
Now the problem happens in the actual dashboard.
Above is a list of entries from Subject Orders. Most are have been duplicated more or one times. Basically, theres a line for each Order line that was grouped. The sums are correct.
The problem must have to do with the join between Subject orders and Orders, which is a necessary relationship, because I would like to be able to drill down and see the order lines inside each group.
Please sign in to leave a comment.