Hi,

I get error using openquery statement in SQL by using MDX that was generated
by my olap client tool (ProClarity). The thing is that only specific
calculated members makes this error. In general it works fine. The problem
is that I need data of the problematic calculated members.

SQL 2000, AS 2000 - SP3a
Win 2000 latest SP

Use linked server to OLAP server, works fine.


Error:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'MSOLAP'.
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14].

Ideas?


Peace,
Andrej

Found the problem.

The thing is if you use OPENQUERY or OPENROWSET to your OLAP database (cube)
and want to show a calculated member (measure) and if this calculated member
is calculated from any other calculated member that is hidden, then you will
not get result from OLAP - you'll receive the error described before.

Example: measures
Measure1 (visibile)
Calc1 (visibile)
Calc2 (hidden)
Calc3 (visibile; formula: Measure1 + Calc2)

If you want to get data for Calc3 using OPENQUERY or OPENROWSET you'll
receive error:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'MSOLAP'.
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14].


Hope this helps anyone.

PEACE!
Andrej


"Andrej Hudoklin" <andrej.hudoklin (AT) add (DOT) si> wrote