COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: lorenmario on 13 Sep 2013 02:03:51 PM

Title: Measure with distinct count in Transformer
Post by: lorenmario on 13 Sep 2013 02:03:51 PM
Hello, I need some help!

I need to create a measure in my cube that counts the number of distinct visits from field Visits, someone can tell me how to do this?? The transformer has the distinct count??

Thank you!
Title: Re: Measure with distinct count in Transformer
Post by: wyconian on 15 Sep 2013 04:57:15 AM
Not sure if this will do what you want but take a look at adding a category count measure.

Good luck :-)
Title: Re: Measure with distinct count in Transformer
Post by: CharlesAZ on 13 Jan 2014 12:05:18 PM
There Function for it within Transformer but here is a work around that may fit your requirement:

http://www-01.ibm.com/support/docview.wss?uid=swg21348648

Best of Luck to you.

Charlie