Use Office Excel 2010 to writeback / insert data into SSAS cubes
According to me Excel is one of the best tools ever produced by Microsoft. In this post , I will talk to you on a new feature from Excel.
Every time you try to change a cell in excel pivot tables you will come across this error.
Writeback is a new feature available in excel to overcome this. The new feature seems to unlock the final goal for writeback by providing a desktop user the ability to change specific values. The feature also helps adding the changes the to the cube quickly doesn’t require the cube to be processed. Once the changes are committed by a desktop user, the changes will be visible to other users on refresh.
Note: Before enabling the writeback functionality from excel, remember to do the necessary changes in cubes (using partitions) to support writeback functionality.
The steps and screenshots below will help you in configuring writeback functionality from excel pivot tables.
Step 1:
Click on value columns in the pivot table generated from cubes. Navigate to menu PivotTable-> Options and click on “what if Analysis” as shown in the screen shot below.