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
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

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 2024 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: