HOW TO BUILD DASHBOARDS INFO CAPTOR III

Create Dashboard and Table portlet

 

Once connected, it will show you a list of action items to pick from

 

We will click on “New Blank Dashboard”

In the Dashboard Name, we type in “Order Management Analytics”

 

Click OK.

It will present you with a table browser showing all the available worksheets as tables

 

 

Expand the node to see all the worksheets.

In this example file, we just have one worksheet named “order_data”. Note how, it attaches a $ sign at the end, which indicates this is an Excel Worksheet. So make sure you do not have any dollar sign when naming the Excel worksheet and no other special characters and no white or blank characters. Replace blank characters with “_” underscore character

Double Click on the “order_data$” node