I'm having problems with speed using OLAP Drillthrough.

Basically, I'm using a cube on 7.5 million customers and want to produce distinct customer count when the operator selects different cells in different views.

This is taking a couple of minutes to select the distinct count and I was wondering if anybody knows of some way of optimizing the drillthrough query.

TIA,