How do you set up a SQL OLAP Server as a linked server in SQL 2000? Firstly,
is it possible and if so, How?

Thanks in advance.

Analysis Services Operations Guide, Appendix F
http://www.microsoft.com/technet/pro.../anservog.mspx
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

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

Yes, it's possible.

Refer to the titles below from BOL.
- How to add a linked Analysis server using SQL Server Enterprise Manager
- Passing Queries from SQL Server to a Linked Analysis Server


Ohjoo Kwon

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

Dave, It seems that the SQL used by OLAP OLEDB provider does not
support the operators < and > . How else can the resultset be filtered
before it is returned to SQL sever?