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: No events within the next 45 days.

[IDT 4.x] Dynamic nested prompts based on condition


 
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
satyaram71
Principal Member
Principal Member



Joined: 10 Jan 2008
ASUG Icon
Posts: 108


flag
PostPosted: Mon Feb 11, 2019 2:33 pm 
Post subject: Dynamic nested prompts based on condition

Hi Guys,

I have typical requirement, User wants to review the data based on number of days selection. Before selecting the number of days, he needs to choose the option Month, Year, DOW.

eg : User selects month option and number of days 7
data range should be beginning of selected month minus 7
Eg: user selects Year option and number days 7
data range should beginning of the selected year minus 7

User always select one option, based on selection option it should prompt month or year or DOW.

Please let me know your thoughts banghead.gif
Thanks,
Satya.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Tue Feb 12, 2019 3:46 am 
Post subject: Re: Dynamic nested prompts based on condition

You'd probably have to do it as a case statement.

What's the underlying database? Oracle, SQL Server, etc?

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
satyaram71
Principal Member
Principal Member



Joined: 10 Jan 2008
ASUG Icon
Posts: 108


flag
PostPosted: Tue Feb 12, 2019 10:07 am 
Post subject: Re: Dynamic nested prompts based on condition

Mark,

Thanks for your response, I tried with case statement in the where clause, but it showing up all prompts without evaluating the case statement. I need only one prompt after evaluating the case statement.
Is it limitation in the IDT?

Thanks,
Satya
Back to top
satyaram71
Principal Member
Principal Member



Joined: 10 Jan 2008
ASUG Icon
Posts: 108


flag
PostPosted: Tue Feb 12, 2019 10:20 am 
Post subject: Re: Dynamic nested prompts based on condition

Mark,

I forgot to mention the database, It's Netezza.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Wed Feb 13, 2019 3:07 am 
Post subject: Re: Dynamic nested prompts based on condition

You only need one prompt for time period and one for number.

The awkward part comes with the case expression, which will be quite messy. I'm not 100% on your date range requirement either.

Can you give an example of the logic?

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
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.0323 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0288)
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