Reporting : variables are not visible while creating report

[pramn]

Hi Team , 

what could be the reason variables are not visible while creating report?

Thanks for your help 

[Dr Atul G- LNG]

https://www.servicenow.com/docs/r/now-intelligence/reporting/rep-service-catalog-variables.html

https://www.servicenow.com/docs/r/now-intelligence/reporting/use-service-catalog-variables-in-report...

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.

[Tanushree Maiti]

Hi @pramn 

Users may lack the necessary permissions to view the underlying variable tables like  sc_item_option and sc_item_option_mtom.  It kind of limitation of Data Model/Data structure.

So to create report with RITM variables, you can follow -

Option A:

You can create a report that with variable columns and then export that report to CSV or Excel.

1. Navigate to Reports > Create New.
2. Data Source: Select sc_req_item (Requested Items) table.
3. Filter Conditions: Set Cat Item | is | [Name of Catalog Item A].
4. Configure -> Choose Columns:
• In the slushbucket, scroll down until you see Variables (marked with +).
• Click Variables. A popup will appear asking for the Catalog Item. Select Catalog Item A.
• Select the variables you want and move them to the right.
5. Save and Run the report.
6. Click the share/export icon and select Export > CSV or Excel

Option B:

If you need to do this frequently, creating a Database View is the most robust approach to join RITM data with Variable data

Refer: Reporting on Catalog item variables

[Ankur Bawiskar]

@pramn 

what type of report you are creating?