I have two cubes under one SSAS database that I am building. Essentially, they're the same except one cube contains a dimension with confidential data and one does not contain that dimension.
What I'm looking to do is restrict access to the cube containing confidential data to a limited set of users, but it seems that SSAS roles are only at the database level and not the cube level?
Is there a way I can set up security at the cube level in SSAS, so some users can see both cubes when they open it in Excel, and other users can only see one cube?