Trimming the RPD

Oracle BI Applications delivers a full RPD file with projects for all the BI Applications modules. This full RPD is deployed to the BI Server. You can trim the RPD so that it includes only the projects that are relevant to your deployment. Although optional, trimming the RPD makes the BI Server startup process faster and also makes patching quicker.

Note:

The RPD should not be trimmed for on-premises Fusion Applications sources. The full RPD is required for ETL in these environments.

The steps for trimming the RPD depend on the status of your deployment:

• If the RPD has not been customized for your deployment: Extract the projects for the products that your organization has purchased. You don't need to perform a merge. See section Extracting Projects From Full RPD for instructions.

• If the RPD has been customized for your deployment: Extract the applicable projects from the full (delivered) RPD, and, additionally, merge that RPD with your customized RPD. See Extracting Projects From Full RPD and Merging Repositories for instructions.

Extracting Projects From Full RPD

Use this procedure to extract projects from the full RPD. The end result of this process is a trimmed RPD.

To extract from the RPD the projects for the products you have purchased:

1. Open a Command window on the computer where the BI Administration Tool is installed.
2. If you installed Oracle BI EE on Windows, then run bi-init.cmd to launch a Command prompt that is initialized to your Oracle instance. This utility is located in:
   MW_HOME\instances\instance<n>\bifoundation\OracleBIApplication\coreapplication\setup

   If you installed the BI Administration Tool using the BI Client installer, then run bi_init.bat to launch a Command prompt that is initialized your Oracle instance. This file is located in:

   ORACLE_HOME\oraclebi\orahome\bifoundation\server\bin
   

3. In a Command prompt window, run ExtractProjects:

   • If you installed Oracle BI EE on Windows, ExtractProjects.exe is located in ORACLE_HOME\bifoundation\server\bin.

   • If you installed BI Administration Tool using the BI Client installer, ExtractProjects.exe is located in ORACLE_HOME\oraclebi\orahome\bifoundation\server\bin.

   Run one of these commands:

   For extracting a single project:

   ExtractProjects -B input_rpd -O output_rpd -I "project_name"
    
   

   For extracting multiple projects:

   ExtractProjects -B input_rpd -O output_rpd -I "project_name1" -I "project_name2"-I "project_name3" (and so on)
    
   

   where:

   input_rpd is the name and path of the full (delivered) RPD and from which you want to extract the project or projects (for example, OracleBIApps.rpd).

   output_rpd is the name and path of the RPD you want to create with the extracted projects (for example, OracleBIAppsTrimmed.rpd).

   project_name is the name of the RPD project you want to extract.

   You will be prompted to enter the encryption password for the RPD (input_rpd ).

   The list of projects in the RPD includes:

   • Financial Analytics Fusion Edition

   • Human Resources Analytics Fusion Edition

   • Marketing Analytics Fusion Edition

   • Partner Analytics Fusion Edition

   • Project Analytics Fusion Edition

   • Sales Analytics Fusion Edition

   • Supply Chain and Order Management Analytics Fusion Edition

   • Student Information Analytics

   • Service Analytics

   • Price Analytics

   • Manufacturing Analytics

   • DataLineage_Project

   Note:

   The RPD contains projects in addition to those listed above. These projects are included for future content delivery and upgrade support. To determine the BI Applications available in this release, see "System Requirements and Supported Platforms," for Oracle BI Applications at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html.
4. Save and rename the trimmed RPD. Make sure the name identifies this RPD as one that has been trimmed, for example, OracleBIAppsTrimmed.rpd.

Merging Repositories

Use this procedure only if you have customized the RPD and are subsequently trimming the RPD.

1. In the Oracle BI Administration Tool, open in offline mode the trimmed Oracle BI RPD that you created in the procedure Extracting Projects From Full RPD, for example, OracleBIAppsTrimmed.rpd.
2. On the menu bar, click File, and then click Merge.
3. In the Select Original Repository dialog box, select the repository OracleBIApps.rpd, which is the full RPD.
4. Enter the password for the original repository, and then click OK.
5. Click Select for the Modified Repository field.

   The Select Modified Repository dialog opens.

6. Select the repository that contains the customizations you made to the RPD file, for example, OracleBIAppsCustom.rpd.
7. Click Open, and enter the password for the previously customized RPD file, and then click OK.
8. In the Decision drop-down list, select the action you want to take regarding the repository change, or accept the default action.
9. To locate subsequent rows with empty Decision fields, click the Decision header cell.

   After all rows have a value in the Decision field, the Merge button becomes enabled.

10. Click Merge.

    A message appears after the merge concludes successfully.

11. On the menu bar, click File, and then click Save As.

    Save the current repository using a new name, such as OracleBIAppsFinal.rpd.