Hi all,

I'm currently doing wome test in order to write value into my cube (only
promotion and order date !)
(of cource I write enabled my cube BI Mgt + process).


I run the following query :
select
(
[Measures].[Order Quantity],
[Order Date].[Calendar Time].[Calendar Year].&[2004].&[April].&[1006],
[Promotion].[Promotions].[All Promotions]
)
on columns
from
[MyTDWBCube]

i get some as result 170.
It runs a SQL Server DB query (sql profiler) meaning that SSAS consolidates
cube + wb table.
then I ran :

update cube [MyTDWBCube]
set
(
[Measures].[Order Quantity],
[Order Date].[Calendar Time].[Calendar Year].&[2004].&[April].&[1006],
[Promotion].[Promotions].[All Promotions]
) = 100
USE_EQUAL_ALLOCATION

expecting that my number will splitted throught the promotions.

But if I re-run the mdx query I still get 170 (expecting 100).

Any idea ?

Renaud - Paris

working with write back on 2000 platform - dont know if it is differnt on
2005.

where are u running the query ?

maybe u need to begin transaction and commit transaction ?


"Renaud Harduin" <RenaudHarduin (AT) discussions (DOT) microsoft.com> wrote