Overview of the IBM Cognos Business Intelligence architecture - IBM Cognos

Before you can build a universe, you must firstly create a new universe file.

When you create a new universe file, you must define a connection parameter to allow the universe to access your database middleware. You can also define other parameters that determine how Designer creates objects, links from the current universe to other universes, and query restrictions.

You save the new universe as a .unv file. The new universe contains no classes and objects. You create these during the universe development process by designing a table schema and then creating objects that map to database structures.

What are universe parameters?

Universe parameters are definitions and restrictions that you define for a universe that identify a universe and its database connections, specify the type of queries that can be run using the universe, and set the controls on the use of system resources.

You define universe parameters from the "Universe Parameters" dialog box (File > Parameters) when you create a universe. The database connection is the only parameter that you must manually select or create when you create a new universe.

You can modify these parameters at any time. You can define the following universe parameters:

What are universe parameters?What are universe parameters?

Creating a new universe

The following procedure describes how you can create a new universe from scratch by defining universe parameters then saving the universe. The procedure provides an overview of all the pages available from the Parameters dialog box.

Defining all the parameters at universe creation may not be necessary. You must select a connection, but you can accept the default values for other parameters, and then modify them as appropriate when necessary.

Creating a new universe from scratch

To create a new universe from scratch:

  1. Select File > New.
    • Type a name and description for the universe.
    • Select a connection from the "Connection" drop-down list box.
    • Or
    • Click the New button if you want to define a new connection that is not listed
      in the drop-down list.
  2. Click the Summary tab.
    • Type universe information in the "Comments" box.
  3. Click the Strategies tab.
    • Select a strategy from each of the Objects, Joins, and Tables drop-down list boxes. Depending on the RDBMS for the connection, there can be more than one strategy available from each drop-down list box.
  4. Click the Controls tab.
    • Select or clear check boxes in the "Query Limits" group box.
    • Enter values for the check boxes that you select.
  5. Click the SQL tab.
    • Select or clear check boxes as appropriate.
  6. Click the Links tab, if you want to link the new universe with an existing universe.
    • Click the Add Link button to select a universe to link with the new universe.
  7. Click the Parameters tab. The "Parameters" page appears. It lists SQL parameters that can be set to optimizeSQL generation.
  8. Click OK
    The universe and structure panes open up in Designer
  9. Select File > Save.
    • Type a name for the universe file.
    • Click Save.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

IBM Cognos Topics