Forum Discussion
Dimension Table Records Reduced When Linked To Fact Table
Hello,
I am having an issue where one of my dimensions are being limited based on the fact tables it is linked to. For example, I have an Item dimension that has a one-to-many relationship connected to a Sales Line, a Posted Sales Shipment Line, a Posted Sales line, and a Posted Credit Memo Line fact table. The Posted Sales Shipment Line is filtred to only show lines that have been shipped not invoiced (this means that I am seeing 0 items up to 8 items). This is causing an issue when using the Item dimension table as a slicer filter because I am only seeing items that are in the Posted Sales Shipment Line fact table instead of all items in the Item dimension table. Does anyone know of a way to resolve this issue? Is this an known issue? I have not experienced this before with a slicer.
Possibly the relationship direction is both ways instead of single. I would need to see a picture of the model.
2 Replies
Possibly the relationship direction is both ways instead of single. I would need to see a picture of the model.
Thank you very much! I have never had a One-To-Many set the relationship direction to both, so I did not think to check that. I appreciate it!
For others to see this is the relationship direction HotChilli referred to.
