Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 807778
Opened: 11/5/2013 8:10:28 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Sign in to post a workaround.