8 Reset the Tutorial Exercise Environment

If you or your colleagues would like to work through the tutorial exercises again, you can reset your tutorial exercise environment by following the instructions appropriate to the component environment you would like to reset.

This chapter contains the following topics:

• Section 8.1, "Reset the Oracle Warehouse Builder Environment"

• Section 8.2, "Reset the BI Server Metadata Repository"

• Section 8.3, "Reset the BI Presentation Services Web Catalog"

8.1 Reset the Oracle Warehouse Builder Environment

If you want to work through the exercises in Chapter 3, "Set Up the Data Mart" again, perform these steps first:

1. Open a command prompt window.

2. Navigate to the directory where you installed Oracle BI Standard Edition One.

3. Navigate to the tutorial\owb subdirectory.

4. Run the reset_bise1_tutorialwh.bat script. When prompted, enter the password for the BISE1_TUTORIALWH database account.

5. Go to the Windows Start menu, then select Programs > Oracle - BISE1_WarehouseBuilder > Warehouse Builder > Design Center.

6. Log into Oracle Warehouse Builder Design Center using the owbrepos_owner account.

7. In the Design Center, right-click the GEC_DW_TUTORIAL project and select Delete.

8. Select Design > Save All.

9. Select Design > Import > Warehouse Builder Metadata.

10. Click Browse next to the File Name field. Go to the Oracle BI Standard Edition One installation directory, and then go to the tutorial\owb\mdl directory.

11. Select gec_dw_tutorial_start.mdl. Click Open.

12. In the Metadata Import dialog box, click Advanced.

13. Select the options Import user-defined definition and Import security information. Click OK.

14. Click Import.

15. When the import completes successfully, click Close to close the Metadata Import Progress dialog box.

16. Exit the Design Center.

8.2 Reset the BI Server Metadata Repository

If you want to work through all of the exercises in Chapter 4, "Build the BI Repository" again, perform these steps first:

1. Shut down the BI Server service, and the BI Presentation Services service.

2. Copy tutorial\bi_ad\bise1.rpd to bi\server\repository, replacing the existing bise1.rpd.

3. Copy tutorial\bi_ad\bise1.zip to bidata\web\catalog.

4. Unzip bise1.zip, replacing the contents of bidata\web\catalog\bise1.

5. Start the BI Server service and the BI Presentation Services service.

If you want to work through just the Advanced exercises in Chapter 4 (Section 4.8 through Section 4.11) again, or you want to work through Chapter 5, "Analyze the Data" again, perform these steps first:

1. Shut down the BI Server service.

2. Copy tutorial\bi_ad\bise1_soln_noadv.rpd to bi\server\repository.

3. Rename bi\server\repository\bise1_soln_noadv.rpd to bi\server\repository\bise1.rpd, replacing the existing bise1.rpd file.

4. Copy tutorial\bi_ad\bise1_soln_noadv.zip to bidata\web\catalog.

5. Unzip bise1_solun_noadv.zip, replacing the contents of bidata\web\catalog\bise1.

6. Start the BI Server service and the BI Presentation Services service.

8.3 Reset the BI Presentation Services Web Catalog

To reset the BI Presentation Services Web catalog:

1. Shutdown the BI Presentation Services service.

2. Copy tutorial\bi_ad\bise1.zip to bidata\web\catalog.

3. Unzip bise1.zip, replacing contents of bidata\web\catalog\bise1.

4. Start the BI Presentation Services service.