Hello,

we are moving our old reports from AS 8.0 to AS 9.0 and encountered
with the issue. That this query is working fine in AS 8.0 but not
working under AS 9.0:

SELECT top 10
*
FROM
openquery(OLAP_LINK,
'select [Timeate!KEY]
from Transactions')

It seems that "[Timeate!Key]" is not longer working...

The error says:
An error occurred while preparing the query "select [Timeate!KEY]
from Transactions'" for execution against OLE DB provider "MSOLAP" for
linked server "OLAP_LINK".

Can we somehow migrate old reports without rewriting them under MDX?

Thanks

Hi John,

The SQL syntax that AS2005 supports is somewhat different from that
supported by AS2K. See
http://cwebbbi.spaces.msn.com/blog/cns!7B84B0F2C239489A!751.entry
for more details on AS2005 SQL; you'll definitely have to rewrite all your
reports. When you do so you should really use MDX rather than SQL - there's
no guarantee that AS SQL is going to be backwards compatible and anyway, MDX
is so much more powerful for writing BI-style queries.

HTH,

Chris

--
I blog about Microsoft BI here:
http://spaces.msn.com/cwebbbi/
Do you need help with Analysis Services or MDX? I''m available for hire:
http://www.crossjoin.co.uk/


"John.Luckowsky (AT) gmail (DOT) com" wrote: