tag:blogger.com,1999:blog-33209370.post6015792213938339650..comments2023-10-23T17:52:37.156+00:00Comments on Oracle Analytics: Catching upAdrian Wardhttp://www.blogger.com/profile/12467688997292586407noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-33209370.post-57011175220956118782009-12-31T12:16:35.018+00:002009-12-31T12:16:35.018+00:00Respectable!
I am new to OBIEE. It becomes a chal...Respectable!<br /><br />I am new to OBIEE. It becomes a challenge for me to pass variables from dashboard prompts and to catch their value in Answer's Request.<br /><br />I would like to illustrate it with an example.<br />Request based on the following SQL statement<br /><br />Select NAME, AGE, CITY, ADDRESS<br />From emp<br />Where DOB = ‘@{p_date}’<br /><br />Now DOB is in TIMESTAMP format, <br />it looks like ‘11/1/2009 12:00:00 AM’. <br /><br />Dash board Prompt also depends upon the same column and have also same TIMESTAMP format. <br /><br />In next step <br />I create a dashboard page<br />Place prompt and report there<br />Saved the dashboard<br />Now I select a date from prompt list and press go button<br />It shows no result.<br /><br />I tried several combinations in @1 syntax e.g. <br /><br />Where DOB = ‘@{p_date}’<br />Where DOB = ‘@{p_date}{1-nov-2009} ’<br />Where DOB = cast(to_char(@{p_date}, ‘dd-mmm-yyyy’) as date)<br />.........................<br />And many other combinations<br /><br />I am looking for any help/tips in this regard <br /><br />Thanking in anticipation<br /><br />usman.fawad@hotmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-33209370.post-78508402162267802812007-07-06T15:29:00.000+00:002007-07-06T15:29:00.000+00:00Hi,I found your site by searching for information ...Hi,<BR/><BR/>I found your site by searching for information on how I can place the current date in the Headline of an IBot. To date I have found nothing that works.<BR/><BR/>Also, where/how do I obtain technical training for OBI? Are you aware of courses or on-line training that you would recommend?<BR/><BR/>Thanks so much for your help!!Anonymousnoreply@blogger.com