Question

Solved918 views12th July 2023Dashboard EPM GQI

2

Mauro Merconchini [SLC] [DevOps Member]65 27th September 2022 2 Comments

Hello,

In a dashboard, is it possible to filter a table in GQI using an EPM feed to find all the rows with valid relations?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 12th July 2023

Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented 27th September 2022

Can you elaborate on ‘Valid relations’?

Mauro Merconchini [SLC] [DevOps Member] commented 27th September 2022

We currently filter a child table in Visio using a tableRowFilter or FullFilter with the following syntax: parentTablePkPid == parentEntityPk and that returns all the rows from the child table that have a valid relation defined in the protocol since we don’t have a direct FK relation from the child table to the parent table.

We’re wondering if that is also possible using GQI, doesn’t need to be with an EPM filter but would be preferred if possible.

1 Answer

We currently filter a child table in Visio using a tableRowFilter or FullFilter with the following syntax: parentTablePkPid == parentEntityPk and that returns all the rows from the child table that have a valid relation defined in the protocol since we don’t have a direct FK relation from the child table to the parent table.

We’re wondering if that is also possible using GQI, doesn’t need to be with an EPM filter but would be preferred if possible.

score 3 · Answer 1 · 2022-09-28T06:07:43+00:00

Hi Mauro,

GQI currently has no automatic way to resolve foreign key relations. To achieve this you would need to join the underlying tables for every relation.

Knowing EPM this will only be feasible for the upper levels of the topology, as the lower levels contain too much data which will have a negative impact on performance. Since this heavily depends from system to system, I suggest to test this our for your specific use case.

Using GQI to find table rows with valid relations.

1 Answer