Print Page - Count Distinct Options in Transformer

Title: Count Distinct Options in Transformer
Post by: mrcool on 20 Sep 2011 06:01:56 PM

Hi Guru's,

Could you please suggest few best options to do a count distinct in transformer.We are using Cognos 8.4
We have claim number in the fact table but the fact has lower granularity than Claim Number.
I want to create a measure Claim Count with distinct Claim Numbers.
I am considering an option of creating a dimension with Claim number as a column and perform category count on that field. Is that a better option?
Appreciate your quick response.

Cheers,
MC

Title: Re: Count Distinct Options in Transformer
Post by: prikala on 21 Sep 2011 12:09:17 AM

I think category count is your only option, unfortunately (things get ugly when you have lots of categories).

Title: Re: Count Distinct Options in Transformer
Post by: mrcool on 21 Sep 2011 06:32:10 AM

Thank you prikala..
But I have lot of categories..Should see how it performs.

Thanks,
MC

Title: Re: Count Distinct Options in Transformer
Post by: ykud on 06 Dec 2011 05:27:18 AM

You can use external rollup measure and count it in the database prior to populating the cube. We usually did this for performance.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: mrcool on 20 Sep 2011 06:01:56 PM