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

E37744-04
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

D Oracle Communications Billing Analytics Postinstallation Steps

This appendix describes the prerequisites and postinstallation steps for Oracle Communications Billing Analytics. It includes the following sections:

Prerequisites for Oracle Communications Billing Analytics

The following are the prerequisites for Oracle Communications Billing Analytics (BA):

  • Before the postinstallation steps in this appendix, you must install the Billing Analytics component.

  • Before the postinstallation steps in this appendix, you must install Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.0. To complete the Billing Analytics Repository merge on a Windows system, you must use Oracle BI Administration Tool version 11.1.1.7.0 and Repository version 325 or above.

  • Before the postinstallation steps in this appendix, you must configure Oracle Communications Data Model sample reports on Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.0.

  • Before the postinstallation steps in this appendix, you must copy the Billing Analytics repository files from the following Oracle Communications Data Model location:

    $ORACLE_HOME/ocdm/addon/analytics/ba/
    

Postinstallation Steps for Oracle Communications Billing Analytics

This section contains the following topics:

Oracle Communications Billing Analytics Repository Merge

To complete the repository merge for the Oracle Communications Billing Analytics, perform the following steps:

  1. Start the Oracle BI Administration Tool. In the Create New Repository - Repository Information screen, enter the appropriate details, as described in Table D-1:

    Figure D-1 Oracle BI Administration Tool Repository Information Screen

    Description of Figure D-1 follows
    Description of "Figure D-1 Oracle BI Administration Tool Repository Information Screen"

    Table D-1 Oracle BI Admin Tool Repository Information Screen Fields

    Field Description

    Create Repository

    Select the Binary option

    Name

    Specify the default Name Dummy.rpd

    Location

    Retain the default location.

    import Metadata

    Select No

    Repository Password

    Specify a password

    Retype Password

    Specify the same password


    Click Finish.

  2. Select the current OCDM repository in the Oracle BI Administration Tool.

    Figure D-2 Oracle BI Administration Tool

    Description of Figure D-2 follows
    Description of "Figure D-2 Oracle BI Administration Tool"

  3. From the File menu, select Merge.

    Figure D-3 Oracle BI Administration Tool Billing Analytics Screen

    Description of Figure D-3 follows
    Description of "Figure D-3 Oracle BI Administration Tool Billing Analytics Screen"

  4. The Merge Repository Wizard screen is displayed. Select Select Input Files and enter the appropriate information, as described in Table D-2:

    Figure D-4 Oracle BI Administration Tool Select Input Files Tab

    Description of Figure D-4 follows
    Description of "Figure D-4 Oracle BI Administration Tool Select Input Files Tab"

    Table D-2 Oracle BI Admin Tool Merge Repository Wizard Screen Fields

    Field Description

    Merge Type

    Select the Full Repository Merge option

    Original Master Repository

    Click Select and select the default dummy.rpd repository

    Repository Password

    Specify a password

    Modified Repository

    Click Select and select the current OCDM repository

    Repository Password

    Specify the default password Odwt123456

    Current Repository

    No changes as this field is grayed out

    Save Merged Repository as

    Click Select and select the merged repository

    Repository Password

    Specify a password


    Click Next.

  5. Select Define Merge Strategy in the Merge Repository Wizard screen. You will see the current repositories listed in the Conflicts section. Select Current from the Decision drop-down list for all the current repositories.

    Figure D-5 Oracle BI Administration Tool Define Merge Strategy Tab

    Description of Figure D-5 follows
    Description of "Figure D-5 Oracle BI Administration Tool Define Merge Strategy Tab"

    Click Finish.

    Note:

    The Repository Merge may require a significant amount of time to complete, based on the size of the repositories.

    When the Repository Merge is complete, it is saved in the Save Merged Repository field as shown in step 4:

    Figure D-6 Oracle BI Administration Tool Repository Merge ocdm.rpd

    Description of Figure D-6 follows
    Description of "Figure D-6 Oracle BI Administration Tool Repository Merge ocdm.rpd"

  6. Validate the information in the Connection Pool screen and enter the appropriate information, as described in Table D-3:

    Figure D-7 Oracle BI Administration Tool Connection Pool Screen

    Description of Figure D-7 follows
    Description of "Figure D-7 Oracle BI Administration Tool Connection Pool Screen"

    Table D-3 Oracle BI Admin Tool Connection Pool Fields

    Field Description

    Name

    Specify the default Name Connection Pool

    Call Interface

    Select Default (OCI 10g/11g) from the drop-down list.

    Maximum Connections

    Select 10 from the drop-down list.

    Data source name

    Specify the data source name. The name can be the TNS name or the TNS description.

    Shared logon

    Select the check box

    User Name

    Specify a user name

    Password

    Specify a password

    Enable connection pooling

    Select the check box

    Timeout

    Select 5 minutes from the drop-down list.

    Use multithreaded connections

    Select the check box

    Parameters supported

    Select the check box


