Skip Headers
Oracle® Communications Data Model Adapters and Analytics Installation Guide
Release 11.3.2

E37744-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

E Oracle Communications Social Network Analytics Postinstallation Steps

This appendix describes the postinstallation steps and additional configuration steps for Oracle Communications Social Network Analytics (SNA). It includes the following sections:

Postinstallation Steps for Oracle Communications Social Network Analytics

This section contains the following topics:

Non-Oracle Business Intelligence Enterprise Edition Tasks

The non-Oracle Business Intelligence Enterprise Edition (OBIEE) tasks consists of the following optional topic:

Modifying the Degree of Parallelism

Perform the following steps to modify the Degree of Parallelism (DOP):

  1. Install Oracle Communications Social Network Analytics (SNA) on Oracle Communications Data Model Core or Oracle Communications Data Model Sample. SNA Schema objects are installed with DOP = 1, by default.

  2. To modify the DOP, use the following script:

    $ cd ORACLE_HOME/ocdm/addon/analytics/sna/install/sql
    
  3. Login to ocdm_sys and ocdm_sample schema, if applicable. Change the DOP using the following script:

    SQL> @ocdm_sna_alter_parallel.sql
    
  4. When prompted, enter a new value for DOP and press Enter.

Oracle Business Intelligence Enterprise Edition Tasks

The Oracle Business Intelligence Enterprise Edition consists of the following topics:

Importing Users and Groups

Perform the following steps to import the users and groups for the OBIEE task.

  1. Log in to Oracle WebLogic Server Administration Console. Expand the Services list and click Security Realms.

    Figure E-1 Oracle WebLogic Server Admin Console Security Realms Screen

    Description of Figure E-1 follows
    Description of "Figure E-1 Oracle WebLogic Server Admin Console Security Realms Screen"

  2. Click Migration and then click Import in the Settings for the myrealm section. Enter the following path in the Import Directory on Server field:

    ORACLE_HOME/ocdm/addon/analytics/sna/install/reports/obiee_ugr
    

    Figure E-2 Oracle WebLogic Server Admin Console Screen

    Description of Figure E-2 follows
    Description of "Figure E-2 Oracle WebLogic Server Admin Console Screen"

    Click Save.

Setting Up Oracle Business Intelligence Enterprise Edition for Social Network Analytics

To set up OBIEE for SNA, following are the details of users, groups, and application roles:

Table E-1 Users, Groups, and Application Roles

User Group Application Role

sna

ocdm_sna_admin_grp

ocdm_sna_admin_approle

sna1

ocdm_sna_admin_grp

ocdm_sna_admin_approle

sna2

ocdm_sna_admin_grp

ocdm_sna_admin_approle

sna3

ocdm_sna_user_grp

ocdm_sna_user_approle

sna4

ocdm_sna_user_grp

ocdm_sna_user_approle

sna5

ocdm_sna_viewer_grp

ocdm_sna_viewer_approle

sna6

ocdm_sna_viewer_ltd_grp

ocdm_sna_viewer_ltd_approle


In Table E-1, the default user login of SNA Webcat is sna and the default password is sna12345. For all other users, the default user login is sna1/2/3/4/5/6 and the password is welcome1.

Creating Social Network Analytics Roles

Perform the following steps to create the SNA roles:

  1. Log in to Oracle WebLogic Server Administration Console. Expand the Business Intelligence list and click coreapplication.

    From the Business Intelligence Instance drop-down list, select Security, and then click Application Roles.

    Figure E-3 Oracle WebLogic Server Admin Console Application Roles Tab

    Description of Figure E-3 follows
    Description of "Figure E-3 Oracle WebLogic Server Admin Console Application Roles Tab"

  2. Define roles with the display name and description and assign groups to roles.

    Figure E-4 Oracle WebLogic Server Admin Console Application Roles Tab

    Description of Figure E-4 follows
    Description of "Figure E-4 Oracle WebLogic Server Admin Console Application Roles Tab"

Creating Social Network Analytics Application Policies

