Hi

I am currently using the cool features of the Extending OLAP.xls workbook provided by Microsoft (writeback + drillthrough). However in this solution every update made are visible for all users. I am wondering if it is possible to writeback temporarily in the pivot table service cache in order to keep private the update made through the pivot table(in order to have aggregated levels and calculated measures updated as when you writeback to the olap cube). Tell me if it is possible and how
Thanks

Yes - it is possible. Basically, if you only issue UPDATE CUBE command, the
data is kept in the session, and other users don't see it.
Once you do COMMIT TRANS - it is propogated to the cube and everybody sees
it.
So you need to buttons in UI - one for the changing cell values, and another
one for commiting the changes.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Oliver Canada" <anonymous (AT) discussions (DOT) microsoft.com> wrote

every update made are visible for all users. I am wondering if it is
possible to writeback temporarily in the pivot table service cache in order
to keep private the update made through the pivot table(in order to have
aggregated levels and calculated measures updated as when you writeback to
the olap cube). Tell me if it is possible and how?