Hi,
I am trying to perform a write-back operation in a sample cube.
I have enabled write-back in the partition

1. I have executed this MDX

select
[Measures].[Sales Amount] on columns,
[Dim Product].[Dim Product Category - Dim Product Subcategory].[Dim
Product].&[354] on rows
from [Adventure Works DW]

2. Then I have executed the update cube script

update cube [Adventure Works DW] set
([Measures].[Sales Amount],
[Dim Product].[Dim Product Category - Dim Product Subcategory].[Dim
Product].&[354])= 3000

3. I have executed the MDX in the 1 step and obtained the same value!!

I have tried different things : process the write-back partition
(before and after updating the cube) process the whole cube... with no
luck.
As a matter of fact the write-table is created but I have never got to
insert any value in it.

Any help, sample code... will be really appreciated.

Well I have solved my problem.
I was using Management Studio to execute the MDX queries, the problem
is that I was trying to see the changes in the cube from another MDX
console. The update statement changes the values of cell at session
level i.e. you can only see the changes in the same console that you
have used to execute the update statement until you perform a commit
statement (and maybe this is a config problem but I don´t care).
When you execute commit, the changes are written in the write-back
table and are accesible for all users (sessions)

Hope this helps.

juanignaciodelvalle (AT) gmail (DOT) com ha escrito: