This discussion is archived
3 Replies Latest reply: Aug 21, 2013 12:26 PM by user7996228 RSS

Discoverer Reports Migration to OBIEE

KrishnaAgnihotri Explorer
Currently Being Moderated
Hi All

I have migrated Discoverer to OBIEE. Now i want to migrate my discoverer reports also to my OBIEE. Kindly suggest how can i do this?


Thanks
Krishna
  • 1. Re: Discoverer Reports Migration to OBIEE
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    I do not believe Oracle provides a tool to convert workbooks to OBIEE reports - but there are third party solutions (e.g. http://www.eistech.com/products/discoConvUtility.html).

    Re: Discoverer to OBIEE Migration Tool

    HTH
    Srini
  • 2. Re: Discoverer Reports Migration to OBIEE
    Michael Armstrong-Smith Oracle ACE
    Currently Being Moderated
    Hi Krishna
    Converting a Discoverer workbook to OBIEE is very difficult to do because, believe it or not, there are certain reporting capabilities that Discoverer has which OBIEE does not.

    One of the big stumbling blocks has been the conversion of reports that use analytic functions which Discoverer handles in its sleep and the capability to use lists of values that are based on items not in the current folder or even in the same business area. Another area of difficulty are reports that use hyper drilling.

    The way that Eis handles this is to convert all of the folders into views and then extract the Discoverer metadata out of an EEX export reading the metadata line by line converting along the way leaving out anything that is not supported. You cannot use Eis to convert workbooks into Eis reports and then expect those to link to OBIEE areas created by using Oracle's conversion tool because the two are incompatible. If you choose to use Eis you will have to use their EUL conversion tool as well.

    Anyone else have any insights? Has anyone successfully converted Discoverer workbooks to OBIEE answers?

    Hope this helps
    Michael
  • 3. Re: Discoverer Reports Migration to OBIEE
    user7996228 Newbie
    Currently Being Moderated

    Krishna,

    Both Srini and Michael have provided some good information. I'd like to just add something. EiS will convert your discoverer reports to OBIEE through our conversion tool. As Michael said, it isn't an easy task but it can be done. We have a number of customers that have converted discoverer reports to the EiS eXpress solution as well as to OBIEE.

     

    I'd be happy to put you in touch with the right folks at EiS to discuss how it might work for you. Please let me know if we can be of assistance!


    Sue Maloney

    EiS Solutions Director

Legend

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