Oracle® Business Intelligence Server Administration Guide > Query Caching in the Oracle BI Server > Cache Event Processing with an Event Polling Table >

Making the Event Polling Table Active

After the table is created on the physical database, you can make it active in the Oracle BI Server.

To make the polling table active

  1. Import the table to the Physical layer.
  2. Include it in the group of Oracle BI Server event polling tables using the Tools > Utilities > Oracle Event Tables menu item, and set a polling interval.

To import the polling table into the Physical layer, perform the following steps from an open repository.

To import the table into the Physical layer

  1. Select File > Import...
  2. Select the data source containing the event table to import, and then click OK.

    The Import dialog box appears.

  3. Check the Tables option to import the table metadata.
  4. Navigate to the event polling table, select the table and either click the Import button or drag and drop it into the Physical layer.

This imports the event table to the Physical layer. If you have multiple event polling tables, repeat this procedure for each event table.

NOTE:  Be sure the data source specified for the event table has read and write access to the event table. The repository will both read the table and delete rows from it, so it needs write permission. Event tables do not need to be exposed in the Business Model and Mapping layer.

After one or more polling tables are present in the Physical layer, you need to include them in the group of event polling tables.

To mark the table object as an Event Polling Table

  1. Click on the Tools > Utilities menu item.
  2. Select the option Oracle BI Event Tables from the list of options.
  3. Click Execute.
  4. Select the table to register as an Event Table and click the >> button.
  5. Specify the polling frequency in minutes, and click OK.

    The default value is 60 minutes.

    NOTE:  You should not set the polling frequency to less than 10 minutes. If you want a very short polling interval, consider marking some or all of the tables noncachable.

When a table has been registered as an Oracle BI Server event table, the table properties change. Registration as an event table removes the option to make the table cachable, as there is no reason to cache results from an event polling table.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.