Siebel Applications Administration Guide > Analytical Reports for UPT and UPT with IRM Intersection > Process of Configuring Reports >
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.
- Download UPT.catalog and UPT.rpd from the server common folder packaged with Siebel CRM to any folder on your local or remote machine.
- Run the admintool.cmd utility from:
C:\Oracle\Middleware\bi\bitools\bin\
NOTE: For UNIX, the utility is admintool.sh
- Edit the rpd file.
- 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.
- Expand UPT in the Physical window.
- Right-click Connection Pool and select Properties.
- Update DSN, User Name, and Password.
- 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.
- Save your changes upon exit.
NOTE: Fix errors, if any, upon exit. You can ignore warnings.
- 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.
|