dbTalk Databases Forums  

USE_EQUAL_ALLOCATION Behavior

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


Discuss USE_EQUAL_ALLOCATION Behavior in the microsoft.public.sqlserver.olap forum.



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

Default USE_EQUAL_ALLOCATION Behavior - 09-09-2003 , 03:30 AM






Hi,

It seems that using the USE_EQUAL_ALLOCATION method on an aggregated
cell does not work properly when a calculated cell exists on the updated
cell.

Could you confirm if this is a normal behavior? e.g. Update Cube not
supported on calculated cells?

Thanks,
Lionel



Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: USE_EQUAL_ALLOCATION Behavior - 09-09-2003 , 01:09 PM






"Lionel Gomes" <lionelgomes (AT) hotmail (DOT) com> wrote

Quote:
Hi,

It seems that using the USE_EQUAL_ALLOCATION method on an aggregated
cell does not work properly when a calculated cell exists on the updated
cell.

Could you confirm if this is a normal behavior? e.g. Update Cube not
supported on calculated cells?

Thanks,
Lionel
UPDATE CUBE is not supported if the cell it updates, or cells it aggregates
from have any kind of calculation (calculated members, calculated cells,
custom rollups, unary operators etc).

HTH,
Mosha.

--
==================================================
Mosha Pasumansky - 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.
==================================================




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.