Dashboard Applications
The visualizations so far can be interactive, but they still do not do anything except show visualizations. The final object the Dashboard/Application can also perform actions like writ data to a file or database and send emails with PDF or Excel attachments.
Dashboard applications take a bit longer to make, like about an hour. Here are some examples.
A customer requested an aid for SQL programmers, so I made this dashboard:
It tells you in the upper right it tells the DB2 Subsystem it is connected to . It gives a list of SCHEMAS and when a schema is picked it gives a list of tables and views for that schema. When a table or view is selected it lists the columns and data types.
![](https://dw1.s81c.com/IMWUC/MessageImages/22ca5c2185ad4e46991f53e8b7dfd05c.jpg)
Here I enter a SCHEMA name in the filter and click the button next to it.
![](https://dw1.s81c.com/IMWUC/MessageImages/5af16df7d0674fbfa570a7bd432cb7a6.jpg)
Now I have the SCHEMA located
![](https://dw1.s81c.com/IMWUC/MessageImages/2ac6a9104999454faf48efacfd074cf1.jpg)
When I click on the located schema it gives me a list of Tables and Views owned by that Schema
When I click on a table it gives me a list of columns and data types.
If I click the check box next to the table, it gives me auxiliary information from the DB2 Catalog in a pop-up box. Now the SQL author knows the primary key, the Indexes, the dependent tables, and the foreign keys. Any of these may help in creating an SQL query.
![](https://dw1.s81c.com/IMWUC/MessageImages/0582ab1bf264483dacd394d6fa824803.png)
If instead I choose a view, then I again get the columns and data types but now the auxiliary checkbox gives me the View definition, so I know the underlying tables.
.![](https://dw1.s81c.com/IMWUC/MessageImages/601b114b5c9d4cca858bcf50a7729298.jpg)
This is a technically oriented dashboard.
The next two are business oriented. These were asked for by a bank. The data is completely fictitious.
This Dashboard Application starts with a couple of charts showing total Transactions at ATMS and the total number of ATMs
![](https://dw1.s81c.com/IMWUC/MessageImages/44974278e74040c29c0f5ad142948537.jpg)
When an end date is chosen from the dropdown box a table appears with the previous 13 months of KPI’s
![](https://dw1.s81c.com/IMWUC/MessageImages/32e1b441e6bf46d3a31ab65f2c990419.jpg)
In a second banking dashboard, we have a chart of the KPIs
![](https://dw1.s81c.com/IMWUC/MessageImages/7be2e128b8cd475f9f37a1267916e2fb.png)
Again, I choose an end date and in addition to a table I get the following chart:
Again, the graphic in the upper right corner will download or email the indicated collateral.
Each of these, took about one hour to make. I have prepared a tutorial document that other customers have found useful to get a quick start on building dashboards. If you would like a copy please email me at
sullivan@rocketsoftware.com
#Db2Toolsforz/OS#Db2QMF#QMF