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:
  1. Drag the tile widget to the Build Dashboard area.
  2. Click (gear) on the widget to edit the settings.
  3. Enter a title for the tile widget.
  4. (Optional) Set the colors for the metrics as follows:
    1. Click
      Edit
      .
    2. Set the color, and measure.
    3. (Optional) Click
      Add
      to add another color and measure.
    4. Click
      Save
      to save the colors.
    The
    as [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.
  5. Select the type of query. The options are MDX/Cube Query or SQL/Database Query.
  6. Select the connection.
  7. Enter the server name. This is the server that has the data.
  8. Select the database.
  9. (MDX query only) Select the cube to query.
  10. (Optional) Click
    Cache Query
    to cache the query results.
  11. 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.
  12. Click
    Generate Columns
    under the Columns tab to generate the columns for the query.
  13. (Optional) Edit the column elements listed in the Column Source area by clicking an element.
  14. Click
    Save
    to save the widget, and then click
    Save
    to save the dashboard.