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
Post a Comment