Microsoft KB Archive/283564

= BUG: Alias Parameters Do Not Work with Oracle Databases =

Article ID: 283564

Article Last Modified on 11/21/2006

-

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 &quot;MyTest&quot;.&quot;A&quot; FROM &quot;PSS&quot;.&quot;OLAPTEST&quot; AS &quot;MyTest&quot; Oracle does not support the keyword AS. To use an alias with Oracle, the correct syntax to use is: SELECT DISTINCT &quot;MyTest&quot;.&quot;A&quot; FROM &quot;PSS&quot;.&quot;OLAPTEST&quot; &quot;MyTest&quot;



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.

Additional query words: 8i 8.x 7.x OLE DB provider ODBC driver Processing Dimension failed ORA-00933: SQL command not properly ended OLAP

Keywords: kbbug kbnofix KB283564

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.