Start of changeIBM FileNet P8, Version 5.2.1            

Publishing a cube

You can use Cognos® Cube Designer connect to publish a cube.

Procedure

To publish a cube:

  1. Start Cube Designer and select Create New from Metadata.
  2. Select a database schema by using the data source name that you created in the previous step and click OK.
  3. In the left Source pane, right-click the results table name and select Generate > Cube with basic dimensions.
  4. Create foreign keys in the database.
    Important: You are prompted to create one of the following items:
    • Foreign keys.
    • Dimensions. You create dimensions manually in the Cube Designer.
    This procedure assumes that you are creating foreign keys. If you later delete background search result classes, you might have to remove the foreign keys manually.
    1. Issue a command such as the one shown in the following example for DB2:
      ALTER TABLE ut_cmrptDocumentUsageByUser1
      ADD FOREIGN KEY (u50b7_cmrptuserrecord)
      REFERENCES ut_cmrptUserRecord (object_id)
    2. Click OK to exit the prompt.
  5. Define member captions for the levels:
    1. In the middle (Project Explorer) pane, drill down to the dimension table level and double-click it. For example, for the Document usage By User Record report, open the UT_CmRptUserRecord level.
    2. In the right pane that opens for the table, under the member caption column, select the caption and do the same for the member description column. Do the same for other levels as needed.
  6. Rename the tables and levels and configure further as wanted.
  7. In the middle pane, right-click the fact table and click Publish.
  8. Under additional options, select Select all options or alter as needed.
  9. Click OK.


Last updated: October 2015
p8pcc450.htm

© Copyright IBM Corporation 2015.
End of change