Starting The Information Designer

The Information Designer is used to create a universe for Easy Reporter.

A universe is a collection of tables and columns from a selected database. It can also contain joins between tables, filters to exclude data and items derived from the underlying data.

The advantage of creating a universe, instead of examining the database directly, is that you can choose which tables in the database are available to the report designer using the Easy Reporter. You can create a universe for a single user, or a group of similar users, that includes only relevant parts instead of the whole database.

To start the Information Designer click the Information Designer link in the Netcool Reporter window. An example Information Designer window is shown below.

 

   Figure 203: Information Designer Window

Information Designer Window Navigation

The Information Designer window, shown in Figure 203, is divided into three areas.

•   Menu and toolbar

•   Universe Panel

•   Database Panel

Menu and Toolbar

The Information Designer window menus are displayed at the top of the window. The button bar is displayed below these menus. The buttons on the button bar are described in the following table.

Table 66: Button Bar Button Descriptions.

Button Bar Button

Description

 

Creates a new universe, as described in Creating a Universe on page 326.

 

Opens an existing universe, as described in Opening a Universe on page 327.

 

Saves the open universe, as described in Saving a Universe on page 328.

 

Opens the Import Database Tables window, as described in Importing Base Tables on page 330. Use this window to select the databases to display in the Base Tables tab.

 

Opens the New Folder window, as described in Creating Empty Folders on page 334. Use this window to create new universe folders in the Folders & Items tab.

 

Opens the New Item window, as described in Adding Items on page 335. Use this window to create a new universe item in the selected universe folder.

 

Opens the New Join window, as described in Creating Joins on page 338. Use this window to create a new join between database tables. This join is applied to the universe.

 

Opens the New Filter window, as described in Universal Filters on page 341. Use this window to create a new filter between database tables. Once created, this filter must be applied to a folder in the universe.

Universe Panel

The universe panel is displayed on the left. It contains two tabs which display information about the universe you are currently working on. The tabs are:

•   Folders & Items

•   Joins

Click the Folders & Items tab to bring the tab to the foreground. This tab displays all of the folders, items, and filters in the universe.

Universe folders are analogous to tables in a relational database. To make report creation clearer the name of the folder does not have to match the name of an underlying database table.

Items in a folders are analogous to columns in a relational database's tables, however, the values in an item can be derived using expressions and multiple columns. To make report creation clearer the name of the item does not have to match the name of an underlying database column or columns.

Filters restrict the data that can be displayed from the underlying database tables. You can create as many filters for each folder as you like. A report designer using Easy Reporter can select any number of these filters when creating a report.

Click the Joins tab to bring the tab to the foreground. This tab displays all of the joins you have defined for the current universe. A join provides a way of relating two folders, usually through corresponding items in both folders. The join is created between columns in two underlying database tables.

Database Panel

The database panel is displayed on the right. It contains two tabs which display information about the tables you want to use as underlying database tables for your universe. The tabs are:

•   Base Tables

•   Filters

Click the Base Tables tab to bring the tab to the foreground. This tab displays the tables you have imported. You can expand the table to display the available columns. Universe folders are created by adding tables to your universe. Items are created by adding table columns to your universe folder.

Click the Filters tab to bring the tab to the foreground. This tab displays the filters you have created from the imported database tables.