I have integer values in my fact table that repeat several time. I want
to be able to count the distinct values and recalculate depending on
what dimension I pull in. I have tried various things in the calculated
member builder like Distinct([Measures].[Inforce Policy Id]). This
returns an error.



In my fact table, if I have 4 5678 values, and 3 9687 values, I want 2
as the count, not 7 or the sum of 15,365.



Any help or guidance would be appreciated!



Thanks,



Doug


--
Posted via http://dbforums.com

Define a Measure on the fact table field with the integer value, using
Aggregation Function "Distinct Count" (only one such Distinct Count
measure can be defined in a given cube).

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!