BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

[Webi 4.x] Optional prompt in Free Hand SQL


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
a.vishnu
Forum Member
Forum Member



Joined: 31 Jul 2020

Posts: 3



PostPosted: Fri Jul 31, 2020 11:47 am 
Post subject: Optional prompt in Free Hand SQL

Hi,

I am using Web Intelligence Rich Client, I want to use optional prompt. My requirement is like user has option to input 4 values, he need to enter any one.

WHERE
CITY =
DATE =
PRODUCT =
STORE =

he can enter one or more values, if he didn't enter any value it should be excluded from WHERE clause.
Is there way I can do it?

Thanks,
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6705
Location: Connecticut, USA


flag
PostPosted: Sat Aug 01, 2020 8:00 am 
Post subject: Re: Optional prompt in Free Hand SQL

You can't use optional prompts in FHSQL, for good reason. Optional prompts work by removing the entire condition from the query if a value is not selected. Since WebI does not manage the generation of the SQL in FHSQL queries, there's no way for it to remove the condition.

If you require Optional Prompts, you'll need to create a universe and do it the "normal" way.
Back to top
a.vishnu
Forum Member
Forum Member



Joined: 31 Jul 2020

Posts: 3



PostPosted: Sun Aug 02, 2020 11:04 pm 
Post subject: Re: Optional prompt in Free Hand SQL

Hi,

Thanks for information, I will try your suggestion.

Thanks,
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0277 seconds using 17 queries. (SQL 0.0024 Parse 0.0009 Other 0.0244)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo