May 3, 2009 at 1:18 pm
It appears that by default, users can over-type dimension values in Excel when browsing cubes. Refreshing the cube does not reset the overwritten data, even if the dimension is removed from the cube and re-added, or the file closed and reopened. For example, I have a cube containing financial data by country. I can change the country name in the pivot in Excel from "Australia" to "Dave" (although not the associated measure values). Whatever I seem to do with the file thereafter, I have a country called "Dave" in the Excel file (although not in the underlying data).
I need to prevent users from being able to do this, whilst maintaining their ability to manipulate and refresh the cube. I've tried protecting the sheet in Excel, but it won't then allow a refresh. All of the access levels in the cube role are set to Read. Is there a setting in SSAS that will prevent changes being made to dimension values in Excel Pivot tables?
Thanks!
Mark
May 3, 2009 at 10:08 pm
I have seen this behaviour in the past and as far as I know, this cannot be changed. The changed value does not update anything back on the server - it only changes the value that the spreadsheet displays.
I haven't checked but there may be a way to do this programatically (i.e. VBA code within the spreadsheet).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply