Adding a Chart Widget

To add a chart widget, do the following:
  1. Drag the chart widget to the Build Dashboard area.
  2. Click (gear) on the widget to edit the settings.
  3. Enter a title for the widget. This title is displayed on the dashboard.
  4. (Optional) Enter the category label for the widget.
  5. (Optional) Enter the measure or value label.
  6. (Optional) Select
    Logarithmic Scale
    to use a logarithmic scale.
  7. (Optional) Select the
    Data Labels
    check box to display the labels on the chart segments, such as pie slices on a pie chart.
  8. (Optional, pie chart only) Select the
    Value in Label
    check box to display the values associated with the label.
  9. (Optional, pie chart only) Select
    Enable Slice Expansion
    to have a selected pie slice separate from the rest of the pie chart when slice is selected by a user.
  10. (Optional, pie chart only) Set the radius for the pie chart in the Pie Radius field. Measurement is in pixels.
  11. (Bar, area, and column chart only) Select the stack type. Options are Stack to stack the values, 100% to stack the values as percentages of 100%, 3D for three-dimension stack, and None to not stack the values.
  12. Select the angle for the x-axis label using the Label Angle slider. Negative slider values set the angle to the right, and positive slider values set the angle to the left. The Label Angle slider is available for column, bar, bubble, scatter, and area charts.
  13. Select the line type. Options are Smoothed Line for smooth line connections between data points, and Line for straight-line connectors between data points.
  14. Select
    Connect Points
    to connect data points on the chart.
  15. (Optional) Select the type of drill-through chart or dashboard. The drill-down dashboard must be configured to be listed as an option. Refer to Including Click-through Capability Using the Dashboard Wizard for information about click-through capability.
  16. Select the type of legend from the Legend Type menu.
  17. Enter the marker size in the Marker field. Measurement is in pixels.
  18. Enter the label width in the Label Width field. Measurement is in pixels.
  19. Enter the value width in the Value Width field. Measurement is in pixels.
  20. (Optional) Set the minimum and maximum values for the axis in the Minimum and Maximum fields.
  21. (Optional) Add or select a reference axis. Using a reference axis enables charts on the same dashboard to use the same measure on their axes. It does not affect categories.
  22. (Optional) Set the colors for the chart and labels. Refer to Setting Custom Colors for information about custom colors.
  23. Select the type of query. The options are MDX/Cube Query or SQL/Database Query.
  24. Select the connection.
  25. Enter the server name. This is the server that has the data.
  26. Select the database.
  27. (MDX query only) Select the cube to query.
  28. (Optional) Click
    Cache Query
    to cache the query results.
  29. 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.
  30. Click
    Generate Columns
    under the Columns tab to generate the columns for the query.
  31. (Optional) Edit the column elements listed in the Column Source area by clicking an element, and selecting
    Edit
    . After you have made your changes, click
    Update
    to 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.
  32. Click
    Save
    to save the widget settings.
  33. Click
    Save
    to save the dashboard.

Example: Query for a Gantt Chart

Gantt charts are created using MDX or SQL queries. The queries must include start and end date columns. Custom colors are set for each entry in the chart by using hexadecimal values. The following SQL syntax shows the format for setting start and end dates, and custom colors:
select 'Introductions' [Category] , dateadd(hh, 8, @date) [Start] , dateadd(hh, 9, @date) [End] , '#ff0000' [Color] union all select 'Findings' [Category] , dateadd(hh, 9, @date) [Start] , dateadd(hh, 10, @date) [End] , '#0000ff' [Color] union all
After entering the query and clicking Generate Columns, the Start, End, and Color columns are set in the Column Collection section.
The following is an example of the Gantt chart defined in the preceding syntax: