9.1.1 Deploying STSA RPD File

To deploy the RPD, follow these steps:
  1. Unzip stsa-installer.zip to extract the ESTBI component, which contains Stress Testing and Scenario Analytics.rpd and Stress Testing and Scenario Analytics.catalog.
  2. Copy the Stress Testing and Scenario Analytics.rpd and Stress Testing and Scenario Analytics.catalog files to a folder on the server where OAS is installed.
  3. Open the extracted Stress Testing and Scenario Analytics.rpd file in offline mode using the Oracle Analytics Administration Tool, and configure the required database connections. To do so:

    Note:

    The Oracle Analytics Administration Tool requires a 64-bit Windows operating system.
    1. In the Oracle Analytics Administration Tool, go to the File menu and select Open > Offline.
    2. Select the Stress Testing and Scenario Analytics.rpd file.
    3. Enter the repository password to access the file.

    Note:

    • The RPD file uses a default password for the initial login. Refer to the applicable My Oracle Support (MOS) document for the password.
    • To change the password, select File > Change Password, then enter the current and new passwords.
  4. Modify the connection pools in the RPD. To do so:
    1. In the Physical layer, expand the OFSAA_EST_Results Database, then double-click EST Connection Pool.
    2. Update the following fields:

      Table 9-1 Modifying the connection pools

      Field Description
      Data source name Enter the TNS entry name of the EST sandbox database instance.

      Note:

      You can find these details in the STSA wallet configured in Setup the Password Stores for Database User Accounts.
      Username Enter the EST schema username.
      Password Enter and confirm the EST schema password.
    3. Click OK to save the changes.
    4. Repeat steps a and b for the OFSAA_EST_PROCESSING_INIT Connection Pool.
    5. From the File menu, select Save to save the RPD file. When the “Do you wish to check global consistency" dialog box appears, click No.
  5. Upload the RPD file to the Oracle Analytics Server:
    1. Open a terminal window on the server where OAS is installed.
    2. Navigate to the following directory:

      <OAS_DOMAIN_HOME>/bitools/bin

    3. Run the following command to upload the RPD file:

      ./datamodel.sh uploadrpd -I "<RPD Path>/Stress Testing and Scenario Analytics.rpd" -SI ssi -U weblogic -P <weblogic password>

    4. When prompted, enter the RPD file password to complete the upload.