BUG: Alias Parameters Do Not Work with Oracle Databases (283564)

The information in this article applies to:

Microsoft SQL Server 2000 Analysis Services

This article was previously published under Q283564

BUG #: 11458 (plato7x)

SYMPTOMS

If you use alias parameters with your dimension (obtained by right-clicking the title bar of a dimension table and selecting Change Alias from the menu within the Dimension Editor), and your data source is an Oracle database, the following errors or similar messages occur when you attempt to process the dimension:

Data source provider error: One or more errors occurred during processing of command.;ORA-00933: SQL command not properly ended.

Processing Dimension 'OracleAlias' failed. No changes have been made to the database.

CAUSE

The syntax of the alias generated by Analysis Services to process the dimension is incorrect for Oracle databases. For example:

SELECT DISTINCT "MyTest"."A" FROM "PSS"."OLAPTEST" AS "MyTest"

Oracle does not support the keyword AS. To use an alias with Oracle, the correct syntax to use is:

SELECT DISTINCT "MyTest"."A" FROM "PSS"."OLAPTEST" "MyTest"

WORKAROUND

To work around the problem create a view of the table in Oracle instead of aliasing the table in the Analysis Manager.

STATUS

Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0.

Modification Type:	Minor	Last Reviewed:	4/24/2003
Keywords:	kbBug kbnofix KB283564 kbAudDeveloper