Hi all, thanks for all your comments and support. As asked by many of you, I will be uploading videos related to MS BI and sql server technology on my blog. Let me know what you think and looking forward for your suggestions.
In this video, I will demonstrate the creation of SSAS project using visual studio / BIDS. This video is mainly focused at beginners.
Cheers — Admin
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.
You can remove or hide the “Unknown” members in each dimension. It is very simple to achieve this task. Follow the steps below.
In the solution explorer navigate to the “Dimensions” folder.