Oracle Communications Billing Analytics webcat Merge

To complete the webcat merge for the Oracle Communications Billing Analytics, perform the following steps:

  1. Check the billing_analytics directory at the following location:

    $ORACLE_HOME/ocdm/addon/analytics/ba/
    
  2. Verify the webcat sample reports for the current OBIEE.

  3. Login to Oracle Enterprise Manager 11g and perform the following steps:

    1. Expand the Business Intelligence tab and click coreapplication

    2. Click Deployment and then click Repository

    3. In the BI Presentation Catalog, verify the catalog location:

      $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/ocdmwebcat
      

      Figure D-8 Oracle Enterprise Manager 11g coreapplication Tab

      Description of Figure D-8 follows
      Description of "Figure D-8 Oracle Enterprise Manager 11g coreapplication Tab"

  4. In the ocdmwebcat, change the directory name to Shared folder.

    Figure D-9 ocdmwebcat Directory

    Description of Figure D-9 follows
    Description of "Figure D-9 ocdmwebcat Directory"

    If there are existing billing+analytics and billing+analytics.atr folders, delete it.

  5. Copy billing+analytics and billing+analytics.atr folders from the billing_analytics webcat to ocdmwebcat.

    Figure D-10 billing_analytics to ocdmwebcat Folder

    Description of Figure D-10 follows
    Description of "Figure D-10 billing_analytics to ocdmwebcat Folder"

  6. In instanceconfig.xml , perform the following steps:

  7. In NQSConfig.INI file, perform the following steps:

  8. In Oracle Enterprise Manager 11g, expand the Business Intelligence tab, click coreapplication, and then click Lock and Edit Configuration.

    Figure D-15 Oracle Enterprise Manager Lock and Edit Configuration Tab

    Description of Figure D-15 follows
    Description of "Figure D-15 Oracle Enterprise Manager Lock and Edit Configuration Tab"

    After the lock is set, upload the merged repository.

    Figure D-16 Oracle Enterprise Manager 11g coreapplication Tab

    Description of Figure D-16 follows
    Description of "Figure D-16 Oracle Enterprise Manager 11g coreapplication Tab"

  9. Next, restart OBIEE using opmnctl by performing the following steps:

    • Run $ORACLE_INSTANCE/bin/opmnctl stopall

    • Run $ORACLE_INSTANCE/bin/opmnctl startall

    • Run $ORACLE_INSTANCE/bin/opmnctl status

    Figure D-17 Processes in Instance Screenshot

    Description of Figure D-17 follows
    Description of "Figure D-17 Processes in Instance Screenshot"

    Note:

    The status for OracleBIPresentationServicesComponent must be in Down state.
  10. Revert the instanceconfig.xml and NQSConfig.INI changes added in step 6 and step 7.

    Figure D-18 Processes in Instance Screenshot

    Description of Figure D-18 follows
    Description of "Figure D-18 Processes in Instance Screenshot"

    Restart OBIEE.

    Note:

    The status for all the ias-components must be in active state.
  11. Login to Oracle Communications Billing Analytics. Select Dashboard and expand the Billing Analytics dashboard. The BA Dashboards tab will be displayed.

    Figure D-19 Oracle Communications Billing Analytics Dashboard Tab

    Description of Figure D-19 follows
    Description of "Figure D-19 Oracle Communications Billing Analytics Dashboard Tab"

  12. Click BA Dashboards to view the Oracle Communications Billing Analytics Homepage.

    Figure D-20 Oracle Communications Billing Analytics Homepage

    Description of Figure D-20 follows
    Description of "Figure D-20 Oracle Communications Billing Analytics Homepage"