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
m-kovalsky
commented
3 years ago
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