MDX - how to exclude certain members in mdx -


i'm wondering how exclude members 1 dimension have links other members dimension ... let's want exclude clients (dim_clients) have status or status b (dim_status). know how crossjoin 2 dimensions obtain clients can't figure out how exclude them calculation since except function accepts 2 sets same dimensionality ones want exclude result of crossjoin operation, can't use except function

i want :

select measure.mymeasure on 0  mycube   except([dim clients].[clients], [excluded clients]) 

thanks

select measure.mymeasure on 0 mycube except([dim clients].[clients], filter({[dim clients].[clients]},[dim_status].currentmember [dim_status].statusa or [dim_status].currentmember [dim_status].statusa)) 

i not sure [clients] is. use members though.


Comments