To open Table window, select ID or name of component in the Dashboard Components and set Table in Type field.

1. Paste an SQL query in the SQL box. It cannot exceed 8000 characters.

Right-click and select Edit in SQL Editor command from the menu.

2. To prefetch data instead of running SQL query when opening dashboard, check Prefetch Data.

   After selecting this option, click Apply SQL. You have to click it also whenever you change an SQL query.

 3.  Click Apply SQL.

  4.  Check Use "Total" for dashboard component.

Having checked Use "Total", the chart displays unfiltered values.

  5.  Set filter in order to filter data by set criteria.

Take care to set criteria wisely. Typically, the filter is equivalent to the WHERE statement in SQL query.

You can set filter only in ME and MF editions.

   6.     Enter name of table.

   7.     Enter any description for component in the Descr. field.

  8.     To open register by double-clicking a cell, right-click and check register for individual cell..

Clicking Apply SQL (see step 3), you have to set registers once more.

     9.    Click to confirm it.

  

 

 

 

 

ZEUS topics in the PANTHEON 5.5 Guide:

• Dashboard Components - Table
• ZEUS Dashboard

Related topics:

• Create a Component

---