Writeback into cube using excel services

We have to integrate SQL Cubes with Excel web services(in sharepoint). We are able to read the data from cubes into an Excel uploaded on Sharepoint.However we are stuck on trying to write back to the same.In excel 2000, VB macros could be used but what about excel web Services
knaren_1975Asked:
Who is Participating?
 
RWrigleyCommented:
Write back into cube?  I don't understand.  Cubes are typically read-only.  You'd could write into the relational database that cube is created from, and design the cube as HOLAP or enable "Dynamic Caching" have the cube automatically rebuilt though...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.