Relationships not working as expected...

Hi All,

I am getting the error about about no matching columns when I add a column into a Matrix.

I ran a simple test where I have a master with 2 detail tables and have relationships from the master to each detail table.

1. I added one column from the detail A into an empty Matrix Visualization. No issues.

2. I add a column from the second detail table B and get the error about not being able to match the two columns.

If I change the relationships from Master to detailA and detail A to detail B then both detail columns can be added to the Matrix. Basically a daisy chain and not a star type schema that I need.

There must be something I am missing or the Model releationships are not what I expected.

Thanks!