Search found 4 matches

by Bris_Clinton
Thu Apr 29, 2010 3:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DISTINCT Counts in TM1
Replies: 13
Views: 16504

Re: DISTINCT Counts in TM1

errr, yes.. let me think some more... :lol: :lol: I got all excited thinking that it really was that easy! I could do separate measures at least we can allow users access and they can just look up themselves. I am starting to think that maybe it is not possible to have a single rule driven measure...
by Bris_Clinton
Wed Apr 28, 2010 7:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DISTINCT Counts in TM1
Replies: 13
Views: 16504

Re: DISTINCT Counts in TM1

Thanks Steve.

Unless I have mucked something up this just gives me 1 at every level?
by Bris_Clinton
Wed Apr 28, 2010 12:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DISTINCT Counts in TM1
Replies: 13
Views: 16504

Re: DISTINCT Counts in TM1

Thanks Martin. I think I didn't explain the requirements very well. The idea of counting students is not a once off or well defined request. We are constantly getting asked to count at all different levels. A subject coordinator may want to know the count of students enrolled in his upcoming class, ...
by Bris_Clinton
Wed Apr 28, 2010 12:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DISTINCT Counts in TM1
Replies: 13
Views: 16504

DISTINCT Counts in TM1

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, ...