Specify the Usage Tracking Database Using Semantic Modeler

Use Semantic Modeler to configure your usage tracking database if you currently use Semantic Modeler to develop semantic models.

  1. If you haven't done so already, create a data connection to your usage tracking database with the System Connection option selected.
    The database type must be either Oracle Database or Oracle Autonomous Data Warehouse and the User Name used to connect to the database must match the name of the schema where you want the user tracking tables to be stored. See Prerequisites for Usage Tracking.
  2. On the Home page, click Navigator and then click Semantic Models. In the Semantic Models page, click a semantic model to open it.
  3. Create a database object for the usage tracking database.
    1. Click Physical Layer.
    2. In the Physical Layer pane, click Create and then click Create Database.
    3. In Name, enter a name for the database of your semantic model (for example, UsageTracking) and click OK.
  4. Add a connection pool to connect to the usage tracking database.
    1. In the database tab, click Connection Pools.
    2. Click Add Source.
    3. Double-click the Name field, and enter a name for the connection pool. For example, UTConnectionPool.
    4. Double-click the Connection field, and select the data connection you want to use from the list. For example MyUTDatabase.

      Note:

      • System connection - Semantic models can only use data connections with the System connection option selected. See About Semantic Model Data Source Connections.

      • User Name and Password - The User Name specified in the data connection must match the name of a schema in the database that you want to use for usage tracking. For example, if the schema you want to use is called UT_Schema, the User Name must be UT_Schema. See Prerequisites for Usage Tracking.

    5. Click Open Detail. In the Connection Pool pane, verify that the Require fully qualified table names check box isn't selected.
  5. Validate your changes. See Run the Advanced Consistency Check Before Deploying a Semantic Model.
  6. Save your changes.