tag:blogger.com,1999:blog-7751447442026377325.post24110538758605729..comments2023-10-23T22:25:46.368+02:00Comments on Oracle Business Intelligence OBIEE 101: OBIEE using prompt as report selectorJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7751447442026377325.post-6297687005640296422013-02-08T12:41:08.340+01:002013-02-08T12:41:08.340+01:00Hi John
This was a very useful post and thank you...Hi John<br /><br />This was a very useful post and thank you for this wonderful blog. I implemented the above mentioned technique to create a dashboard prompt with list of report names. However, I have used 3 reports in the list and soon as I go to the dashboard page with this prompt, SQL for all the reports on this page gets generated on the backend. Even when I select one of the reports from the drop down list, I see many other SQL still running on the backend. Since our report list is long, this puts a lot of load on the database. Is there a way to stop the queries from being generated and wait for the user’s response? I would appreciate your reply.Kavinoreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-65718854468050888642012-08-03T08:02:20.095+02:002012-08-03T08:02:20.095+02:00Hi,I've used his approch in one of my dashboar...Hi,I've used his approch in one of my dashboard with 3 reports ,but the catch here is when i select the Report1 from Prompt it shows the Report 1 with the data & shows Report 2 & 3 with blank informations.<br /><br />Is there any way to display only one report at a time??<br /><br />Thanks<br />PrakashPrakashhttps://www.blogger.com/profile/06810100048210486666noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-72439517492868002182012-04-16T09:00:41.988+02:002012-04-16T09:00:41.988+02:00Hello Join
This is regarding
OBIEE using prompt ...Hello Join<br /><br />This is regarding <br />OBIEE using prompt as report selector.<br /><br />Selecting Reports from Dashboard Prompts and Guided Navigation Sections<br /><br />I have tried doing the same as per the steps given by you for Selecting Reports from Dashboard Prompts and Guided Navigation Sections. <br /><br />First Step <br /><br />CASE WHEN 1=0 THEN "Sales Geo"."Sub Region" ELSE 'Booking By Region' END in column area <br /><br /><br />Second Step <br /><br />SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE ‘Booking By Country’ END FROM Revenue UNION ALL SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE 'Booking By Region' END FROM Revenue<br /><br /><br />But as I just wanted to see the dasboard with these ‘Booking By Country' and 'Booking By Region' values, I am getting error as <br /><br />"Error Generating Drop Down Values <br /> Odbc driver returned an error (SQLExecDirectW).<br /> Error Details<br />Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P<br />State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27002] Near : Syntax error [nQSError: 26012] . (HY000)<br />SQL Issued: SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE ‘Booking By COuntry’ END FROM Revenue UNION ALL SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE 'Booking By Region' END FROM Revenue"<br /><br />can you please help me out to get this resolve <br /><br />Regards<br />Vinodvinodhttps://www.blogger.com/profile/08224459611313312679noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-14497677044783428632012-04-16T09:00:13.071+02:002012-04-16T09:00:13.071+02:00Hello Join
This is regarding
OBIEE using prompt ...Hello Join<br /><br />This is regarding <br />OBIEE using prompt as report selector.<br /><br />Selecting Reports from Dashboard Prompts and Guided Navigation Sections<br /><br />I have tried doing the same as per the steps given by you for Selecting Reports from Dashboard Prompts and Guided Navigation Sections. <br /><br />First Step <br /><br />CASE WHEN 1=0 THEN "Sales Geo"."Sub Region" ELSE 'Booking By Region' END in column area <br /><br /><br />Second Step <br /><br />SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE ‘Booking By Country’ END FROM Revenue UNION ALL SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE 'Booking By Region' END FROM Revenue<br /><br /><br />But as I just wanted to see the dasboard with these ‘Booking By Country' and 'Booking By Region' values, I am getting error as <br /><br />"Error Generating Drop Down Values <br /> Odbc driver returned an error (SQLExecDirectW).<br /> Error Details<br />Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P<br />State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27002] Near : Syntax error [nQSError: 26012] . (HY000)<br />SQL Issued: SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE ‘Booking By COuntry’ END FROM Revenue UNION ALL SELECT CASE WHEN 0=1 THEN "Sales Geo"."Sub Region" ELSE 'Booking By Region' END FROM Revenue"<br /><br />can you please help me out to get this resolve <br /><br />Regards<br />Vinodvinodhttps://www.blogger.com/profile/08224459611313312679noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-60416866983705853632010-11-02T13:51:51.008+01:002010-11-02T13:51:51.008+01:00@David,
How did you set the scope of the prompt? ...@David,<br /><br />How did you set the scope of the prompt? Have you considered using presentationvariables?<br /><br />regards<br /><br />JohnJohn Minkjanhttps://www.blogger.com/profile/08228393663535024706noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-90630732351559205122010-10-28T16:30:15.862+02:002010-10-28T16:30:15.862+02:00Hello John
I have several reports on the same pag...Hello John<br /><br />I have several reports on the same page.<br />I need to use a prompt for the User to change the period of the semester report. however, it is necessary for the prompt change only the selected reporting period and not all reports of the page.<br /><br />Could you help me with this?<br /><br />ThanksDavidhttps://www.blogger.com/profile/11079636136849594984noreply@blogger.comtag:blogger.com,1999:blog-7751447442026377325.post-33928341985193932972010-07-23T08:31:50.461+02:002010-07-23T08:31:50.461+02:00As the SQL is processed for all reports at the bac...As the SQL is processed for all reports at the back end it leads to performance issues.<br />Can we expect something better in OBIEE 11g?<br /><br />AshAshhttps://www.blogger.com/profile/13635032357778486671noreply@blogger.com