Figure 5-80The Add a source + icon is clicked to select our new datasource

We have to navigate to the CaseAnalytics subfolder we created earlier as this is where we saved the Data module with our custom views.

Figure 5-81The CaseAnalytics folder is double-clicked to display the saved Data module

Figure 5-82The Add command is used to load the saved CaseAgeing Data module

Now, the loaded CaseAgeing Data module shows the two tables and two custom views we are going to use for a Graph Visualization.

 

Figure 5-83The CaseAgeing Data module shows the four “Tables” we can use

We now click the Visualizations icon (highlighted in Figure 5-83) which opens a large scrollable list of Cognos Analytics graph types.

Figure 5-84The graph types are displayed, from which we can select a type

Figure 5-85The Stacked bar graph type is selected on scrolling down

Eventually, we selected the Stacked bar graph type, which displays a template for the graph which we can fill by using drag and drop to select the appropriate fields from our table list. Each table has an opener (filled > icon) which opens a sublist of the table’s fields.

Figure 5-86The Stacked bar graph type is selected for our data

We drag and drop the Incoming Case Events and the Casetypename fields for the y axis with the custom Daysin field values used for the count on the x axis.

Figure 5-87The graph created from our custom Dmdaysin_Case view

The final graph displayed is as follows.

Figure 5-88The Daysin count by Incoming and Casetypename graph

Now we can select a new tab on the Dashboard and create a second (similar) graph using the Dmageing_Case view.

Figure 5-89The Incoming by Daysin (using time ranges) colored by Casetypename graph

Figure 5-90The Daysin (week ranges) by Incoming (count) and Casetypename graph

The IBM Cognos Analytics main page shows the items we have open for editing.

Figure 5-91The list of pages we have open which we used for the preceding custom views

Figure 5-92The ? icon shows the What’s new for Cognos Analytics version 11.2

Figure 5-93The Dashboards can be saved using the highlighted Save as menu item

We can save the Dashboard graph as “Audit and Insurance Solutions Case Ageing Dashboard” to load later under the CaseAnalytics subfolder we created.

Figure 5-94The Dashboard graph is saved as “Audit and Insurance Solutions Case Ageing Dashboard”

Figure 5-95The saved Dashboard is selectable from the highlighted drop-down

Some More Complex Examples

To illustrate how the preceding example can be extended, the following screenshots show the additional tables added with new relationships and the resulting graphs.

 

Figure 5-96The Relationship diagram created from an extended table selection

Figure 5-97The Relationship diagram zoomed in from the Figure 5-96 screenshot

The resulting graph from the drag and drop of fields as shown in Figure 5-98:

 

Figure 5-98The Incoming Daysin and Casetypename by Tasktypename graph

Figure 5-99The zoomed in graph from Figure 5-98