Hi Lucas,
Thank you for posting in MSDN managed newsgroup!
From my understanding to this issue, you have one cube in the SQL analysis service which enable the write back. This feature is often useful for a
client application to be able to add or remove members from a dimension. In your scenario, you're going to update the data from the pivottable
control at the client side.
If so, You will need to use ShowDetails method to display the detailed data so that the users can update the dimension data very easily in the client
side. For your convenience, there is one "Detail Editing" sample from the Office web component toolkit which will demonstrate this feature for you. In
the toolkit, you can find the sample from "New OWC features->Pivottable List Demonstration". From the pop-up IE window, pleaes click the "Next"
button 5 times and the sample will be showed for you. The source code for this sample is located in the functions: customersDBConnect() and
showDetailEditing() which is located in the %programfiles%\office component toolpack\Walkthroughs\Pages\PTDemo.htm by default.
Please feel free to let me know if you have any further questions.
Does this answer your question? Thank you for using Microsoft NewsGroup!
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! -
www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
