Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
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