Generating the Report from the RPD File

Use this procedure to generate the report.

To generate the report from the RPD file

Download the catalog and rpd files.
1. Download UPT.catalog and UPT.rpd from the server common folder packaged with Siebel CRM to any folder on your local or remote machine.
2. Run the admintool.cmd utility from:
```
C:\Oracle\Middleware\bi\bitools\bin\
```
  Note: For UNIX, the utility is admintool.sh
Edit the rpd file.
1. Navigate to File, Open, and then the Offline menu item to open UPT.rpd.
  Note: The temporary password to open the file is Siebel@123. Please change the password after initial login.
2. Expand UPT in the Physical window.
3. Right-click Connection Pool and select Properties.
4. Update DSN, User Name, and Password.
5. Click OK.
  If you want to verify if your setting is correct, right-click the S_USER_EVENT table and then click Update Row Count.
  If this update today’s date, the connection is successful.
6. Save your changes upon exit.
  Note: Fix errors, if any, upon exit. You can ignore warnings.
7. Run the data-model-cmd.cmd utility, located in the OBIEE server, at:
```
\ORACLE_HOME\bi\modules\oracle.bi.commandline.tools\scripts
```
  Note: For UNIX, the utility is data-model-cmd.sh

Upload UPT.rpd from the command prompt by entering the following command:

data-model-cmd.cmd uploadrpd -I <RPD location> -W <RPD password> -SI ssi -U <OBIEE 
user login> -P <OBIEE user password> -S <OBIEE server name> -N 9502

For example:

data-model-cmd.cmd uploadrpd -I C:\UPT.rpd -W Siebel@123 -SI ssi -U weblogic -P 
welcome1 -S xyz01mrc.us.abc.com -N 9502

Note: Ensure the Java path is set before you start upload.