SQL Server OLAP

In order to use Microsoft SQL Server Analysis Services 2000 for OLAP, you should install the SQLServer 2000 SP3 service pack.

Also, in order to drill through to details, you must enable two options on each cube.

1. Right click any cube (like HR) -> select 'Edit' option -> Tools -> Drillthrough option -> select 'Start DrillThrough' option and choose the desired columns
2. Right click any cube (like HR) -> click 'Management role' option -> click 'Edit' option -> select 'Option' tab -> select 'Allow drill' option