FIX: Drill-Through Fails if Dimension Table Has an Alias in the Cube

If your dimension tables are aliased (obtained by right-clicking the title bar of a dimension table in the Cube Editor and selecting Change Alias) and you select columns from the alias for the drill-through results, the drill-through may fail.

Depending on the data source you are using (Access or SQL Server), an error message that resembles one of the following may be seen:

The SQL statement that is generated upon drill-through seems to reference the alias names without generating the DimTable AS Alias clause, and as a result, the statement fails. For example, the following statement may be generated: instead of:

To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.