2 Replies Latest reply: Nov 14, 2012 12:44 PM by 970433 RSS

    How to Creaet a disco report with existing SQL

    970433
      Hi All,

      I have a SQL scrip, how can I create a discoverer report ?
      I have only Discoverer desktop login.

      Regards,

      SJ
        • 1. Re: How to Creaet a disco report with existing SQL
          Rod West
          Hi,

          It is unlikely that you will be able to create a report just using Disco Desktop. There is a File->Import SQL function in Desktop but the SQL will only be imported if there are all the necessary folders and joins in the EUL for the SQL. If you the folders and joins are not there then you will need Disco Administrator to change the EUL.

          Generally, the easiest way to build a report in Discoverer is to create a custom folder using Disco Adminstrator and then build the worksheet based on this folder using Disco Desktop.

          Rod West
          • 2. Re: How to Creaet a disco report with existing SQL
            970433
            Thanks Rob... I have requested a user who have Disco Admin login to include this Custom folder and referring required BA. I'm not able to run the report in Disco Desktop..

            Thanks for your help.

            Regards,

            SJ