Use service catalog variables in a report
In reports on service catalog data, stack and group by variables, use variables as columns in list reports, and as columns and rows in multilevel pivot tables.
Before you begin
Role required: itil, report_user, report_group, report_global, report_admin, or admin. To create a meaningful report, you must have the right to access the data you want to report on.
Users with the report_admin role can report on service catalog variables. Add the report_admin role to the ACLs for the Options [sc_item_option], Variable Ownership [sc_item_option_mtom], and Variables [item_option_new] tables.
Note:
- The report you want to use the variable for must be based on the Requested Items table [sc_req_item] or the 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. To compare the CLOB columns of a smaller size, use the to_char() function. For a larger size CLOB, you must get a substring for comparison using the dbms_lob.substr functions.
About this task
For primary Group by and Stack by, these steps are intuitive.
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.
Use a variable as an extra Group by, as a column in a list report, or as a column or row in a multilevel pivot table.
Procedure
Navigate to All > Reports > View / Create and open the report to add the variable to.
Do one of the following.
| Add as a column in a list report | On the Configure tab, move Variables+ to the Selected column. |
| Add as an extra Group by | On the Configure tab, click Additional group by, then move Variables+ at the bottom of the Selected of the Additional group by list. |
| Add as a column or row in a multilevel pivot table | Click Select columns or Select rows, then select Variables+ at the bottom of the list.Note:
|
- Click the structure icon (
Report structure icon\) and then the plus sign that appears.
A list of service catalog items appears.
Select a catalog item with the variable.
The variables for that item appear in the Available list.
Move the variable that you want to use to the Selected column.
Save the report.
Parent Topic:Report on service catalog variables