OBIEE11g/12c: Report Does Not Accept More Than One value From Prompt for Direct Database Request - DDR
Last updated on JUNE 23, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On Oracle Business Intelligence Enterprise Edition (OBIEE): 12c version, Analytics
- When calling presentation variable in OBIEE direct database request(DDR), report throws error for when prompt returns more than one value.
- Direct database request report works only with single default value , if more than one value is passed from prompt then the report errors out with following error message -
ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 'مول3'.. (HY000)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms