
[ad_1]
In case you are querying SSAS DMVs you might wish to add some situations within the question.
One thing like getting all energetic relationships, maybe like under:
choose * from $SYSTEM.TMSCHEMA_RELATIONSHIPS the place IsActive="true"
Operating the above question on an occasion of SSAS Tabular offers you the next error message:
Error: A Boolean expression shouldn’t be allowed within the context …
Fixing that is fairly simple, run the under question to get energetic relationships:
choose * from $SYSTEM.TMSCHEMA_RELATIONSHIPS the place IsActive
And to get inactive relationships run this one:
choose * from $SYSTEM.TMSCHEMA_RELATIONSHIPS the place not IsActive
Associated
[ad_2]