Create report on Transform Histories

[David Casper]

I'm trying to create a report against the Transform Histories table (sys_import_set_run). I would like to be able to filter this based on specific tables. In my case the one used to import our users. 

Issue I'm having is I'm not seeing the table available when choosing a table in the reporting wizard. Has anyone ran into this and if so discovered a work around?

Thanks

[ARG645 · Accepted solution]

David,

System tables are, by default, restricted from the Reporting module. There is a system property called glide.ui.permitted_tables . Add sys_import_set_run in the comma separated list of values and you can see the Transform History Table available for Reporting. 

Reference: 

Reporting on system tables

Thank you,

Aman Gurram

[ARG645]

David,

Please close this thread if your question was answered, so that it may help others in future. 

-Aman Gurram

[David Casper]

Your answer was it. Thanks for the help!!!

[Khanjan]

Hello Aman,

Your explanation is straight and the solution is apt.

I am facing the same issue as David. 

I added the transform table (sys_import_set_run) in the System Properties.

However, it does not get reflected into the table name in the reporting wizard. Does it take more than an hour for the table name to get updated on the reporting wizard?

Thanks,

Khanjan