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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Using User Response to Select Specific Data


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



Joined: 08 Jun 2004

Posts: 2



PostPosted: Wed Jun 09, 2004 12:17 pm 
Post subject: Using User Response to Select Specific Data

crazy.gif

In one Query I request Inventory records for a specific point in time (eg. wk 5) based on a user prompt/user response.

In the second Query I request future demand based on a submission date, one week later than former query. (eg. wk 6) In the data set I have demand for the next 6 weeks, 6,7,8,9,10........

I created a user response varible (char) and performed tonumber fromula to create number. I need to bring the two queries together to calculate estimated days of inventory. The problem is that I get # computation errors. If I define the varible where wk is = 6 for eg. the data works. I want the report to be dynamic based on either user response.

Help.
icon_lol.gif
Back to top
dcdas
Forum Associate
Forum Associate



Joined: 17 Jun 2002

speaker.gif*2
Posts: 751
Location: Atlanta


flag
PostPosted: Wed Jun 09, 2004 1:11 pm 
Post subject: Re: Using User Response to Select Specific Data

In your first query use the to_char(date,'WW')=@prompt(..)
and in your second query use to_char(submission_date,'WW') > @PROMPT(use same prompt as first..)


(FOR oracle)

_________________
Durgesh Das
IntercontinentalExchange
durgesh.das@theice.com
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop 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 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 18 queries. (SQL 0.0027 Parse 0.0008 Other 0.0233)
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