Post date: Apr 29, 2011 12:47:24 PM
The qbo.Dashboard control is designed to render dashboards (tables and charts) without excessive demand on the database.
The control assumes the following:
it will be working with SQL CUBE data,
this data can and should be cached for a reasonable amount of time, so that it does not call the database for every page draw,
charts (typically pie charts) are rendered with the Google Visualization API
multiple charts or tables may be rendered from a single SQL CUBE
Designing the SQL Cube
SQL CUBEs are SQL statement that include both a GROUP BY clause and a WITH CUBE clause. Columns that are part of the GROUP BY clause are referred to as 'dimensions', and aggregates functions are referred to as 'facts'. For example, the Loan table could feed a dashboard along these lines: