Essbase 21c: Datasource Gives An Error For Queries With Order By (Doc ID 3048811.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

Symptoms

When creating a Datasource with a SQL query containing ORDER BY, an error is shown.

Error:
"Parse error at line: 1, column: 31: The ORDER BY clause is not valid in views, inline functions, derived tables, sub-queries, and common table expressions, unless TOP or FOR XML is also specified.
"

Example:

Select * from [TBC].[dbo].[PRODUCT] order by 1,2

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.