Add multiple Topic Workflow configurations

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

To add additional Topic Workflow configurations to the RPD and catalog, perform the following steps:
  1. Note the configuration ID of the Topic Workflow configuration.
  2. Create a new database account by following the steps in Chapter 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.
    JAVA_HOME Full path to the JDK similar to /u01/app/oracle/product/java/jdk.
    MIDDLEWARE_HOME Full path to the Oracle Fusion Middleware Home, similar to .../u01/app/ oracle/product/fmw/14.2.1.0.
    HOSTNAME Reporting server hostname.
    ADMIN_USER Oracle WebLogic Server administrator user name.
    ADMIN_PASS Oracle WebLogic Server administrator user password.
    RPD_PASS Password for the RPD.
    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 Create link at the top, and then click Analysis.
  16. Verify that a new subject area named Topic area <config ID> appears.

Parent topic: Appendix: Add an additional Topic Workflow Configuration