I am trying to add security in the cube using custom views. I am trying to exclude the categories that i dont want. But exclude only works when i try to drag measures in the analysis studio otherwise it display everything in the dimension. I want to only display categories based on teh security group. please advice