BI Repository - Siebel Analytics Setup

Document Sample
BI Repository - Siebel Analytics Setup Powered By Docstoc
					BI Repository - Siebel Analytics Setup



      Preparation

          1. From Windows Services Panel , Stop Siebel Analytics Server and Siebel Analytics Web
             services.
          2. Use BI Repository Replication Console to replicate your Salesforce data to a local Oracle
             database.
          3. Have the ODBC Data Source Name for the Oracle Instance where the Salesforce data
             has been replicated.


      Step 1: Copy Repository files to the Siebel Installation directories


      Copy the repository and catalog files to your Siebel Analytics installation directories as shown
      below. The files are present in the repositoryfiles directory.


       File Name           Copy To                        Notes


       sforce.rpd          <SIEBEL_HOME>/reposit          SIEBEL_HOME in the path represents your
                           ory folder                     Siebel Analytics installation directory


       sforce.webc         <SIEBEL_DATA_HOME>/            SIEBEL_DATA_HOME in the path
       at                  web/catalog foder              represents your Siebel Analytics Data
                                                          directory




      Step 2: Update Siebel Analytics Configuration files



       Config file to be             Text to be edited                 Comment
       edited


       <SIEBEL_HOME>/Con             [ REPOSITORY ]                    Locate [Repository] section
       fig/NQSConfig.ini                                               and add the sforce.rpd file to
                            Star=sforce.rpd,                  the Star schemas to be loaded
                            DEFAULT;
                                                              by the repository server.


<SIEBEL_DATA_HOM            <ServerInstance>                  Locate <ServerInstance>
E>/Web/                     ...                               section and specify the
Config/instanceconfig.x                                       sforce.webcat location for the
ml                          <CatalogPath>                     CatalogPath element.
                            <SIEBEL_DATA_HOME>/we
                            b/
                            catalog/sforce.webcat

                            </CatalogPath>

                            ..

                            </ServerInstance>




Step 3: Configure Database

   1. Start Siebel Analytics Administration Tool.
   2. Open the sforce.rpd file (offline mode). You will see the Physical Layer, Business Model
      and Mapping Layer and Presentation Layer sections.
   3. Under the Physical Layer, Right click OLTP -> Connection Pool item to open the
      properties form, and set the Data source name value to the ODBC data source to Oracle
      instance having the Salesforce data. The image below shows the properties form.
   4. Verify the database connection by selecting 'View Data' on one of the tables in the
      Physical Model (do a right-mouse-click on the table to open the menu).
   5. Save the Repository.
Step 4: Start Siebel Analytics

   1. From Windows Services Panel, Start Siebel Analytics Server, and Siebel Analytics Web
      services
   2. Launch Siebel Analytics Web client from the browser, and login as Administrator.
   3. Click on 'Salesforce Dashboard' to view pre-built dashboards for your data.