Creating an IBM® Cognos Business Intelligence report by using a cube

You can create a Cognos Business Intelligence report against a background search table by using a Cognos dynamic cube. The cube is created with Cognos Cube Designer.

To create a report by using a cube:

1. Generating search results with a background search sweep. Create and run a background search from the administration console.

   Example: Install the Content Cortex 5.2.1 Reporting AddOn add-on 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 CmRpt::UserRecord(Creator) AS CmRptUserRecord,
   COUNT(Id) AS CmRptObjectCount,
   SUM(ContentSize) AS CmRptContentSize,
   MIN(DateCreated) AS CmRptDateFirstCreated,
   MAX(DateCreated) as CmRptDateLastCreated
   FROM Document
   GROUP BY CmRptUserRecord
   

   This report populates a user record dimension table from the Java Script code that is in the CmRpt::UserRecord() custom search function definition handler.

2. 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
3. Creating a data source. Create a Cognos data source to access your search result data.
4. Publishing a cube. Use Cognos Cube Designer connect to publish a cube.
5. Create a report from the cube by using Cognos Workspace Advanced (although other reporting tools can be used as well):
   1. From local connection, in the upper right corner, select Launch Cognos Workspace Advanced.
   2. In the window that starts, navigate to the Cognos folder (for example, My Folder) and click the name of your package. The Cognos Workspace Advanced window opens.
   3. Click Create New, select a type (for example, Chart), and click OK.
   4. Select the type of chart in the next window. For example, take the column default.
   5. In the right pane of the Cognos Workspace Advanced window, expand down to the fact table (for example, CmRptDocumentUsageByUser).
   6. Drag the measure (for example, CmRptObjectCount) to the left pane chart under Default measure (y-axis).
   7. In the right pane, also drag the dimension table to the left pane chart under Default measure (x-axis).