Add multiple Topic Workflow Configurations

You have the option to report on more than one topic workflow configuration.

Oracle Empirica Signal supports multiple Topic Workflow Configurations (TWC). After the initial installation, only one Topics model is available—either the default Topics or the GVP Module IX Topics. To add additional TWC to the RPD and catalog, perform the following steps:
  1. Note the configuration ID of the TWC.
  2. Create a new database account by following the steps in Section 3: Prepare the Oracle Empirica Signal Database Server for Oracle Analytics.
  3. In <TOPICS_OBIEE_INSTALL_DIR>/config/Multi_TWC_Support, locate addTwc.sh.
  4. Open addTwc.sh using a text editor, set the values for the following parameters:
    Name Value
    CONFIG_ID Topic workflow configuration ID.
    RPD_TYPE GVP for GVP Module IX or SAMPLE for the default.
    DOMAIN_HOME Full path to the Oracle Fusion Middleware Home, similar to .../u01/app/ oracle/Middleware/ Oracle_Home/user_projects/bi.
    ADMIN_USER Oracle WebLogic Server administrator user name.
    RPD_CONN_USER User name for the RPD connection database user. If using the proxy user, the format should be <proxy user>[OBIEE_TOPIC_WORKFLOW_xx].
    RPD_CONN_PASS Password for the RPD connection. If using the proxy user, set it to the proxy user’s password.
    RPD_CONN_DATASOURCE TNS-style connection string for the RPD, similar to: 
    (DESCRIPTION=(ADDRESS=(PROTOC OL=T CP)
(HOST=<DB host URL>) (PORT=<DB port>))
(CONNECT_DATA=(SERVICE_NAME=<
DBservicename>)))
    DOMAIN_NAME Oracle Analytics domain name, such as bi.
    BI_PORT Oracle Analytics admin port, such as 9502.
  5. Save addTwc.sh.
  6. Log into the Linux server hosting Oracle Analytics using the non-privileged account.
  7. Navigate to <TOPICS_OBIEE_INSTALL_DIR>/config/Multi_TWC_Supportcd <TOPICS_OBIEE_INSTALL_DIR>/config/Multi_TWC_Support.
  8. Issue the following command:
    chmod +x addTwc.sh
  9. Execute the following script:
    ./addTwc.sh
  10. After the update completes, the following message appears: Completed updating the RPD.
  11. Using an Oracle Empirica Signal username that has a BI or superuser privilege, log into Oracle Analytics Server using the following URL: http://<OASserver name>:<OA_port>/analytics.
    For example: http://<servername>:9502/analytics.
    The Oracle Analytics screen appears.
  12. Click the Catalog link at the top.
  13. In the Folders section on the left, expand Shared Folders.
  14. Verify that a folder named Topics_<config ID> (e.g. Topics_60) has been created.
  15. Click on Create link at the top and then click Analysis.
  16. Verify a new subject area named Topic area <config ID> appears.

Parent topic: Appendix: Add an additional Topic Workflow Configuration