Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with OBIEE Double Column Prompt Default Value

Question
1
Views
0
Comments
User_NRSQX
User_NRSQX Rank 1 - Community Starter

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: