Importing Tables and Creating Folders

A universe is made up of folders, items, joins and filters. You must import the required database tables before you can select the tables and columns to include in your universe folders and items.

When you create a report using Easy Reporter the folders are treated in the same way as database tables and the items are treated in the same way as table columns.

A folder and all of the items within it can be exact copies of an underlying database table and its columns. New folders can also be created that contain only the columns required by the report designer.

For example, the underlying database might contain an employee table containing employee ID numbers, names, e-mail addresses, and salaries. You could create a universe containing the names and e-mail addresses but not sensitive information like salary.

You can change the name of a folder to make it more meaningful. You can also create several folders that contain items from the same database table.

Joins are used to link related underlying tables. Filters are used to reduce the amount of information by delivering a subset of the data in the underlying database.

Importing Base Tables

Before you can create folders and items in a universe you must import the underlying database tables. The Netcool Reporter user interface refers to these database tables as base tables.

To import a base table:

1.   In the Information Designer window, select the menu item CreateÆImport Base Tables, click the Import Base Tables icon or click the Import button at the bottom of the Base Tables tab.

The Import Base Tables window is displayed, as shown below.

 

   Figure 208: Import Base Tables

2.   To import all of the tables in a database, select the database and click the Import button.

3.   To import a single table within a database, expand the database by clicking the + icon to the left of the database name. Select one of the tables and click the Import button.

4.   Repeat steps 2 or 3 until you have imported all of the required tables.

5.   The Import Base Tables window remains open until you click the Close button. The selected tables are listed in the Base Table tab.

Editing Base Table Properties

To edit the properties of a base table:

1.   Select the base table in the Base Tables tab and select the menu option PropertiesÆBase Table. You can also double-click the base table name.

The Edit Base Table Properties window is displayed, as shown below.

 

   Figure 209: Edit Base Table Properties Window

2.   Edit the name of the table.

3.   Add a description if required.

4.   Click the OK button to apply the changes and close the window.

 

   Note:


    Changing the name of the base table does not change the name of the underlying database. This alternative name only appears in the Base Table tab.


Once the base tables have been imported, you can start to create folders.

Removing a Base Table

To remove a base table select the base table and click the Remove button at the bottom of the Base Table tab.

Creating Populated Folders from a Base Table

To create a new folder containing items from a base table, select a base table and click the << Add button. A new folder is created with the same name as the base table. This name can be changed later if required. All of the columns in the base table appear as items in the new folder, as shown below.

 

   Figure 210: Importing a Base Table to a Folder

You can remove an unwanted item from the folder by selecting the item and clicking the Remove button. Any item that has been removed can be created again. Select the column below the original base table and click << Add.

If you want to create an item from a column in another base table you must use the New Item window, as described in Creating Empty Folders on page 334.

You can create more than one folder from the same base table. When you click the << Add button Netcool Reporter checks for a folder of the same name. If the folder name already exists the New Folder window appears, as shown below.

 

   Figure 211: New Folder Window

Enter a new name for the folder in the Folder Name field and click OK. The table name is added to the Description field.

You can change the folder name at any time by double-clicking the folder name or selecting the folder and using the menu option PropertiesÆUniverse Object. The New Folder window appears, as described previously.

Creating Empty Folders

An empty folder has the same properties as the folder created from a base table, however, it is not possible to add items using the << Add button in the Base Tables tab.

To create an empty folder:

1.   Select the universe in the Folders and Items tab.

2.   Select the menu option CreateÆCreate Folder or click the Create Universe Folder icon. The New Folder window is displayed, as shown below.

 

   Figure 212: New Folder Window

3.   Enter the name of the new folder. You cannot create duplicate folder names in a universe.

4.   Enter a description for the folder if required.

5.   Click the OK button to create the folder and close the window.

Editing Folder Properties

To change the properties of a folder:

1.   Select the folder in the Folders and Items tab.

2.   Select the menu option PropertiesÆUniverse Object. The Edit Folder Properties window is displayed. This window is identical to the New Folder window, as described in the previous section.

3.   Change the folder name and description as required and click OK to apply the changes.

Removing a Folder

To remove a folder, select the folder in the Folders and Items tab and click the Remove button.

Adding Items

You can create two types of item in a folder. A simple item takes its data directly from a column in a base table. A derived item produces results based on manipulation of the data in one or more columns.

To create an item:

1.   Select a folder in the Folders and Items tab.

2.   Select the menu option CreateÆCreate Item or click the Create Universe Item icon. The New Item window is displayed, as shown below.

 

   Figure 213: New Item Window

3.   Enter the name of the new item in the Item Name field.

4.   Select the correct data type for the new item from the Data Type drop-down list. Possible values are Number, Date and Character String.

5.   Enter a description, if required, in the Description field.

6.   To create a simple item expand the tables in the Tables and Columns list until you find the columns you would like to use in the item. Double-click the column name to add the column to the Expression field. Click the OK button to create the new item.

The data type for the column must match the type set in the Data Type drop-down list.

7.   To create a derived item build an SQL expression in the Expression field. You can click the +, -, * and / icons to add these arithmetic operators to the expression. You can double-click a column name to add this name to the expression. You can double-click a function to add the function to the expression. Click the OK button to create the new item.

The value returned must match the type set in the Data Type drop-down list.

Editing Item Properties

To edit an item:

1.   Select the item in the Folders and Items tab.

2.   Select the menu option PropertiesÆUniverse Object. The Edit Item Properties window is displayed, as shown below.

 

   Figure 214: Edit Item Properties Window

3.   Edit the item name and the description as required. You cannot change the values in the Database Column and Expression fields.

4.   Click OK to apply the changes.

Removing Items

To remove an item, select the item in the Folders and Items tab and click the Remove button.