Hi,

Is there any .asp file with XML output from MS AS2000 based on Foodmart 2000?

Regards,
Marco

Two options:
1) Use XMLA SDK. All of it's data streams are XML :-)
2) If you look at the AS Operations Guide (see
http://www.microsoft.com/technet/pro.../anservog.asp),
in one of the appendixes it shows you how to create a linked server through
SQL Server. Once you do that, you can use standard SQLXML facility, i.e. FOR
AUTO.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Olap_NL" <olap (AT) gmsbv (DOT) nl> wrote