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.

@PROMPT (BOXI XIR2)


 
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
BObjectz
Senior Member
Senior Member



Joined: 17 Aug 2010

Posts: 53



PostPosted: Tue May 10, 2011 11:47 am 
Post subject: @PROMPT (BOXI XIR2)

Hi guys,

I'm looking to create an @prompt filter that displays the prompted response value and that value -7 days. For example:
A user selects the @prompt filter in the report and selects 10-05-2011 as the date. I then want to retreive data between that date and -7 days.

Does anyone know how to do it?

Thanks.
Back to top
Farhan Jaffery
Forum Enthusiast
Forum Enthusiast



Joined: 27 Aug 2005

speaker.gif
Posts: 1014
Location: Houston, TX


flag
PostPosted: Tue May 10, 2011 12:09 pm 
Post subject: Re: @PROMPT (BOXI XIR2)

For SQL Server, you can use dateadd function:
Code:
date_column between dateadd(dd, -7, @Prompt('Date','D',,mono,free,persistent)) and @Prompt('Date','D',,mono,free,persistent)

_________________
Farhan Jaffery
SAP Certified - BOE 3.x
J.P. Morgan Chase
Houston, Texas
Back to top
Dragoran
Principal Member
Principal Member



Joined: 30 Jul 2009

Posts: 108


flag
PostPosted: Wed May 11, 2011 2:53 am 
Post subject: Re: @PROMPT (BOXI XIR2)

and in oracle it would look something like this:
Code:
date_column between @Prompt('Date','D',,mono,free,persistent)-7 and @Prompt('Date','D',,mono,free,persistent)
Back to top
BObjectz
Senior Member
Senior Member



Joined: 17 Aug 2010

Posts: 53



PostPosted: Wed May 11, 2011 3:05 am 
Post subject: Re: @PROMPT (BOXI XIR2)

Guys,

A big thank you. Really appreciated - great stuff.
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.0374 seconds using 17 queries. (SQL 0.0121 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