dbTalk Databases Forums  

Advanced writeback knowledge

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


Discuss Advanced writeback knowledge in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mike
 
Posts: n/a

Default Advanced writeback knowledge - 01-11-2006 , 02:45 PM






Is there any documentation that explains the best way to do writeback in a
cube? Specifically if you want to writeback a number of records at a time.
UPDATE CUBE works very slowly for one record, so I can't imagine it working
to well on multiple records at a time.

In addition what are the possibilities of changing dimension members in the
writeback but getting it to aggregate the correct value in the writeback? ie
for [Dim1].Leaf1 we have a value of 10 which is also the value of
[Dim1].Leaf1.Parent
we want this parent value to now be 20 by assigning a writeback value of 10
to [Dim1].Leaf3 rather than to Leaf1 so that the aggregate is still 20 but we
have some sort of audit trail in the writeback.

Thanks

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.