COUNT DISTINCT in OWB

[Kioutie]

Hi,

Do somebody knows how to do a SELECT COUNT (DISTINCT field1||field2) in OWB?
In my mapping, i have an aggregate that makes a 'GROUP BY' and four 'SUM', and in the expression field OWB doesn't give me the 'DISTINCT' option (I have to make a COUNT of distinct NAS).
My superior don't want me to change the code that is generated, so i really don't know how to do this..
Anybody have a suggestion?

Thanks!

 

[zephan]

Could'nt you do it using the DEDUP operator ?

 

[Kioutie]

Yes.. that's what i did, but i was wondering if we can use the DISTINCT command in OWB.. i guess we can't !!

 

[ypkrishnaa]

hi,
where you want to use the distinct count...

if it is in the aggregator you can select the properties of the attribute and select distinct there to count the occurence...