I'm currently building an education data warehouse.
I have three factless fact tables for distinct set of grades due to the fact I have no measures (I'm not aggregating anything), the grades are completely unrelated to each other hence why they're in different tables. I'm only slicing student dimension by grade fact tables.
In Excel, when I drag a student onto a row and then grades into columns, I would expect to see grades for the student. However, I am just seeing all students/all grades. The relationships do not seem to be working even though I can clearly see the relationships in the tabular diagram view.
Any ideas as to why this is?
As you can see below, SSAS has imported the relationships; however when I browse in Excel there does not seem to be any relationship between the data. If I filter by one row for student and select grades, I just get all grades not just the grades relevant for that student.
If I drop student keys in the row section and grades in the column section, it will just display all/all. If I change the student key filter to display a few records nothing seems to change, so SSAS is fairly useless to me at the moment.