count distinct for a grouped field in FM

[tsuable]

Hi,

I need to the distinct count (and use that as a measure ) for an ID in a model query subject.


col1 col2 col3
1 a 1
2 a 0
3 a 0
4 b 1
5 b 0
6 c 1

Col3 is the measure i would like to derive.


any examples of formulas in action would be great.

Thanks,

 

[blom0344]

For report studio setting the aggregation property to 'distinct count' seems to works best. Creating the measure in framework just does not give proper results all the time. Cognos does work well with 'hardcoded' aggregate functions..

Ties Blom

 

[tsuable]

I was looking to use these measures in my Dimension View for olap analysis so i need the measure to be created at least in the Consolidation View.

I would think this is a fairly simple task. I used to do it in Impromptu by doing a Running Count on a field that i would Group By

Any samples would help... Please...

TIA