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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

% in variable prompt

PritiSep 11 2013 — edited Sep 12 2013

Hi All,

OBIEE 11.1.1.6.6

I have created a direct DB request and the WHERE clause contains LIKE parameters. The dashboard prompt is of type Variable Prompt which allows users to input text in text field and these values are passed on to the report thro presentation variable.

When I input % as a parameter in prompt, there is no activity in back end & no query generated.

I'm expecting % to be passed on as a character and SQL ( WHERE COLUMN_NAME LIKE '@{V_NAME}') to behave as WHERE COLUMN_NAME LIKE '%' to display all values.

But it doesn't.

Any idea how to make it work?

Regards,

Priti

Comments

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

Post Details

Locked on Oct 10 2013
Added on Sep 11 2013
#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee11g, #prompt
3 comments
155 views