Child Tables Not Visible in Platform Analytics Reports

[AnupriyaC]

Hi Everyone,

I would really appreciate your help with this. In my PDI instance, Platform Analytics allows me to see all child tables under the Task table and dot-walk to them while adding columns in a report. However, in my dev instance, none of the child tables under Task are visible when trying to add columns in a Platform Analytics report. What could be causing this issue, and how can I make the child tables visible in my dev instance?

In My PDI: 

In MY Dev Instance:

Thanks in Advance!!!

[ThorS]

Have you checked into the table access differences between the PDI and DEV? Also, are you aware of any role differences? I believe I have higher roles in the PDI than I do in my DEV.

Last thing I can think of is to check if there's a difference in the application scope between the child tables.

[AnupriyaC]

Hi @ThorS ,

Thanks for the reply. I have the admin role in my DEV instance and tried both Global and Scoped apps same result. It works fine in my PDI, though.

In Platform Analytics, I’m trying to access Task SLA > Task > Incident > State as a column, but it’s not showing. Dot-walking works in the filter section, just not while adding columns. Both instances are on Yokohama, and the system properties "glide.ui.list.allow_extended_fields" is true in both.

Since PDI is on Patch 1 and DEV is on Patch 6, could that be the reason? Please guide me on this.

Thanks 

Anupriya C

[AndersBGS]

Hi @AnupriyaC ,

Why are you creating reports based on task table and then trying to dot-walk to incident etc.? As you should know, incident, problem and other tables are extended from task table. So it is always better to report on the actual table instead of starting from task table.

[AnupriyaC]

Hi @AndersBGS,

Thanks for the response. The base table I’m using in Platform Analytics is Task SLA, and I want to display columns from related tables like Incident and Problem to show the incident number, state, and SLA breach time together.

I tried using Task SLA > Task > Incident > Number to display it as a column. I have admin access, so it should ideally work. Could you please guide me if there’s any way to make it work?

Thanks,
Anupriya