cannot find dimension member in a name-binding function

Sorry to repost about this, but something was apparently wrong with my
profile that was keeping the MS support engineers from seeing my messages. I
hope y'all can see this one.

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 seen this problem? Anyone gotten this to work without having to run
the same query twice?

-- J
.

Relevant Pages

  • RE: cannot find dimension member in a name-binding function
    ... I had the same problem once - after openning the connection I got "cannot ... find dimension member" error, but from the 2nd run on evrything went fine. ... After this the same query started to work normally, ...
    (microsoft.public.sqlserver.olap)
  • Cannot find dimension member - in a name-binding funct
    ... 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 ... If I execute the SAME query again with the ...
    (microsoft.public.sqlserver.olap)
  • Cannot find dimension member - in a name-binding funct
    ... I have a MOLAP cube with a big dimension. ... 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 ... If I execute the SAME query again with the ...
    (microsoft.public.sqlserver.olap)
  • Re: ASP - FROM statement slows down connection to database
    ... Open your database in Access, switch to the Queries tab, create a new query ... in Design View without choosing a table, swtich to SQL View, paste the sql ... connection string rather than using an ... recordset open statements. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Update checking
    ... My thought was to use a simple query with a "username" param ... concurrency exceptions happen if the data you queried has ... > was and basically let the user work in a similar offline mode. ... Where does connection pooling come ...
    (microsoft.public.dotnet.framework.adonet)