SSAS: New function to ignore every dimension filter except the dimensions included in the function - by NilsRottgardt

Status : 


Sign in
to vote
ID 807778 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 11/5/2013 8:10:28 AM
Access Restriction Public


In some cases it is necessary to have dimension filters ignored in calculated measures.  (there are many threads in the SSAS forum about that topic)

To get this running you have to set every dimension to the ALL members. If you add a dimension, you have to add it manually there and also if you have many it is not nice.

So instead of setting everything to ALL to ignore it would be helpful to have a function that does it inverse....adding the dimension that should be used to filter only.  
Sign in to post a comment.