Specify the Usage Tracking Database

Before you can track usage of reports, dashboards, and data visualization workbooks on your system, you must specify the database where you want to store the usage tracking statistics.

The database you specify must have at least one schema defined. The system creates usage tracking tables in the schema whose name matches the user name you specify in the connection pool details. For example, if the name of a schema in the usage tracking database is “ANALYTICS_USAGE”, you must specify "ANALYTICS_USAGE" in the User Name field for the connection pool. The usage tracking-tables are created in the schema named “ANALYTICS_USAGE”.

You must configure the database and connection pool details in the physical layer of your semantic model. Use the Model Administration Tool to edit the semantic.

1. In Model Administration Tool, open the semantic model .
   From the File menu, select Open. Enter connection information for your instance.
2. Specify the usage tracking database:
   1. In the Physical layer of the semantic model, right-click and select New Database.
   2. In the Database dialog, provide a name for your database, specify the database type, for example Oracle 12c, and click OK.
   3. Right-click the newly created database, select New Object, and then select Connection Pool.
   4. In the Connection Pool dialog, enter a name for the connection pool and specify values for:
      • Call interface: Select Default (Oracle Call Interface (OCI)).
      • Require fully qualified table names: Ensure that this check box isn't selected.
      • Data Source Name: Specify the data source to which you want this connection pool to connect and send physical queries. For example:(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = <DB Host>)(PORT = <DB port>))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = <Servicename>)))

        As an alternative to providing the data source name, select the Use Console Connection check box and enter the name of the database connection that you defined for the semantic model in the Console in the Connection Name field. You can define database connections for semantic models using the Console. If you want to use the same database connections in the Model Administration Tool, you don’t have to re-enter the connection details. Instead, refer to the database connections “by name” in the Connection Pool dialog. While creating a connection to Oracle Autonomous Data Warehouse, if you had selected the System Connection check box in the Create Connection dialog, then you can select Use Data Connection and enter the connection's Object ID instead of entering the connection details in the Data Source Name field.

        
        Description of the illustration model_admin_tool_connection_pool.gif
      • User name and Password: Enter a user name that matches the name of a schema available in the usage tracking database.
3. Validate your changes by clicking Tools, Show Consistency Checker, and then Check All Objects.
4. Optional: Save changes locally by clicking File, and then Save.
5. Upload the semantic model .rpd file that you edited, to your instance by clicking File, Cloud, and then Publish.