Logging Analysis Requests to Auxiliary Database

TARGIT Management comes with the option to log all analysis requests to a database.

To enable logging, you need to create a new database on a Microsoft SQL Server with Analysis Services installed. You can call this TARGIT_Log.

Setting up the connection

Next, you need to create an auxiliary connection in TARGIT Management on the Connections tab.

1. Right-click in the white area and click "Add..."
2. Select "Other", then "Auxiliary Relational Database"
3. Give the connection a name and click "Next"
4. Click "Change connection string". On the Connection tab, select your new database and provide credentials if required. Click OK.
5. Click "Create".

Enabling logging

To enable logging, go to the Setup tab.

1. Click Back-end.
2. In the window, check the boxes "Log Analysis requests to auxiliary database" and "Log storyboard requests".
3. Select for how long you want to keep the log information in the database.
4. Restart the TARGIT Server to start logging.