Error while browing SSAS Cube having data security implemented on dimension

• myssas

  Grasshopper

  Points: 11

  More actions

  March 13, 2014 at 11:38 am

  #284584

  We have a revenue cube with one of the dimension as office. Office dimension has various values like branch1, branch2,....

  I want to have dynamic data security on this cube so as to person belonging to branch1 can see revenue of branch1 only and so on. For this I have created 3 SSAS Roles viz branch1, branch2 and branch3 and applied data security on dimension 'office' so as to see only memebers belonging to them. In the creation of role, I have selected 'read permissions' on first page and selected required dimension members on 'dimension data' pane and selected 'enable visual totals'.

  Earlier the data security was working as expected. When we browse cube in SSAS/ SSMS, there is a option to browse cube using perticular role. Earlier this was working fine. Afterwards we migrated our entire contect to a new server. Now also cube is browsing fine without any data security applied. But when I try to browse cube using perticular role, it doesn't display any data and simply shows error message as 'cube cannot be browsed, verify that cube is processed.....'.

  Any guesses what could be wrong? I have added a new 'count distinct' measure to this cube (which is working fine when browsing cube normally), is that the issue? I am not that expert in SSAS, so need help.

  Thanks in advance.

  -Regards,

  Raj Patil