Writing Data into Analysis Services - Microsoft SQL Server 2008 Analysis Services - page 300

Other Ways to Perform Writeback
In addition to the UPDATE CUBE statement discussed earlier in this chapter, you can use the
IRowsetChange OLE DB interface to provide writeback capabilities. Using an OLE DB
provider to update cell values is not a new functionality. This method of updating cell data
in the cube has been available in all versions of Analysis Services and documented in the
OLE DB for OLAP specification. Because it's a well-documented and established method for
updating cell data, we won't spend too much time discussing it here.
If you write your application in native code using Visual Basic or another language that
supports OLE automation, you might use ADO MD to update the cube through a CellSet
object . The CellSet object in ADO MD enables you to not only read cell data but also
write it. ADO MD has also been available for a while and is also well documented.
Unfortunately, the CellSet object included with ADOMD.NET object model doesn't
provide the capability to write cell data. However, you can execute UPDATE CUBE state-
ments to update cell values.