Adding a Table Widget
To add a table widget, do the following:
- Drag the table widget to the Build Dashboard area.
- Click
(gear) on the widget to edit the settings. - Enter a title for the table. This title is displayed on the dashboard.
- (Optional) SelectCan Exportto allow the table to be exported to a Microsoft Excel spreadsheet. The dashboard option Allow Export must also be selected.
- (Optional) SelectCan Pageto allow pagination of long tables.Best practice is to select this option.
- (Optional) SelectShow Record Countto enable showing the record count with the table. The record count appears below the table.
- (Can Page only) Enter the number of rows to display on each page in the Page Size field.
- Select the type of query. The options are MDX/Cube Query or SQL/Database Query.
- Select the connection.
- Enter the server name. This is the server that has the data.
- Select the database.
- (MDX query only) Select the cube to query.
- (Optional) ClickCache Queryto cache the query results.
- Define the query as follows:Modifying an MDX query using the Query Editor invalidates and disables the Query Designer for the widget.
- For an MDX query, select the fields by dragging the field to the Selected Fields area, and entering additional query specifications in the MDX Segments area. The Query Editor can also be used to enter an MDX query.
- For a SQL query, enter a query in the Query Editor area.
- ClickGenerate Columnsunder the Columns tab to generate the columns for the query.
- (Optional) Edit the column elements listed in the Column Source area by clicking an element, and selectingEdit. After you have made your changes, clickUpdateto save.You can customize elements, such as the following:
- Change the text that appears for the Measure Label
- Set word wrap for displayed text
- Define which columns are exportable to Microsoft Excel
- Set the number format
- Set the Group By option
Only one column can be selected as the Group By column.For Gantt charts, ensure that the start and end date columns are identified in the Column Collection section. - Set entity actions for the chart as follows. Entity actions allow the user to act on an entry while viewing a dashboard.
- ClickEntity Actionstab.
- Double-click an entity action name.
- Double-click the phrasePlease select a column nameto view the list of available columns from the query.
- Select the column.
- Repeat the procedure to have additional entity actions.
- ClickSaveto save the widget, and then clickSaveto save the dashboard.