In this section, we will now refresh the initial CAUSER schema from the IBM Case Manager Case Analyzer CASTORE1 Linux Db2 database Events server, ecmukdemo6, to include the two custom Views we created earlier (CAUSER.DMDaysIn_Case and CAUSER.DMAgeing_Case).

 

Figure 5-54The CAUSER schema of the AUDIT_DB_CASTORE1 connection is refreshed

We right-click the selected CAUSER schema (showing the initial 61 tables transferred), as shown in Figure 5-54, to reload the metadata using the highlighted Load metadata command menu item.

After the reload, it can be seen that the count of tables is now increased by two to 63, reflecting the discovery of the two additional views we created.

Figure 5-55The two new views are now included in the CASTORE datasource

We can now create a Data module where we can include the new Views in the selected CAUSER schema tables and save this new Data module for analysis.

Figure 5-56The Cognos Content folder option is selected

The New + drop-down menu list command (highlighted in Figure 5-57) is selected.

Figure 5-57The New + command button is selected

We can then select the Data module menu item from the drop-down menu list.

Figure 5-58The Data module menu item is selected from the New + drop-down list

The Select sources pop-up window is shown to allow us to select the CAUSER source we just updated from the AUDIT_DB_CASTORE1 data server connection.

Figure 5-59The updated CAUSER Datasource is selected for analysis

Figure 5-60The OK command button is used to confirm the CAUSER selection we made

The Select tables option is now selected to select the required tables for the analysis.

Figure 5-61The Select tables option is selected for manual table selection

The alternative access to creating a Data module is shown in the following screens.

Figure 5-62The + New option allows the Data module menu option to be selected

We can then see the same Select sources pop-up window we used earlier.

Figure 5-63The updated CAUSER Datasource is available for selection

On opening the CAUSER datasource, we can select from the required tables as before with the previous example.

Figure 5-64The CAUSER.D_Dmcasetype Dimension table is selected

The Fact table CAUSER.F_Dmcaseload is selected next, as shown in Figure 5-65.

Figure 5-65The CAUSER.F_Dmcaseload Fact table is selected

On scrolling further down the list of tables, we can now see we have access to the two custom views we created earlier, CAUSER.DmdaysIn_Case and CAUSER.Dmageing_Case.

 

Figure 5-66The custom view, CAUSER.Dmageing_Case, is selected

On selecting the Refresh command button, the expected rows for the View are returned in the data pane as shown in Figure 5-66.

Figure 5-67The custom view, CAUSER.Dmdaysin_Case, is selected