Fact table has 20 million rows. Dim tables (5) are reasonable like states
(or state info N/A), magazin subscription (100 mags). IncomeLevelGroups (5), etc. Nothing fancy.
The measure is Member (set to 1).
So the default aggregation sum(Member) works real fast.
When I add UserID (not unique) to the measures and set the aggregation to
select distinct(userid) at the properties panel, it processes forever.
The unique userids are around 5M. Meaning that a user subs to 4 mags on the average.
How can i speed up the Unique measure processing? Otherwise I have to take it out.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World - SQLUSA: