Hi.
I have some problems to query OLAP cube with MDX expression using an ASP
web application. There is a server with Windows Server 2003 OS. When the web
application is executed the next error occurs

Microsoft® OLE DB Provider for Analysis Services error '80040e14'
Formula error - cannot find dimension member ("[Entidad y
municipio].[Total].[Coahuila de Zaragoza]") - in a name-binding function

The error is always generated by the same element of the same dimension. but
i reviewed the dimension's structure in Anaslysis Services but it is OK.

But when i execute the same web application in another server with Windows
2000 Server Advanced, it works well, the error doesn't appear.

I don't know if Windows 2003 has something that is affecting.
Thanks.

Hi,

If it the same MDX query works from one server but not on another then I
would look at the version of the MSOLAP80.DLL that you have on the server.
If it anything lower than version 760 then I would upgrade that server to
SP3.

Are there any security roles on the cubes where that member wouldn't be seen
when a specific account is being used?

David Botzenhart


"Japm" <Japm (AT) discussions (DOT) microsoft.com> wrote

Thanks for replaying. There is a role defined on the cube, but all users can
query all data, i think the rol is not the problem. I have another cube in
another db in the same server (2003) using the same datasource and the same
dimension but in that cube everthing is OK, and it is using the sema rol.
It's some "strange".

In both servers (2003 and 2000) is installed the same version of Analysis
Services, do i have to review the version of the dll?

Is there anything else to review?

Thanks again.

"David Botzenhart" wrote:

Can you get to the member on the 2003 server via MDX Sample application?

David
"Japm" <Japm (AT) discussions (DOT) microsoft.com> wrote

Yes I can get the member using the MDX Sample application. I use the same MDX
sentence in a little ASP program (only to do this query) but it doesn't work
well, I have the same problem. I don't know if the Sample applciation works
in different way to the web application.
This little program works well when I use the OLAP database installed in the
same place (a PC with 2003 and Analysis services installed).
I don't know what else I need to review.
Thanks for replay again.


"David Botzenhart" wrote: