PlanetJ Corporation has incorporated a WOW Wizard that works with the add-on WOWFusion Charts to create the operations necessary to display data in a dashboard. The operations are automatically generated into a selected application. All that is needed is for SQL and/or chart type to be changed to customize the dashboard to suit the business need. Steps are as follows.
Log into WOW Builder and create an application (Test Dashboard in sample shown here):
Insert the application and navigate to the Wizards page:
Execute either Dashboard 2x2 or 3 x 3 (depending on how many charts you want to display)
The WOW Builder will automatically create an Execution Group operation which allows multiple operations to run simultaneously grouped together beneath one parent operation. The Fusion Dashboard wizard will also create the child "SQL operations" as well.
You should get a message back that the dashboard operations have been inserted into your application:
Now, within your operations screen of your application, you will see the Execution operation and SQL operations already present:
The Execution Operation automatically sets the columns within the properties and inserts the unique usage IDs of the SQL chart operations and will look like this:
The WOW Wizard also automatically sets the Fusion jsp as shown in the advanced section of the Execution Operation here:
When you run your application, you will get generic Fusion charts that have been set as a demonstration.
This shows the default layout of the dashboard. Access each of the chart operations from the operation screen of your application to make changes to the:
1) Title of the chart
2) SQL to return your specific data
3) Changes to the charts (different chart types)
Edit EACH operation as shown here:
In this operation, I have changed the operation code SQL to bring back employee salary by job, changed the title, and chart type:
On running application, this is the look of my first chart:
Repeat adjusting the operations until you have data that you require for your dashboard:
The look and feel of the charts can be somewhat controlled by the properties as documented here.
Also, refer to Dashboard section or Dashboard Styles section of this guide.