Adding a Tile Widget
Tile widgets are used to contain several metrics in one widget. Up to six metrics can be defined for each one-by-one widget. To include more than six metrics, increase the size of the widget. The color for each metric is defined by threshold values or by the designer.
To add a tile widget, do the following:
- Drag the tile widget to the Build Dashboard area.
- Click
(gear) on the widget to edit the settings. - Enter a title for the tile widget.
- (Optional) Set the colors for the metrics as follows:
- ClickEdit.
- Set the color, and measure.
- (Optional) ClickAddto add another color and measure.
- ClickSaveto save the colors.
Theas [Color]element in the query can also be used to set the color of the metric value. The color is entered as a hexadecimal, and enclosed in single quotation marks. If this option is used to set the colors, then enable Is Color after generating the columns. - 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. The query should include the following elements:
- as [Label]to set the label for the metric.
- as [Value]to set the value of the metric.
- 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.
- ClickSaveto save the widget, and then clickSaveto save the dashboard.