Create a Simple (Undimensioned) Report

Creating Reports has been greatly simplified by using the new Dataset Reporting feature - see Dataset Reports Overview (New in 5.3)

1. Access New > Report

NOTE:  The format of the Report Editor is slightly different in earlier Versions.

  1. Input a meaningful Name
  2. Select Standard Report
  3. Choose the Reported interval
  4. Optionally, identify a Category
  5. [5.2.1] Optionally, specify the Folder in which you want to put this Report

NOTE: the Folder field is currently only visible on the new element pop-up. All changes to Folder in which this element appears have to be made from the Folder editor.

Next: Define Report

The System will automatically open the Data tab

2. Define Data collection and display

2.1. Specify how to collect your data

  1. Select the Data Source to be used to source your data
  2. Choose the Trigger that will collect data for your report (Data collection schedule)
  3. Identify external Folder from which your data will be fetched
  4. Add external Filters if required
  5. Provide a Plugin command for collecting data

Click [Show data]

2.2. Review result set displayed below

  1. Click [Show Data Preview] to open a preview of the selected data.
  2. Specify whether or not the Report should be saved as a Snapshot (see How to create a Snapshot Report
  3. Set the date-time value to be used as the effective date value for the report. This value is only applicable to Reports with saved historical instances. New Time Command values may be added from the drop-down list as needed.
  4. If you want the complete result set shown in the report (without pivoting the data), set Save as system table to 'Yes'.
  5. If a charting interval drop-down is to be included in your report ('Last 6 Months', 'Last Year', etc...), identify the date column that is to be used to drive this control in Include date filter based on from the available choices in the drop-down.
  6. Once you confirm that the Sample result set contains the expected data, Save the Report.

2.3. Modify Data Column Display Attributes

Upon successful Save, a Report Columns section will appear in the editor below the Sample result set.  You can click into the Report Columns to change their following defaulted attributes:

  1. Display Name
  2. Determine whether a numeric column is to be shown with a Currency mask
  3. Define a specific Display Format Mask for date and numeric columns
  4. Add a Description if needed
  5. Indicate if Results are to be displayed
  6. Check if Totals are desired for numeric fields
  7. Use arrows to alter position of data
3. Define Content settings

3.1. Include Report Tables and Charts

  1. If you want to pivot your data for display or charting, click the [+ Pivot] button and follow the instructions that apply.
  2. To chart the data that you have collected, click the [+ Chart] button.
  3. To include external content in Report, use [+ Embed Content] button.
  4. To edit or delete Pivot tables, Charts and Embedded Content, choose the corresponding option from the dropdown.

See the following Articles for details:

3.2. Adjust Visualization and Display

External Visualization

  1. Specify the name of the external Report that will be used for Visualization.
  2. Choose which Report columns are to be mapped to external Filters. At least one Report column and one Filter must be selected to filter the Visualization.
  3. Select "full image" or "links only" display for you visualization.
  4. Indicate if your Images should link to This Report or External Visualization.
    1. If "This Report" is chosen, emails for Digests and other notifications containing this report will, when clicked, direct the user to this Report's View
    2. If "External Visualization" is selected, clicking the image in an email takes the user to the BI tool and opens the image in that location; e.g., Tableau
  5. [Optional] Check if you want only one Visualization to be displayed for all Filter combinations.

Tile and Preview Display

  1. Select the image you want to use as Thumbnail and for Preview
  2. Optionally, choose an alternative Element to be displayed as Tile on Homepage

For more information on External Visualization, refer to:

  1. Add Tableau Visualization to a regular Report (Version 5.0)
  2. Add External Visualization to a Report (Version 4.2)
3.2.1. Map Total Values

By clicking the Edit (Gear) icon, you can specify how you want the system to handle Total Values.

If the column in your Report contains a Total value, you can map it to an equivalent external Filter Value.

4. Review and modify Report Distribution settings

Alter default (if needed) and specify settings for:

  1. Content Distribution
  2. [Display only] Report Alerts on the Report
    • in order to receive Alerts on a Report, you need to create and link them to the Report via New > Alert Rule > Report Alert
    • to be able to set Alerts, make sure your Report is snapshotted: i.e., the Report is set to keep history. Read more on How to create a Snapshot Report
  3. [Optional] Alert Rules for Sending this Report
    • if required, click [+Associate Alert Rules] > Select Metric to Associate > click [Associate] and apply Metric Alert Rules
6. Modify Advanced tab settings to required

[5.2.1] Display options now allow Users to specify map column-level overrides for blank values. This new Setting is used to to define how blank values in the Stats model are displayed in a report.

  1. Numeric NULL values can be displayed as:
    • blank
    • zero
  2. Text Blank values:
    • can be displayed as word or phrase of your choice
    • default to empty: i.e., nothing is displayed whenever text values are unavailable
7. Publish Your Report

Once you have added the desired Pivot Table(s) and Chart(s) to your report:

  1. Click the Enable and publish button
  2. If you want your report to be visible as a Tile on the Homepage, check the On Homepage check-box