-
MDX query help
Hi All,
I am having issues in writing an MDX query for the below scenario.As I am new to MDX it is getting diffcult to work on the below scenario.
I have some measures created as
Attainment = Num/DEN (%)
Number of Student = Count of student.
A Teacher would have some student under him.
So for e.g. I would have teacher X having '11' students under him.
I wonder how to write an MDX query that could bucket the number of students based on Attainment
so for instance, I could see the
Teacher (X)
3 with Attainment of 100%,
5 with Attainment between 95-99,
2 with Attainment between 90-94,
and 1 with Attainement < 90
Thanks
--------------------------------------------------------------------------------
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|