1 / 21

Integrating with Oracle Business Intelligence Enterprise Edition (OBI EE)

Integrating with Oracle Business Intelligence Enterprise Edition (OBI EE). Objectives. After completing this lesson, you should be able to do the following: Explain the concepts of OBI EE and OBI SE integration with Warehouse Builder

laban
Download Presentation

Integrating with Oracle Business Intelligence Enterprise Edition (OBI EE)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Integrating with Oracle Business Intelligence Enterprise Edition (OBI EE)

  2. Objectives • After completing this lesson, you should be able to do the following: • Explain the concepts of OBI EE and OBI SE integration with Warehouse Builder • Explain the typical steps to transfer the BI metadata into the OBI EE Server • Describe the process of deploying metadata to the OBI EE Server

  3. Lesson Agenda • Integrating with Business Intelligence Tools • OBI SE • OBI EE • Steps to derive, deploy, and transfer BI Metadata into OBI EE Server

  4. Business Justification: Tools Integration • By implementing business intelligence objects, Warehouse Builder can be integrated with reporting environments seamlessly.

  5. Integrating with OBI EE OracleWarehouseBuilder Datasources Oracle BI OBI EEServer Data SiebelCRM Data DataWarehouse OBI EEEnterpriseSemanticLayer(RPD) Dashboards OracleEBS ETL Data objectsData quality Othersources Distributemetadata SAP/R3 OBI SEEnd user layer Ad hoc reports DatabaseRepository Data Metadata PeopleSoft

  6. Integration with OBI SE (Discoverer) • Deploy objects directly into Oracle Business Intelligence Standard Edition (OBI SE) End User Layer (EUL). • Benefits: • Completeness: BI design in Warehouse Builder • Productivity: Direct building of reports based on Warehouse Builder design by end users • Oracle Discoverer module contains: • Item Folders (module level) • Business Areas • Item Folders (business area level) • Drill Paths • Lists of Values • Alternative Sort Orders • Drills to Detail • Registered Functions

  7. Lesson Agenda • Integrating with Business Intelligence Tools • OBI SE • OBI EE • Steps to derive, deploy, and transfer BI Metadata into OBI EE Server

  8. Transfer BI Metadata to OBI EE Server Typical Steps to Transfer BI Metadata to the OBI EE Server Deploy BI metadata Convert the UDML file to the OBI EE repository file Derive BI metadata in Warehouse Builder Transport the UDML file to the OBI EE Server Generate the UDML file

  9. Setting Up the UDML File Location 1 2 Transport Type determines how you want to transfer the UDML file to the file system where OBI EE is installed. If the Warehouse Builder repository and the OBI EE are on a single machine, select FILE. This prompts for a directory (rootpath) and file name. The UDML file will be saved to that directory upon deployment.

  10. Creating a New Catalog Folder Select the source objects for the Catalog folder

  11. Deriving the BI Metadata(OBI EE)

  12. Deriving the BI Metadata 1 Right-click the module that contains the objects and select Derive. 2 Select the source objects for derivation.

  13. Deriving the BI Metadata 3 4 Select the target catalog folder to derive the metadata into. Set the Rules for derivation.

  14. Deriving the BI Metadata Dimensions derive into Logical Tables and Dimension Drill Paths nodes. Cubes derive into Logical tables.

  15. Deploying the BI Module View Script A UDML file for each object is generated. A master SALES_EE.udml file is generated in the root path you specified while creating the BI location.

  16. Converting the UDML File for OBI EE • The UDML file is converted into an RPD file and then opened in the OBI EE Admin tool. • Convert the UDML file to an .rpd file by using the following command: • <OBIEE_INSTALL>\OracleBI\server\Bin\nQUDMLExec -I source.udml -O tgt.rpd • Move this .rpd file into the OBI EE repository directory by using the following command: • copy tgt.rpd <OBIEE_INSTALL>\OracleBI\server\Repository • Configure the OBI EE initialization files. Edit <OBIEE_INSTALL>\OracleBI\server\Config\NQSConfig.INI to change the entry under [REPOSITORY]. This is required so that the repository can be used in reporting tools such as Answers or Dashboards.

  17. Oracle BI Admin and Answers Tool Open the .rpd file in the BI Admin tool. It shows the Presentation, Business, and Physical layers. Log in to Oracle BI Answers tool and create reports.

  18. Quiz • When you deploy the BI module, it generates a .udml file in the root location specified. • True • False

  19. Summary • In this lesson, you should have learned how to: • Explain the concepts of OBI EE and OBI SE integration with Warehouse Builder • Explain the typical steps to transfer the BI metadata into the OBI EE Server • Describe the process of deploying metadata to the OBI EE Server

  20. Practice 13-1 Overview: Derive, Deploy, and Transfer Business Intelligence Metadata into OBI EE Server • This practice covers the following topics: • Defining a Business Intelligence location to set the UDML file location • Creating a new Oracle Business Intelligence module • Deriving and deploying the Business Intelligence objects

  21. Practice 13-2 Overview: Invoking the Demo titled “Reporting Using the OBI EE Answers” • In this practice, you run a demo that illustrates the tasks that you perform in the OBI EE environment after you have generated the .udml file using Warehouse Builder.

More Related