Prerequisites

This configuration procedure is required only if you have a license for OFSAAI Enterprise Modelling.

Once you license OFS Advanced Analytical Applications Infrastructure, the following configurations must be made to use the Modelling features. These steps are required to verify and execute the models that are packaged with the OFS LLFP application.

Note:

Ensure that Oracle R Enterprise Server version 1.5.1 is installed on the database server and AAAI Runner Package is installed on the DB server before you perform these configurations. Also, you must access the application with the required privileges.
  1. In the config schema, create a new schema with the following grants:

    grant create SESSION to <<schema_user>>; grant create PROCEDURE to

    <<schema_user>>; grant create SEQUENCE to <<schema_user>>; grant create TABLE to <<schema_user>>; grant create TRIGGER to <<schema_user>>; grant create VIEW to <<schema_user>>;

    grant create MATERIALIZED VIEW to <<schema_user>>;

    grant create SYNONYM to <<schema_user>>;

    grant unlimited TABLESPACE to <<schema_user>>;

  2. Grant the RQADMIN role to the config schema user by executing the following query:

    grant RQADMIN to <<config_schema>>; grant RQADMIN to <<atomic_schema>>; grant RQADMIN to <<pdmodel_schema>>;

  3. If Data Redaction is enabled, execute the following query:

    alter user <<pdmodel_schema>> default role RQADMIN; grant OFS_SEC_DATA to <<schema_user>>; grant OFS_NOSEC_DATA to <<schema_user>>;

  4. Log in to the application using System Administrator privileges.
  5. Navigate to System Configuration, then Configure Database Server, and then click Configure Database Server.
  6. Add a new database server. For more information about adding a new database server, see the Adding Database Server Details section in the OFS Analytical Applications Infrastructure User Guide.
  7. Navigate to System Configuration & Identity Management tab.
  8. Click Administration and Configuration, select System Configuration, and click Database Details.
  9. Make a TNS entry for the newly created database. For more information, see the Adding Database Details section in the OFS Analytical Applications Infrastructure User Guide.
  10. Create a new information domain for the sandbox and create a new segment. For more information, see the Creating Information Domain and Creating Segment sections in the OFS Analytical Applications Infrastructure User Guide.
  11. Navigate to Identity Management, then Security Management, then User Administrator, and then User Group Domain Map.
  12. Map the newly created sandbox information domain to the LLFP Admin Group. For more information about mapping a domain to a specific user group, see the User Group Domain Map section in the OFS Analytical Applications Infrastructure User Guide.
  13. Map the LLFP Admin User to the EMF Group. For more information about mapping a user to a specific user group, see the User Group Role Map section in the OFS Analytical Applications Infrastructure User Guide.