If you’re querying SSAS DMVs you might wish to add some situations within the question.
One thing like getting all lively relationships, maybe like under:
choose * from $SYSTEM.TMSCHEMA_RELATIONSHIPS the place IsActive="true"
Operating the above question on an occasion of SSAS Tabular provides you the next error message:
Error: A Boolean expression is just not allowed within the context …
Fixing that is fairly simple, run the under question to get lively 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
