Home Business Intelligence Boolean Situations when Querying SSAS DMVs

Boolean Situations when Querying SSAS DMVs

0
Boolean Situations when Querying SSAS DMVs

[ad_1]

Boolean Comparison in SSAS DMVs, Error: A Boolean expression is not allowed in the context

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

Boolean Comparison in SSAS DMVs

And to get inactive relationships run this one:

choose * from $SYSTEM.TMSCHEMA_RELATIONSHIPS the place not IsActive

Boolean Comparison in SSAS DMVs

[ad_2]

LEAVE A REPLY

Please enter your comment!
Please enter your name here