| Jonathan Levine 2005-04-21, 3:24 am |
| I am seeing an interesting, inconsistant error in Analysis Services queries.
I have a MOLAP cube with a big dimension (about 6 million members). I have
the VLDMThreshold set to about 10 million on the server -- otherwise
processing the cube takes forever. The dimension is relatively flat, so I
have a hidden grouping level between the top level and the leaf level. The
leaf level has Unsigned Big Integer keys (the member key is the same as the
member name), and both member keys and member names are set to true.
After opening a connection to the cube, the first time I slice on the big
dimension, I get a "Formula error - cannot find dimension member - in a
name-binding function." If I execute the SAME query again with the
connection still open, the query succeeds. If I close the connection, reopen
it, and execute the query again, it fails again. This is true whether I make
the query via the MDX sample application or via a VB.Net object.
The problem doesn't happen when I make the keys Varchars. But when they are
Varchars, the dimension is larger, and so the server frequently runs out of
memory.
In my VB.Net, I'm working around the problem by manually opening the
connection to the cube, catching the Formula Error exception and running the
query again before closing the connection. But maybe I'm missing something?
Anyone else gotten this to work without having to run the same query twice?
-- Jonathan
http://kerblog.com/earlyedition/arc.../04/21/424.aspx
|