[Rule Request] Provide short rule description

[cosminioan]

is there a way to create a rule to detect which fact table columns generate a referential integrity on any particular dimension?
Looks like the Vertipaq Analyzer provides the count of RI's for each dimension, but no info on the offending fact tables.

Also, trying to use this query below, also does not surface the fact tables:
select
[Database_name] ,
[Dimension_Name] ,
[RIVIOLATION_COUNT]
from $SYSTEM.DISCOVER_STORAGE_TABLES
WHERE
[RIVIOLATION_COUNT] > 0

thank you kindly,
Cosmin

[m-kovalsky]

https://www.elegantbi.com/post/findblankrows