Tried Mirosofts' example of different allocation methods - this sentence for
instance:

strUpdate = "UPDATE CUBE [Sales] SET "
strUpdate = strUpdate & "([Time].[All Time].[2001].[Quarter
1].[January].[1], [Regions].[All Regions].[United States].[Ohio],
[Measures].[Sales Measure], [Products].[All Products]) = 280000 "
strUpdate = strUpdate & " USE_EQUAL_ALLOCATION"


I have 29 products to place this on and it places 9655,172 on 28 but
8995,182 on the 29'th.

Can anybody explain that ?

And futhermore can anybody explain the differnce in these 2

Equal allocation: Each constituent cell is assigned an equal value.
Equal increment: Every constituent cell will be changed according to
an
incremental value

"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Most probably your measure is of type Integer, and the value you are
assigning cannot be divided equally to the number of descendants of the
cell. Therefore the reminder is carried to one of the cells.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
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.
==============================*=================== =
"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Nope

It's writing back at sales measure which is Double in AS and a decimal field
in the underlying fact table.

However I'm writing back using Jet ole against an Access database - could
this cause trouble - should I try against SQL Server instead - however - the
example
was based on an access table.

The allocation is with many decimals - it actually says 9655,1724137931 28
times and 8995,18224137931 one time.

I think it's a large rounding difference.

"Mosha Pasumansky [MS]" <moshap (AT) online (DOT) microsoft.com> wrote