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
Um. Newbie mistake. I should have set the field as a Fact instead of an Ident field. It's working as expected