Poll Analytics Community Website Satisfaction Vote and let us know your satisfaction with the Analytics Community Website
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Data Visualization Challenge Register today to the Oracle Analytics Data Visualization Challenge starting in February 2025

Oracle Analytics Cloud and Server

Issue with OBIEE Double Column Prompt Default Value

Question

Views

Comments

User_NRSQX Rank 1 - Community Starter

June 2019 edited August 13 in Oracle Analytics Cloud and Server

I have a a column prompt based on a double column (ID and descriptor) in OBIEE.

I would like to set a default value based on a session variable.

If I use descriptor value, the prompt works but query fails.

If I use ID value, query works, but after the query finishes, ID value is displayed in prompt instead of descriptor value.

What format should I use?

Thanks very much

Qing

Tagged: