IBM FileNet P8, Version 5.2.1            

Create a lookup table

Procedure

To create a lookup table:

  1. Open IBM® Cognos® Real-time Monitoring Workbench and select the IBM FileNet® Case Monitor\Common folder.
  2. Click Activities and click Create New > Lookup Table.
  3. Select JDBC (Java™ Database Connectivity) for the type of lookup table source. Click Continue.
  4. 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.
  5. 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.

  6. 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.
  7. On the Field Information tab:
    • Select Index next to the dimension key field.
  8. 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.
  9. Click Save lookup table.


Last updated: October 2015
bas_context_add_new_1.htm

© Copyright IBM Corporation 2015.