Use service catalog variables in a report

For reports on service catalog data, you can stack and group data by variables, use variables as columns in line reports, and use variables as columns and rows in multilevel pivot tables.

Before you begin

Role required: itil, report_admin, report_global for global reports, or report_group for group reports
Note: The report in which you want to use the variable must report on the Requested Items table [sc_req_item] or any table that can dot walk to this table. Using other types of variables causes an error when generating the report.

About this task

For primary Group by and Stack by these steps are intuitive.
Figure 1. Variable use in Group by and Stack by fields.
Example of service catalog variable use in Group by and Stack by fields.
Note: List, Box, Trendbox, and Pivot reports cannot use service catalog variables as a primary or secondary Group by. Single Score, Calendar, Control, and Map reports do not support Group by on any fields. List reports can use service catalog variables as columns.
Follow these steps below to use a variable as an additional Group by, as a column in a list report, or as a column or row in a multilevel pivot table.

Procedure

  1. Navigate to Reports > View / Create and open the report to add the variable to.
  2. Do one of the following:
    OptionDescription
    Add as a column in a list report Select Variables+ at the bottom of the Available list.
    Add as an additional Group by Click the plus sign (plus sign icon for additional group by) next to Group by, then select Variables+ at the bottom of the Available list that appears.
    As as a column or row in a multilevel pivot table Click Select Groups, then select Variables+ at the bottom of the Available list that appears.
  3. Click the plus sign that appears.
    A list of service catalog items appears.
  4. Select a catalog item where the variable has been added.
    The variables for that item appear in the Available list.
  5. Move the variable that you want to use to the Selected column.
  6. Save the report.