i want to display catalog item variable related sc_task on to platform analytics dashboard

[LVPhanee]

i want to display catalog item variable related sc_task and another custom table variable, on to platform analytics dashboard. created a Database view by using the above said table. 

my ask is Catalog task is having few Variables, how to get them to database view. 

once it come to database view we can show populate on the Platform analytics dashboard. 

( in Reports we used to bring the catalog item variable on to the report dashboard but they are not appearing on the Platform analytics dashboard). 

[Ankur Bawiskar]

@LVPhanee 

it's not the same how it would work in platform analytics

have report on sc_task and then get the variables

Service catalog variables in data visualizations 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[LVPhanee]

i don't have write access on the Sc_task table to create new fields. I forgotten to mention that. 

[Ankur Bawiskar]

@LVPhanee 

why you require write access on sc_task?

Directly use sc_task table in your visualization

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[musislam]

Hi,

Building on Ankur's point - here is the exact click path, verified in my PDI just now.

Data visualization > Data sources > Add data source > Catalog Task [sc_task]. Then Group by > Add, and in the field search type "var". An entry appears under Other called "Variables - select from variables and variable sets". Picking it opens a Variables fields panel listing every catalog variable with its catalog item underneath.

That is why they look missing - they are not in the plain field list, only behind that search. No new fields on sc_task and no write access needed.

The database view is the other half of it: the variable join is only offered when the source is the task table itself, so a view will never surface them. Point the visualization straight at sc_task.

If that gets you there, mind marking it as the recommended solution? Helps me support these better for the community.