Perform the following steps to create the SNA application policies:

  1. Log in to Oracle WebLogic Server Administration Console. Expand the Business Intelligence list and click coreapplication.

    From the Business Intelligence Instance drop-down list, select Security, and then click Application Policies.

    Figure E-5 Oracle WebLogic Server Admin Console Application Policies Tab

    Description of Figure E-5 follows
    Description of "Figure E-5 Oracle WebLogic Server Admin Console Application Policies Tab"

  2. Assign privileges to application roles.

    The admin and users roles are assigned the manageRepositories and manageCatalog privileges.

    Figure E-6 Oracle WebLogic Console Admin and Users Roles

    Description of Figure E-6 follows
    Description of "Figure E-6 Oracle WebLogic Console Admin and Users Roles"

    The viewer and viewer limited are assigned the manageRepositories privilege.

    Figure E-7 Oracle WebLogic Server Admin Console Viewer Roles

    Description of Figure E-7 follows
    Description of "Figure E-7 Oracle WebLogic Server Admin Console Viewer Roles"

Altering Privileges

Perform the following steps for alter privileges:

Additional Configuration Steps for Oracle Communications Social Network Analytics

This section contains the following topics:

Modifying Server Configuration File

Perform the following steps for modifying the server configuration file:

Modify NQSConfig.INI at the following location:

BI_INSTANCE_HOME/config/OracleBIServerComponent/coreapplication_obis1

The default setting is 0. Change the setting to 1.

# EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manageRepositories permssion
# 2: evaluate is supported for any user
# other: evaluate is not supported if the value is anything else
EVALUATE_SUPPORT_LEVEL = 1;

Location Alias for Social Network Analytics Action Links

Set up an action link location alias for current server with logical name snaactionsrv by performing the following steps:

  1. Modify the file ActionFrameworkConfig.xml located at the following directory:

    MW_HOME/user_projects/domains/bifoundation_domain/config/fmwconfig/biinstances/coreapplication
    
  2. Edit the file information:

         <aliases>
            <location-alias>
                    <alias>snaactionsrv</alias>
                    <actual>slc00yoa.us.oracle.com:7001</actual>
            </location-alias>
            <location-alias>
                    <alias>localactionsrv</alias>
                    <actual>localhost:7001</actual>
            </location-alias>
        </aliases>
    

Setting Up the Social Network Analytics Graphical Component

