You can create a Cognos® Business Intelligence report against a
background search table without creating a cube.
Procedure
To create a simple report:
- Generating search results with a background search sweep. Create and run a background search from the
administration console.
Example: Install the FileNet P8 5.2.1 Reporting AddOn
and run the Document Usage By User report from the administration console. For information
about installing add-ons, see Installing an add-on feature to an object store.
Here is the background search expression for that
report:
SELECT Creator AS CmRptUser,
COUNT(Id) AS CmRptObjectCount,
SUM(ContentSize) AS CmRptContentSize,
MIN(DateCreated) AS CmRptDateFirstCreated,
MAX(DateCreated) as CmRptDateLastCreated
FROM Document
GROUP BY CmRptUser
- Finding table and column names. In the object store database, get the following
information:
- The name of the result table for your background search
- The column names of the table
- Creating a data source. Create a Cognos
data source to access your search result data.
- Create a package from IBM® Cognos Framework Manager:
- Start Framework Manager.
- Create and name a new project.
- In the Metadata wizard, select Data Sources and click
Next.
- Select the data source that you created and click Next.
- Select your Content Platform Engine object by expanding the tables for your schema and
selecting the result table that you identified.
Example: Select the name of the table as found in the appendix (for example,
UT_CmRptDocumentUsageByUser). Click Next.
- Take the defaults for the Generate Relationships screen. Click Import
and then Finish.
- In the left pane under Project Viewer, right-click Packages and select .
- Name the new package and click Next.
- Define the objects by selecting the columns to include in the package and click
Next.
- Select the function set that is appropriate for your data source and click
Finish.
- Open the publish package wizard and click Yes.
- Choose a folder location for the package or take the defaults and click
Next.
- Define security as needed and click Next.
- Click Publish on the last screen and click Finish
to exit the wizard.
- Create a simple Cognos report by using Query
Studio:
- Open a browser window to Cognos Connection and at the
Welcome screen, under My Actions, select Query my
data.
- Select your package in the folder that you chose when you published it. Open it.
- Insert columns into the report by selecting them in the left pane and click
Insert.
- As needed, define titles, columns, filters, sorting, and other report details.
- Chart the data by clicking the Chart icon and choose the chart
type.