If you are unable to create a new account, please email support@bspsoftware.com

 

What is the proper way to setup a non-fact for a distinct count using DMR?

Started by patrickthatcher, 15 Apr 2015 02:59:40 PM

Previous topic - Next topic

patrickthatcher

Just finished my Framework class and I didn't think to ask this question.
Background:
I have the following field that I would like to do a Count Distinct in a crosstab report:
PDP Session > Case When Cast([traffic].[t_cm_fact_product_traffic_hist].[pdppage_view_count],numeric(15,0)) >0 Then [Model View].[Traffic Fact].[cm_session_identifier]  Else null end

I set the PDP Session field as an Identifier with a Aggregate of Count Distinct. However, when I review the test SQL the query shows that count is not being done.  I did think to put the #1 in place of the [Model View].[Traffic Fact].[cm_session_identifier], but the value could repeat itself multiple times and only want the count of that unique value once.

How can I get the value I need?

Thanks in advance

patrickthatcher

Um.  Newbie mistake. I should have set the field as a Fact instead of an Ident field.  It's working as expected