Figure 5-26The AUDIT_DB_CASTORE1 datasource connection is selected

On clicking the AUDIT_DB_CASTORE1 datasource connection link, we can select the Schemas tab shown in Figure 5-27, which allows us to select a CAUSER Schema to download from the Linux server CASTORE1 database.

Figure 5-27The CAUSER Schema is clicked to use for the table data load for analysis

Figure 5-28The Permissions tab can be used to provide the required security levels

The right-mouse click on the CAUSER schema allows the selection of the Load metadata menu, highlighted in Figure 5-29.

Figure 5-29The Load metadata menu item is selected from the CAUSER Schema entry

The percentage progress of the “table load” is shown as highlighted in Figure 5-30.

Figure 5-30The status of the table load for the CAUSER Schema tables is shown

Figure 5-31The number of tables for the Schema and the number loaded are shown

The loaded Schema is now saved as CaseAgeing under a new folder, CaseAnalytics, in the My content tab.

Figure 5-32The File icon is clicked and the Save as menu option selected

Figure 5-33The Present data ➤ Dashboard options are selected

After selecting the Present data ➤ Dashboard panels on the main page of the Cognos web application, the Create a dashboard page is loaded as shown in Figure 5-34.

We can now select a Framework layout as highlighted.

Figure 5-34The Framework layout for the Dashboard is selected as highlighted

 

Figure 5-35The Prepare data panel is used to create a Datasource for the Dashboard

We can select a Datasource from the Prepare data panel shown in Figure 5-35 to be used with the Dashboard.

Figure 5-36The AUDIT_DB_CASTORE1 database datasource is selected

Figure 5-37The Add a source + icon is selected as highlighted

A new source can be selected from the saved CAUSER schema of the AUDIT_DB_CASTORE server connection as shown in Figure 5-38.

Figure 5-38The CAUSER schema we loaded earlier is selected

The OK command button is then clicked to confirm the use of the CAUSER schema we selected in Figure 5-38.

Figure 5-39The OK button is clicked to use the CAUSER schema we selected

Figure 5-40The Discover related tables option is chosen first to use the Cognos system