Dasbhoard Data Prefetching
Dashboard administration
Dashboards enable you to define some settings for their use and mostly require you to update dashboards to review latest data. Most of the administration is done in Administration Panel or with parameters.
Prefetching data
It is required to prefetch data for dashboard components whose SQL query takes longer to execute. Instead of the SQL query being executed every time the dashboard is opened, on-demand data prefetching is performed.
Prefetching stores data in dedicated tables.
There are two options available for data prefetching:
- Click Prefetch Data in the Administration Panel, or
- Run PANTHEON with the parameter /DSH.
To prefetch data open Administration Panel | ZEUS | Dashboard | Prefetch Data. In opened panel you will see a list of all components in the database where all components are selected by default. If you want to prefetch data for only selected components just deselect the ones that you do not wish to update. Once components are selected click button Prefetch data. If data prefetching is succesful, message Data prefetching completed successfully will appear.
Another option to prepare dashboards is by using parameters in shortcut. You have multiple options to prefetch data:
Update data in default database with parameter /DHS
Example: "c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH
Update data in all databases on the server.
Example: "c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH=ALL
Update only ceratin databases (specify databases in brackets and separat them using semi-colons).
Example: "c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH=ALL(DB1;DB2;DB3)
Update components in multiple databases with different users (list the databases as above, but specify the user name and password separated by colons after each database).
Example: "c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH=ALL(DB1:user1:pass1;DB2:user2;DB3)
Here, user1/pass1 is used to log on to the database DB1, user2 logs on to DB2 without a password, and for DB3 the user name/password specified with the /L parameter is used.
To b e able to efficiently use parameters you also need to define default user. For more information see Command Line Parameters.
General settings
This panel enables you to define default dashboard for individual user and to receive email notification when components are refreshed with parameter /DSH.
