I am very new to this tool, but it was provided with Crystal Reports so I assume its part of the same package.
When working with Crystal, we create tables or stored procedures in our SQL MS, and bolt Crystal onto these. That way of course, Crystal is always fed the latest data.
For this dashboard tool, it looks like it wants to run from a spreadsheet. Of course, we could extract data from our warehouse into a spreadsheet, and import this into the dashboard tool, but that becomes a task each time reports need updating.
Is it possible to bolt the dashboard tool onto our warehouse via an ODBC connection like we do with Crystal?