This JavaScript example of a CmRpt::UserRecord custom search function
creates and uses a custom root class to store dimension table data. Such data can be used for an
OLAP reporting tool such as IBM®
Cognos® Business Intelligence.
About this task
Tip: As an optional alternative to JavaScript, you can code your handler definition in a Java™ code module.
You can write other custom search functions and handlers to populate dimension tables with level
data. Here are some examples:
NewRpt::UserRecord() |
User record. Stores an LDAP group as a column in a record table.
|
NewRpt::ClassRecord() |
Class record. Stores the parent or top level class as an extra column in a custom root class
table.
|
NewRpt::DateRecord() |
Date record. Extracts and stores the day, month, and year as columns in a new custom root class
table.
Important: Extracting and storing the day might produce more rows than are
needed.
|
Procedure
To see an example of a custom search function handler that populates a dimension
table:
- Install the FileNet® P8 5.2.1 Reporting Enablement AddOn add-on. For more information, see Installing an add-on feature to an object store.
- Access the node for search function definitions in the administration console:
- In the domain navigation pane, select the object store.
- Expand the Events, Actions, Processes node.
- Expand the Search Function Definitions node.
- Click CmRpt::UserRecord.
- In the details pane, click the Type subtab on the new tab.
- Copy the text in the JavaScript text box into an editor for viewing.
What to do next
Use the custom search function in a background search expression. For more information, see
Relational query syntax introduction.