During report creation, I've included data from only dimensions (no measures), and records from them are cross joined. Can you query only dimensions from the Star Schema in a report? For example in the following simple SSAS cube, can I query Subject and Student to see how many students were there per course?:
Asked
Active
Viewed 53 times
0
CleanBold
- 1,551
- 1
- 14
- 37
Nancy Drew
- 31
- 2
-
Can you provide a example of a query you are trying to make? The answer to your question depends on what you are trying to accomplish. – RADO Apr 24 '20 at 23:54
-
I've added more explanation if that helps... – Nancy Drew Apr 25 '20 at 04:26
-
That helps. I'll post a suggestion on weekend – RADO Apr 25 '20 at 04:56
-
Did you get time for this? – Nancy Drew Apr 27 '20 at 21:27
-
Nancy - is it possible for the students to be enrolled into a course but have no score (i.e, they are absent from the fact table)? – RADO Apr 27 '20 at 22:21
-
It is possible. But, in this case I have assumed that everyone has score. – Nancy Drew Apr 28 '20 at 03:58