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,