dbTalk Databases Forums  

Writeback with Weighted Allocation - Avoiding Div/0 Errors

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


Discuss Writeback with Weighted Allocation - Avoiding Div/0 Errors in the microsoft.public.sqlserver.olap forum.



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

Default Writeback with Weighted Allocation - Avoiding Div/0 Errors - 10-06-2003 , 04:18 PM






I am trying to work with a writeback cube. I want to be
able to use the weighted allocation writeback function.
However, if you try and writeback to an atomic cell that
has a written value of 0, the cell get a div/0 written to
its value, which basically kills the cube (you have to
clear all of the writeback data in order to get the cube
usable again).

Does anyone know of a way to avoid this. I would like to
find a way to avoid having to change allocation method
whether the cell is a rollup or atomic cell.

thanks

Chris Locke

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.