This discussion is archived
2 Replies Latest reply: Nov 14, 2012 10:44 AM by 970433 RSS

How to Creaet a disco report with existing SQL

970433 Newbie
Currently Being Moderated
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
    RodWest Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points