7.21.1.1 RPD and Catalog Deployment

This section includes steps for the RPD and Catalog deployment.

Deploying the RPD

For RPD deployment, follow these steps:

1. Connect to the OBIEE Server.
2. Create a folder. For example, tmp in the following directory:

   <Oracle_Home>/user_projects/domains/domain_name

3. Copy the CRMBI.rpd from the OBIEE Configuration - Deploy OFS CRA Analytics (where you have saved the RPD) to the folder created in the preceding step.
4. Open the Command Prompt, and navigate to the following directory:

   /scratch/<mount_name>/Middleware/Oracle_Home/user_projects/domains/bi/b itools/bin

5. Execute the following command:

   ./datamodel.sh uploadrpd -I <RPDfilepath> -W <RPDpassword> -SI ssi -U <username> -P <password>

   For example:

   ./datamodel.sh uploadrpd -I /scratch/obiee12c/Middleware/Oracle_Home/user_projects/domains/bi/tmp/CRMBI.rpd -W Administrator1 -SI ssi -U weblogic -P weblogic123

   Figure 7-10 RPD deployment success message.

   
   

   

   
   

Deploying the Web Catalog

For web Catalog Deployment, follow these steps:

1. Open the Catalog Manager, navigate to the File menu and open the catalog online by giving the necessary credentials based on your setup:
   • Type: Online
   • URL: http://<ipaddress>:<port>/analytics-ws
2. After the catalog is opened, it will display a directory structure on the left-hand side. Select the Catalog Root and select Shared Folders in the LHS tree structure.
   1. Go to the File menu and select Unarchive . It will ask for the path for a file.
   2. Browse the path of the archived catalog file saved in your OBIEE Configuration - Deploy OFS CRA Analytics using the Browse button and click OK.
   3. The catalog must be extracted in the Shared Folders directory for the reports to display. A successful operation message is displayed.
   4. Restart the presentation services once again.
   5. Open the analytics OBIEE URL (http://<ipaddress>:<port>/analytics).
   6. Login with credentials based on your setup and verify that the catalog is available.
      1. Click on catalog in the OBIEE Application right top menu list.
      2. In the LHS menu, navigate to shared directories and verify all the directories are available.

Starting and Stopping Services in OBIEE

Follow the below steps to start and stop OBIEE Services:

1. Connect to the OBIEE server.
2. Navigate to the /scratch/<mount_name>/Middleware/Oracle_Home/user_projects/domains/bi/b itools/bin directory.
3. Execute the following commands:
   1. Command to stop service: ./stop.sh
   2. Command to start service: ./start.sh

OBIEE Configurations Post-Deployment of RPD and Catalog Files

For OBIEE Reporting, configure the following:

1. Navigate to the <<obiee <<Oracle BI Instance Home>/config/fmwconfig/biconfig/OBIJH directory.
2. Modify the config.xml file.
3. Increase parameter value for the following tag:

   <XMLP>
   <InputStreamLimitInKB>40000</InputStreamLimitInKB>
   <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
   </XMLP>
   <DVT>
   <InputStreamLimitInKB>40000</InputStreamLimitInKB>
   </DVT>

4. Save the config.xml file.
5. Navigate to the <<obiee <<Oracle BI Instance Home>/config/fmwconfig/biconfig/OBIPS directory.
6. Modify the instanceconfig.xml file.
7. Increase the parameter value for tag if already exists or add the following code:

   <Charts>
   <MaxVisibleColumns>50000</MaxVisibleColumns>
   <MaxVisiblePages>25000</MaxVisiblePages>
   <MaxVisibleRows>100000</MaxVisibleRows>
   <MaxVisibleSections>50000</MaxVisibleSections>
   <JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>
   </Charts>
   and
   <Pivot>
   <MaxCells>1920000</MaxCells>
   <MaxPagesToRollOutInDelivery>10000</MaxPagesToRollOutInDelivery>
   <MaxVisibleColumns>50000</MaxVisibleColumns>
   <MaxVisiblePages>100000</MaxVisiblePages>
   <MaxVisibleRows>10000000</MaxVisibleRows>
   <MaxVisibleSections>50000</MaxVisibleSections>
   <DefaultRowsDisplayed>100000</DefaultRowsDisplayed>
   </Pivot>
   under <Views> tag

8. Save the instanceconfig.xml file.
9. Restart the BI Services.