Trimming the Repository

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

Note:

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

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

If the repository 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 Extracting Projects From Full Repository.
If the repository has been customized for your deployment: Extract the applicable projects from the full (delivered) repository, and, additionally, merge that repository with your customized repository. See Extracting Projects From Full Repository and Merging Repositories.

Extracting Projects From Full Repository

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

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

Open a Command window on the computer where Oracle BI Administration Tool is installed.
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 Oracle 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
```
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 Oracle 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) repository and from which you want to extract the project or projects (for example, OracleBIApps.rpd).

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

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

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

The list of projects in the repository 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 repository contains projects in addition to those listed above. These projects are included for future content delivery and upgrade support. To determine the Oracle BI Applications available in this release, see System Requirements and Supported Platforms for Oracle BI Applications.
Save and rename the trimmed repository. Make sure the name identifies this repository as one that has been trimmed, for example, OracleBIAppsTrimmed.rpd.

Merging Repositories

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

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

The Select Modified Repository dialog opens.
Select the repository that contains the customizations you made to the repository file, for example, OracleBIAppsCustom..
Click Open, and enter the password for the previously customized repository, and then click OK.
In the Decision drop-down list, select the action you want to take regarding the repository change, or accept the default action.
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.
Click Merge.

A message appears after the merge concludes successfully.
On the menu bar, click File, and then click Save As.

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