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!

How to Set Up a Dynamic Prompt Default Value

Martin ChenSep 14 2011 — edited Sep 14 2011
Dear All,

I am going to use Agent to send the analysis to users. Since there have about 20 different users who should receive different data filter by ENTITY.

There has several way to do so, but I am stuck in all of them...

First, set a Dynamic Variable in RPD. I create a Variable named CH_Company and set the SQL as SELECT User_Company FROM CH_Company WHERE User_NM='ch001'. I tested in the setup dialog and get the right value. But I receive NULL when I set the Default Value of a Prompt as Repository Variable CH_Company. Is there anything I missed? Is it possible to dynamic set 'ch001' by different user?

Second, I tried to do it in Prompt. I set the default value to SQL SELECT User_Company FROM CH_Company WHERE User_NM='ch001' and I get nothing for the default value. Even I drag User_Company and User_NM into the subject area I am using and change the SQL to SELECT User_Company FROM SubjectArea WHERE User_NM='ch001'. I still get nothing. Is there suggestion for the SQL??

Thanks for the help!!


Best Regards,
Martin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2011
Added on Sep 14 2011
#agent, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dynamic, #prompt, #variable
8 comments
670 views