Category Archives: Oracle Business Intelligence

Sample Example on Viewing Worksheet through Discoverer Plus via URL Link Sample example on viewing worksheet through discoverer plus via URL link. Syntax: http://<Hostname>:<port#>/discoverer/plus?&cn=<Connection_Key>&opendbid=<Workbook_ID>&sheetid=<Worksheet_ID> http://<Hostname>:<port#>/discoverer/plus?&cn=<Connection_Key>&opendb=<Workbook_Name>&sheet=<Worksheet_Name>

→ 1 Comment

Posted on April 3, 2009 by

Hello Friends, many of my past work involve integrating oracle discoverer with oracle applications, here there is one of the ways to leverage both to integrate within applications.  How To Open A Worksheet Directly From Oracle Applications Menu ?   … Continue reading →

→ 3 Comments

Posted on March 9, 2009 by

Discoverer SQL: Long Running Discoverer Report Here is a small SQL quite useful to work with discoverer to identify long running reports and start looking into the reason / troubleshooting. SELECT q.qs_doc_name Worksheet,  q.qs_doc_details Sheet ,  q.qs_num_rows Lines,  QS_ACT_CPU_TIME CPU_Time, … Continue reading →

→ 2 Comments

Posted on February 13, 2009 by

Sample Example on How To Extract Worksheet IDs of a Workbook through Discoverer Desktop via the d51wkdmp utility Syntax: d51wkdmp.exe <Workbook_Name> <Output_File> DB <Connect_String>  <Eul_Schema> -f (1) Log into your pc where Discoverer Desktop is installed. (2) Find out the … Continue reading →

→ 2 Comments

Posted on February 12, 2009 by

Writing Post using Word 2007

Posted on February 9, 2009 by | Leave a comment

Hello Friends,

Just experimenting to use MS Word to write post/ article and directly publish here, this may help me to avoid formatting and lot of trouble while making posts.

Thanks

Shiv

→ Leave a comment

Posted in Oracle Business Intelligence

hello discoverer friends, here a good technical insight within oracle discoverer for scheduled report, what are the tables behind and how they linked. hope you would like n find it useful. do share ur feedback to improve future articles.   … Continue reading →

→ 2 Comments

Posted on February 8, 2009 by

How to Create a Link to a Discoverer Workbook in Apps11i  To create a link from the Oracle Applications 11i home page to a Discoverer workbook that will automatically open Discoverer Plus or Viewer and display the workbook using apps … Continue reading →

→ 2 Comments

Posted on February 2, 2009 by