Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Prompt values from a SQL as well as a custom value

Hem31Feb 3 2010 — edited Feb 4 2010
Hi,

We have a requirement to put a prompt on State code. We have a master table for State codes. But in Transaction table (which is used in the report column) will have an extra value of State code which will not be in the master table. We want to show all state codes and this extra value in the prompt. How can I do that?

I can not use the transaction table as a prompt source as it may not have all states.

In short the prompt should show following results.

SELECT STATE_CODE FROM STATE_TABLE
+
Additional Values

Edited by: Hem31 on Feb 3, 2010 3:37 PM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 4 2010
Added on Feb 3 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #prompt, #report
1 comment
462 views