Next, we can add tables from the CAUSER schema by either manually selecting the tables (using the left icon, Select tables option) or by allowing the Cognos system to process the table rows (using the right icon, Discover related tables option) which then automatically displays the most significant words to be used as shown in Figure 5-41.
Figure 5-41The Cognos system displays the status word which we have selected
We can click the word we wish to use as the keyword using the mouse button (I selected status in Figure 5-41). Then click the Next command button on the bottom right of the screen.
Figure 5-42The automatically selected CAUSER schema table is displayed
The system selected the CAUSER.F_Ceevents Fact table from the CASTORE1 OLAP database. We can now add additional tables as required using the Add more tables menu option as shown in Figure 5-43.
Figure 5-43The Add more tables option is selected
Figure 5-44The scrollable list of CASTORE tables for the CAUSER schema is shown
Figure 5-45The required Dimension table, CAUSER.D_Dmcase, is selected
On first selecting a table, as shown in Figure 5-46, the Refresh command button in the central panel is clicked in order to display the table row data.
Figure 5-46The CAUSER.D_Dmcasetype table data is displayed using Refresh
The rows loaded from the Linux CASTORE Events database for the IBM Case Manager are then displayed as shown in Figure 5-47.
Figure 5-47The CAUSER.D_Dmcasetype Dimension table rows are displayed
The CAUSER.D_Dmtasktype Dimension table is also selected as shown in Figure 5-48.
Figure 5-48The CAUSER.D_Dmtasktype Dimension table rows are displayed
Figure 5-49The validation for the selected tables shows no issues
The final selection of tables is highlighted in the left panel in Figure 5-50, and the Data module we have created, with these tables selected, can now be saved as CaseLoad in the My content tab root location. You can see that we have also created a Folder called CaseAnalytics under the My content root.
Figure 5-50The selected tables are saved as the CaseLoad Data module
After the Save command button is clicked, the Data module, CaseLoad, is now shown and is ready to be used in charts in a new Cognos Dashboard.
Figure 5-51The CaseLoad Data module is displayed under the My content root
In the New dashboard Cognos frame, we can load the Datasource module, CaseLoad, highlighted in Figure 5-51, and drag and drop the required measure fields for analysis and display in the Cognos frame.
Figure 5-52The Incoming case count for each Case Type from Case Manager is displayed
Figure 5-53The Add new tab + icon can now be selected to add additional graphs
Leave a Reply