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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

[IDT 4.x] Cascading Prompts with ALL value


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
americanmc
Principal Member
Principal Member



Joined: 30 Dec 2009

Posts: 340


flag
PostPosted: Mon Apr 29, 2019 1:54 pm 
Post subject: Cascading Prompts with ALL value

Hi All,
I have a reqrmnt to display prompts for users when the run the Report, in the following order, each prompt filters the value for the next.
Code:
Business Group > Business Sub group > Site

So when report runs, users is prompted to select 'ALL' or any one Business Group , Next he selects the corresponding Buss Sub groups (based on Group selection) and so forth for Site.
I understand cascading prompts are possible but my question is how to add the ALL statement LOV in the "Business Layer" LOV.
Currently i am using SQL LOV to display ALL values as below code:
Code:

SELECT x.BusinessGroup
FROM
(Select 'ALL' as BusinessGroup
UNION ALL
Select Distinct  table_BusinessGroup.Name as BusinessGroup
from table_BusinessGroup) x

If some has done similar stuff please guide me to it.
Thanks crazy.gif

_________________
Did you think that man was created for nothing and that one day he would not have to return to his Lord?
Back to top
americanmc
Principal Member
Principal Member



Joined: 30 Dec 2009

Posts: 340


flag
PostPosted: Thu May 02, 2019 10:31 am 
Post subject: Re: Cascading Prompts with ALL value

Anyone has a way how to do it?
In webi display I am looking for the following:
1. Report Opens with the User prompted to :
a. 'Select Buss Group" with LOV starting with 'ALL' and rest of values.
b. 'Select Buss Sub Group' with LOV starting with 'ALL' and rest of values.
c. 'Select Site Name' with LOV starting with 'ALL' and rest of values.

SO user is free to go for 'ALL' and retrieve everything, or they can select individual Buss Groups and Sites which will work like Cascading Prompts.

need help
thanks
banghead.gif banghead.gif

_________________
Did you think that man was created for nothing and that one day he would not have to return to his Lord?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

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

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0282 seconds using 17 queries. (SQL 0.0028 Parse 0.0013 Other 0.0241)
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