Creating Oracle BI EE Repository with Integrated Operational Planning

  To create Oracle BI EE Repository with Integrated Operational Planning:

1. Start the Interlace server.

2. Ensure that the following services are started:

   • Oracle BI EE Java Host

   • Oracle BI EE Presentation

   • Oracle BI EE Server

   • OC4J server

3. Open Oracle BI EE Administration Tool

4. Click File, then New, and then enter the name of the repository file. This file will contain repository details.

5. Enter the following details:

   • Provider Type-Analysis Services 2000

   • User name: admin

   • Password: welcome1

   • http://ps2592:27080/interlace/services/XmlAnalysis

6. Click OK, select any cube as a source, and then click Import. Select Forecast cube. Currently the tool does not allow multiple hierarchies in Dimension. In this case, the fiscal dimension has multiple hierarchies. Delete the Fiscal Quarter hierarchy from the Physical section.

7. Drag the Forecast file hierarchy on to the Business Model & Mapping and Presentation window.

8. Click Save, and then click OK. The Consistency Manager window is displayed. Close it.

9. Open NQSConfig.INI under OBIEE_INSTALLED_PATH/server/config and add

   Star = REPOSITORY_NAME.rpd, DEFAULT;

   See step 4.

10. Open Welcome to ,Oracle BI EE.

    The Oracle BI EE window is displayed.

11. Click Oracle BI Interactive Dashboards.

    The Oracle BI EE Login page is displayed.

12. Log on with Administrator rights. Leave the password blank and click Login.

13. On the right corner of the window, click Answers.

14. In Subject, click Forecast#1.

    OLAP objects are listed on the left.

15. Click the Criteria tab.