I am trying to create a cube role that gives read access to everything and write access to the 'Plan' member of the Scenario dimension. I tried to follow the instructions in BOL but the writeback doesn't seem to work. I have write enabled the cube and created a writeback table. I created a role, then clicked on the 'Cells' tab and selected 'Advanced' for the Cell security policy. Under 'Advanced Cell Security' I selected 'Custom' for the Read/Write permission and entered this MDX:
Scenario.CurrentMember.Name = "Plan"
I used an Excel addin front end to query the cube at the lowest level of every dimension, with Plan being selected for the Scenario dimension. When I enter numbers into the cels and select 'Writeback', it tells me I am about to writeback to the cube. When I drill up a level, and then back down to the lowest level, the numbers are gone.
Has anyone used writeback with Analysis Services? Your help is greatly appreciated.
Scenario.CurrentMember.Name = "Plan"
I used an Excel addin front end to query the cube at the lowest level of every dimension, with Plan being selected for the Scenario dimension. When I enter numbers into the cels and select 'Writeback', it tells me I am about to writeback to the cube. When I drill up a level, and then back down to the lowest level, the numbers are gone.
Has anyone used writeback with Analysis Services? Your help is greatly appreciated.