http://sdrv.ms/U9GUpN
I have a model with a fact table, policy dimension, customer dimension, and an inforcepolicy dimension, customer and inforce are snowflaked through policy.
The inforce dimension is monthend dates and policies that are active, but adding it as a slicer has no effect on the pivot???
I have 2 customer count measures, one is a distinctcount(dimpolicy[customerseqid]) the other is distinctcount(dimcustomer[customerseqid]) the two measures give different results, but there is a relationship between the two columns???? I thought the relationships behaved like joins, the measure in policy does seem to behave as such, but the measure using customer seems to behave like an outer join.
can some one explain why the measures behave differently and why the slicer does nothing?
Thanks
Scott
I have a model with a fact table, policy dimension, customer dimension, and an inforcepolicy dimension, customer and inforce are snowflaked through policy.
The inforce dimension is monthend dates and policies that are active, but adding it as a slicer has no effect on the pivot???
I have 2 customer count measures, one is a distinctcount(dimpolicy[customerseqid]) the other is distinctcount(dimcustomer[customerseqid]) the two measures give different results, but there is a relationship between the two columns???? I thought the relationships behaved like joins, the measure in policy does seem to behave as such, but the measure using customer seems to behave like an outer join.
can some one explain why the measures behave differently and why the slicer does nothing?
Thanks
Scott