
Hi everyone,
I know this was covered in another topic, but I couldn't work out how to apply it to my cube.
Any help would be greatly appreciated.
I am using TM1 in a university setting to store student data.
We have quite a large number of dimensions, but for simplicity I'll say we have student id, degree, subject, semester, student type.
The measure we use is called load and is a fraction of a full time year. So for example a student may be enrolled in 8 subjects across multiple semesters in a year and each subject has a load of .125 and thus for the year they have a load of 1. But many students are part time and some take on additional subjects so their load will add up to anything from .1 to to over 1 for any given year (a consolidation of the semester dimension).
We want to be able to count distinct students no matter which level we look at.
So I might want to know the count of a particular number of students in a program in a particular semester.
The problem is those students could be in any one or more of dozens of subjects so the distinct count of the students in the individual subject does not equal the distinct count of student in those subjects, as this would count some students more than once.
Similarly across a given year some students will enrol in all semesters, some in only one, and others in more than one but not all. So once again we can't just add the distinct count of the students in the semesters that make up a year because they are overlapping sets.
If anyone can think up a way to count distinct no matter which dimension is consolidated that would be awesome, we have bashed our heads together over it for quite some time. 
本帖子中包含更多资源
您需要 登录 才可以下载或查看，没有帐号？立即注册
x
