You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: