dbTalk Databases Forums  

Enable OLAP Write-Back

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Enable OLAP Write-Back in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roberto Lo Baido
 
Posts: n/a

Default Enable OLAP Write-Back - 01-27-2004 , 03:07 AM






Hi! I've enabled a cube for write-back by right clicking
the cube and selecting "...enable write-back".
The problem is that now i still can't modify data. Am i
missing something? What do i have to do to enable and use
write-back?
Thanks in advance!

Reply With Quote
  #2  
Old   
Rob Anderson
 
Posts: n/a

Default Re: Enable OLAP Write-Back - 01-27-2004 , 09:52 AM






Unless you have a client tool that supports writeback, then you must control
writeback using ADOMD. This requires you to set up an ado connection and any
updates must be done within a transaction, this can only be done at the leaf
level. If you want to update at the agregate level then you can use the
update cube statement and do some kind of allocation to the leaf level
cells.

Hope that helps
Rob


"Roberto Lo Baido" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi! I've enabled a cube for write-back by right clicking
the cube and selecting "...enable write-back".
The problem is that now i still can't modify data. Am i
missing something? What do i have to do to enable and use
write-back?
Thanks in advance!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.