Perform the following steps to set up the SNA graphical component:

  • Use the files from the following location:

    ORACLE_HOME/ocdm/addon/analytics/sna/install/graph/SNAViewerWebApp/installation
    

    Use the notes from the following location:

    ORACLE_HOME/ocdm/addon/analytics/sna/install/graph/SNAViewerWebApp/*_notes.txt
    
  • Use the ant utility to install the SNA graphical component. To ensure that MW_HOME and other environment variables are set, run the following commands:

    $ echo $SHELL
    /bin/bash
    $ export MW_HOME=/biaora/home/MWHome
    
    # start Node Manager 
    $ cd $MW_HOME/wlserver_10.3/server/bin
    $ . ./setWLSEnv.sh &
    
  • Customize the following ant command:

    ant -f deploySNAViewer.xml deploy 
    -DWL_HOME=/biaora/home/MWHome          # your MW Home directory
    -DWL_PORT=7001 
    -DWL_DOMAIN=bifoundation_domain 
    -DWL_USER=sna 
    -DWL_PASS=sna12345 
    -DDB_HOST=slc00smi.us.oracle.com              # your db server
    -DDB_PORT=1521
    -DDB_NAME=orcl 
    -DDB_USER=ocdm_sna
    -DDB_PASS=ocdm_sna
    

    For example,

    ant -f deploySNAViewer.xml deploy -DWL_HOME=/biaora/home/MWHome -DWL_PORT=7001 -
    DWL_DOMAIN=bifoundation_domain -DWL_USER=sna -DWL_PASS=sna12345 -DDB_HOST=slc00smi.us.oracle.com -DDB_PORT=1521 -DDB_NAME=orcl -DDB_USER=ocdm_sna -DDB_PASS=ocdm_sna
    

    Check for errors in the ant command.

Configuring Writeback Templates for Social Network Analytics

Perform the following steps to configure the writerback templates for SNA:

  • Use the files from the following location:

    ORACLE_HOME/ocdm/addon/analytics/sna/install/reports/customMessages
    
  • Add the files to the custom messages folder of the presentation services on the OBIEE server. For example, BI_INSTANCE_HOME/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages

  • Restart the Oracle BI Presentation Services component coreapplication_obips1.

    Alternately, you can restart all the Oracle BI Presentation Services.

Presentation Services Configuration File

Perform the following steps for the Presentation Services configuration file:

  • Modify the Presentation Services configuration file instanceconfig.xml at the following location:

    MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1
    
  • Edit the Views tag:

    <Views>
          <Cube>
            <CubeMaxRecords>80000</CubeMaxRecords>
            <CubeMaxPopulatedCells>240000</CubeMaxPopulatedCells>
          </Cube>
          <Pivot>
            <MaxPagesToRollOutInDelivery>2000</MaxPagesToRollOutInDelivery>
            <MaxVisibleColumns>2000</MaxVisibleColumns>
            <MaxVisiblePages>10000</MaxVisiblePages>
            <MaxVisibleRows>5000</MaxVisibleRows>
            <MaxVisibleSections>9000</MaxVisibleSections>
            <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
            <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
            <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
            <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
            <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
            <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
            <DefaultRowsDisplayedInDownload>7500</DefaultRowsDisplayedInDownload>
            <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
            <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
            <DisableAutoPreview>false</DisableAutoPreview>
          </Pivot>
          <Table>
            <MaxCells>200000</MaxCells>
            <MaxPagesToRollOutInDelivery>8000</MaxPagesToRollOutInDelivery>
            <MaxVisiblePages>10000</MaxVisiblePages>
            <MaxVisibleRows>5000</MaxVisibleRows>
            <MaxVisibleSections>8000</MaxVisibleSections>
            <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
            <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
            <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
            <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
            <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
            <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
            <DefaultRowsDisplayedInDownload>7500</DefaultRowsDisplayedInDownload>
          </Table>
          <Trellis>
            <Simple>
                <MaxCells>1000</MaxCells>
                <MaxVisibleSections>10</MaxVisibleSections>
                <MaxVisiblePages>1000</MaxVisiblePages>
                <MaxVisibleRows>100</MaxVisibleRows>
                <MaxVisibleColumns>75</MaxVisibleColumns>
                <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
                <DefaultRowsDisplayed>10</DefaultRowsDisplayed>
                <DefaultRowsDisplayedInDelivery>100</DefaultRowsDisplayedInDelivery>
                <DefaultRowsDisplayedInDownload>6500</DefaultRowsDisplayedInDownload>
            </Simple>
            <Advanced>
                <MaxCells>5000</MaxCells>
                <MaxVisibleSections>50</MaxVisibleSections>
                <MaxVisiblePages>1000</MaxVisiblePages>
                <MaxVisibleRows>250</MaxVisibleRows>
                <MaxVisibleColumns>150</MaxVisibleColumns>
                <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
                <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
                <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>            <DefaultRowsDisplayedInDownload>10000</DefaultRowsDisplayedInDownload>
            </Advanced>
          </Trellis>
          <Charts>
            <MaxVisibleColumns>2000</MaxVisibleColumns>
            <MaxVisiblePages>10000</MaxVisiblePages>
            <MaxVisibleRows>5000</MaxVisibleRows>
            <MaxVisibleSections>8000</MaxVisibleSections>
            <JavaHostReadLimitInKB>16384</JavaHostReadLimitInKB>
          </Charts>
          <Narrative>
            <MaxRecords>80000</MaxRecords>
            <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
          </Narrative>
          <Ticker>
            <MaxRecords>80000</MaxRecords>
          </Ticker>
      </Views>
    
  • Edit the ODBC tag:

    <ODBC>
    <!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
    <ResultRowLimit>100000</ResultRowLimit>
    </ODBC>
    

Merging Social Network Analytics rpd

Merge SNA rpd into OCDM rpd.. Ensure that you include the variables and initialization blocks when merging SNA rpd into OCDM rpd..

Merging Social Network Analytics Webcat

Merge OCDM sample reports with SNA reports by performing the following steps:

  • Create a new shared folder and set the relevant permissions and privileges. For example, Shared Folder/Social Network Analytics.

  • SNA webcat contains a shared folder Social Network Analytics with alias sna. Copy and merge the new shared folder Shared Folder/Social Network Analytics into the existing webcat which is used for Billing Analytics, OCDM sample reports, and other adapters. All the SNA objects are located within the new shared folder Shared Folder/Social Network Analytics.

Starting and Stopping Oracle Business Intelligence

For information on starting and stopping Oracle Business Intelligence (OBI), refer "Using Fusion Middleware Control to Start and Stop Oracle Business Intelligence System Components and Java Components" section in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.