Query errors on write enabled cubes using NONEMPTYCROSSJOIN functi -
03-24-2006
, 01:52 AM
I have an application that can update an MSAS 2000 cube, but I get errors
when I attempt to retrieve data from cells impacted by the write back Update
Cube command. My application uses ADOMD.NET 8.0 to retrieve the cellsets
from the cube. I only receive an error if the cube contains calculations
using the NONEMPTYCROSSJOIN function.
The follwoing error is received in the ADOMDException when I execute a
cellset query:
"Some data has been updated since you began executing this query. - An error
occurred during attempt to get a cell value"
However, if the updated cells are commited to the writeback table, the error
disappears during a subsequent query for the same cellset. Is this a bug and
is there a remedy?
Thanks,
SHW |