Procedure
To create a lookup table:
- Open IBM®
Cognos® Real-time Monitoring Workbench
and select the IBM
FileNet® Case Monitor\Common folder.
- Click Activities and click .
- Select JDBC (Java™ Database Connectivity) for the type of
lookup table source. Click Continue.
- Select an agent from the JDBC Connection list.
If you have imported any of the preconfigured Case Monitor objects, you can use
the provided Import the IBM FileNet Case Monitor project.
- Enter the following query in Query:
select * from D_DMDataField_dimension
where dimension is
the name of the dimension you have exposed on Case Analyzer. Click Continue.
- Enter the name and description of the new lookup table.
Tip: For clarity, use the name of the Case Analyzer dimension in the lookup
table name. For example, for a Case Analyzer dimension
named Location, name the lookup table Location_LookupTable.
- On the Field Information tab:
- Select Index next to the dimension key
field.
- On the Data Caching tab:
- Select the Cache data for this lookup table option.
- Clear the Enable prefetch option.
- Set the Number of result sets to cache based
on the expected number of entries. Match the number of rows that are
estimated to exist in the Case Analyzer dimension
table.
- Set the Invalidation Schedule by clicking Add
Schedule and set an interval value so that it is never
invalidated. For example, set an invalidation schedule that runs once
a year on February 31. There is no reason to invalidate the cache
because the Case Analyzer dimension
members will not change.
- Click Save lookup table.