Siebel Applications Administration Guide > Real-Time Decisions >

Creating and Populating OLAP Tables with History Data

Oracle Business Intelligence Server provides customer behavioral and aggregate metrics. If you use Oracle Business Intelligence Server, Siebel RTD can use this historical data to enrich the customer profile. Oracle Business Intelligence Server needs to stage the data in a custom OLAP table so that Siebel RTD can use JDBC to access the data.

This task assumes the following:

• You have installed Oracle Business Intelligence Server.
• Oracle Business Intelligence Server is running a Siebel 7.5.x, 7.7.x, or 7.8.x Analytics repository against the Siebel Relationship Management Warehouse.

This task is an optional step in Process of Configuring Siebel Business Applications for Siebel RTD.

To create and populate OLAP tables with history data

1. Connect to the Oracle Business Intelligence Server, as follows:
   1. Open a command prompt window.
   2. Change to the siebelanalytics/bin directory.
   3. Execute the following command:

   nQCmd.exe

   4. Type the data source name, and press Return.
   5. Type the administrator username, and press Return.
   6. Type the password and press Return.
   7. Type Q and press Return.
2. Open Windows Explorer and navigate to the installed inline service. For example, for SiebelB2C, navigate to \All\8.0\B2C.
3. Open the file SQL_ANALYTICS_SERVER.txt.
4. Execute each POPULATE statement in the file in the command prompt window where nQCmd.exe is running.

   Each POPULATE statement retrieves the result set as specified in the logical SQL, and inserts the result set into the RTD_SRVREQ_HIST table through the Data Warehouse Connection Pool.

   The following table lists the tables that are created.

   Application Type	Entity	OLAP Table	Sample of Data Provided
   B2B B2C	Service Request	RTD_SRVREQ_HIST	Average Service Quality, Number of Critical SRs, Average SR Duration, Number of Open SRs
   B2B B2C	Order	RTD_ORDER_HIST	Percentage Change of Closed Orders in Last Quarter, Total Order Revenue, Number of Orders
   B2C	Financial Account	RTD_FIN_ACCT_HIST	Number of Open and Closed Assets, Average Balance, Contact Revenue Range, Contact Profitability Range, Contact Balance Range

5. Use any SQL tool to connect to the SIEBEL_OLAP data source name, then verify that the tables exist and contain data.