AudienceView Connect
AudienceView Documentation

Setting the Default Reporting and BI Database

Your IT department (for Enterprise clients) or the AudienceView Hosting department (for Hosted clients) can configure separate databases for transactions and reporting. This allows you to run reports and BI queries without hindering transactions.

If a separate reporting database has been configured, you can set the default database that will appear in the 'Database' dropdown found in the Saved Report Configuration section of the Generated Reports|Parameters and Saved Reports|Parameters pages or the run lists section of the Business Intelligence|Results page.

To set the default reporting database, complete the following:

  1. Open the Registry application from the AudienceView Desktop.
  2. If you want to set the default database for reports, complete the following:
    1. Navigate to the Registry::Business Objects::TSreportBO::Reports::Database node.
    2. Enter the name of the reporting database in the 'Default Value' field.
      The value entered should match the 'Node Name' of the database configured in the Registry application System::Databases section.
      For more information, refer to System Databases Category.
    3. Click 'Apply'.
      A window confirms that the application updated the Registry.
    4. Click 'OK'.
  3. If you want to set the default database for BI queries, complete the following:
    1. Navigate to the System::Application node.
    2. Enter the name of the reporting database in the 'Default Value' field.
      The value entered should match the 'Node Name' of the database configured in the Registry application System::Databases section.
      For more information, refer to System Databases Category.
    3. Click 'Apply'.
      A window confirms that the application updated the Registry.
    4. Click 'OK'.