SSAS - Inferred Dimension Attributes - are they necessary?

Answer 1

I'm not sure I understand your question fully, so please clarify if necessary.

If you want to query the cube to get persons by state, you should add a Referenced relationship between Person and State, using Case as the Intermediate dimension.

1. Select the empty box at the intersection of Person and State and click on the button
2. Select Referenced from the relationship type dropdown
3. Select Case as the Intermediate dimension
4. Selecting the matching attributes in the two attribute dropdowns
5. Click OK.

Deploy and process the cube, and it should work the way you want. Then you can get rid of the (State - Person) dimension.

Answer 2

If the Person table contains the key for the State dimesion it should be as simple as setting up a regular relationship between the State dimension and the Person measure group. there should be no need to create referenced or fact relationships.