For reports on service catalog data, you can stack and group data by variables, use
variables as columns in list reports, and use variables as columns and rows in multilevel
pivot tables.
Role required: itil, report_user, report_admin, report_global for global reports, or
report_group for group reports
Note:
- The report for which you want to use the variable must report on the
Requested Items table [sc_req_item] or Catalog Task table [sc_task]. Using
other types of variables causes an error when generating the report.
- The Oracle Database CLOB field does not have the functionality to retrieve
the variables data in reports. For a column string field of less than 4000
bytes, you can change the column type to varchar2; or to compare the CLOB
columns of a smaller size, use the to_char() function. For a larger size
CLOB, you need to get a substring for comparison using dbms_lob.substr
functions.
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.
-
Navigate to and open the report to add the variable to.
-
Do one of the following:
| Option | Description |
|---|
| Add as a column in a list report |
On the Configure tab, select
Variables+ at the bottom of the
Available slushbucket. |
| Add as an additional Group by |
On the Configure tab, click
Additional group by, then select
Variables+ at the bottom of the
Available column in the Additional
group by slushbucket. |
| As as a column or row in a multilevel pivot table |
Click Select columns or Select
rows, then select Variables+ at
the bottom of the slushbucket that appears. |
-
Click the structure icon (
) the plus sign that appears.
A list of service catalog items appears.
-
Select a catalog item where the variable has been added.
The variables for that item appear in the
Available slushbucket.
-
Move the variable that you want to use to the Selected
column.
-
Save the report.
