Create a new context and dimension for a Process Analyzer dimension
When you add a user-defined dimension on the Process Analyzer for use in Business Activity Monitor, you must create a corresponding Business Activity Monitor context and dimension using the
FileNet Application Workbench.
To create a context
- Open the FileNet Application Workbench and select the Contexts folder. Click New Context.
- Select JDBC for the type of context source. Click Continue.
- Select an agent from the JDBC Connection drop-down list. If you have imported any of the pre-configured Business Activity Monitor objects, you can use the provided VMAEDM_JDBC_Agent.
- Enter the following query in Query:
select * from D_DMDatafield<dimension>
where <dimension> is the name of the dimension you have exposed on the Process Analyzer. Click Continue.
- Enter the name and description of the new context, as desired.
TIP For clarity, use the name of the Process Analyzer dimension in the context name. For example, for a Process Analyzer dimension named Location, name the context Location_Context.
- On the Data Caching tab:
- Check Cache data for this context.
- Set the Number of result sets to cache and Invalidation Schedule based on the expected number of entries and how often the information is likely to change.
- Click Save context.
To create a dimension
- Open the
FileNet Application Workbench and select the Dimension folder. Click New Dimension.
- Enter the name and description of the new dimension, as desired.
TIP For clarity, use the name of the Process Analyzer dimension in the dimension name. For example, for a Process Analyzer dimension named Location, name the dimension Location_Dimension.
- In the Hierarchy Information section:
- Select the field(s) for your hierarchy. Do not select key fields (where the name ends with "_key") in this section.
- For the key fields, check the Key Field box next to the field(s) you selected for the hierarchy.
- Click Save dimension.