Oracle BI Insight to Action

Everything you need to know about migrating a Discoverer system to Oracle BI Enterprise Edition

Session ID: S299610

WHEN: Thursday  25th September 2008  12:00 - 13:00

WHERE: Marriott Salon 09

I am pleased to announce that the Discoverer Metadata Conversion Assistant is now available with the Oracle BI EE 10.1.3.4 release. For further details, please see this new page on OTN:

http://www.oracle.com/technology/products/bi/discoverer-migration/index.html

The Metadata Conversion Assistant is a command line utility that accelerates the conversion of Discoverer metadata in the form of an EEX file to Oracle BI EE metadata in the form of an RPD file.

Those of you who are familiar with the metadata for both products may be wondering how it is possible to convert what appears to be a single layer of metadata in Discoverer to the three layers required by Oracle BI EE - the Physical, Business Model and Presentation Layer. This is a question we asked ourselves when we first considered the potential for a migration utility. The answer becomes clear when you consider the Discoverer metadata properties as seen below:

In this example, we're looking at the Discoverer metadata properties for a folder 'Products'. These properties include details of the Database, the object Owner and the object name. In a similar manner, it is also possible to inspect the properties of Discoverer metadata joins. The Metadata Conversion Assistant is able to take these properties and build up the various Oracle BI EE metadata layers - for example,  the properties described here are a good source of information for building the Oracle BI EE Physical layer.

Here are some of the topics I'm planning on covering over the next few months. It would be great to hear about any other topics you'd like to see discussed.

Oracle BI Delivers

• Introduction and benefits of Oracle BI Delivers
• How to make it easy for users to get alerts
• How to optimize my iBot content for delivery to mobile devices
• How to build simple but effective analytic workflows with iBots
• How to configure Delivers to send alerts as SMS messages

Migration of Oracle Discoverer to Oracle BI Enterprise Edition (Oracle BI EE)

• Introduction to Oracle BIEE components from a Discoverer perspective
• What are the benefits of migrating to Oracle BIEE
• How do the metadata models differ and how are they similar?
• How can I speed up the migration of Discoverer metadata to Oracle BI EE?