You can use Cognos® Cube Designer connect to
publish a cube.
Procedure
To publish a cube:
- Start Cube Designer and select Create New from Metadata.
- Select a database schema by using the data source name that you created in the previous step
and click OK.
- In the left Source pane, right-click the results table name and select .
- 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.
- 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)
- Click OK to exit the prompt.
- Define member captions for the levels:
- 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.
- 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.
- Rename the tables and levels and configure further as wanted.
- In the middle pane, right-click the fact table and click Publish.
- Under additional options, select Select all options or alter as
needed.
- Click OK.