BestPracticeRules

BestPracticeRules copied to clipboard

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

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