MS SQL Server OLAP - Query errors on write enabled cubes using NONEMPTYCROSSJOIN functi

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Query errors on write enabled cubes using NONEMPTYCROSSJOIN functi

SH Woo

2006-03-24, 3:27 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

Sponsored Links