Boolean Situations when Querying SSAS DMVs

In case you are querying SSAS DMVs it’s possible you’ll need to add some circumstances within the question.

One thing like getting all energetic relationships, maybe like beneath:

choose * from $SYSTEM.TMSCHEMA_RELATIONSHIPS the place IsActive="true"

Working the above question on an occasion of SSAS Tabular provides you the next error message:

Error: A Boolean expression isn’t allowed within the context …

Fixing that is fairly straightforward, run the beneath 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