I have two cubes.
A having dimensions d1,d2,d3,d4 and a measure a1.. the
cube is write-enabled.
B having dimensions d1,d2,d3,d5 and a measure b1.. also
write-enabled.
I make a virtual cube V and include dimensions
d1,d2,d3,d4,d5 and measure a1,b1
but when i try to writeback measure a1 using 'update V set
d1,d2,d3,d4,a1 = x' it throws an error saying
"unable to open cellset
unable update N/A cell in the virtual cube"
What am i doin wrong??
I hope the problem example makes sense.. help required.
Also the query works well with update A instead of
V..which is absolutely the way it shud be.

You have to make sure that when you write to the virtual cube, all the
dimensions which are not part of the real cube for the current measure are
positioned at their first level.

--
==================================================
Mosha Pasumansky - http://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.
==================================================
"Ashish" <AAgrawal (AT) nexgenix (DOT) com> wrote

What do you mean by first level? Do you mean 'ALL' Level?
Will the position of dimension in the cube have any
bearing on the update.

All level - then the first level is All, but it may not have it, and then
first level will be something else.


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