Hello,everyone.

I'm beginner in OLAP and I need some help.
So, I'm using SQL SERVER 2000 without Analyses Service (not installed).


I wanted to create simple query to select some data from cube which is
on another server with analyse services installed.
EXEC sp_addlinkedserver
@server = 'San',
@srvproduct = '',
@provider = 'MSOLAP',
@datasrc = 'San',
@catalog = 'Sales'
GO

but then a run openquery I get a message that database Sales not
found. But it there,beacouse I can select data from any table if add
server as sql server!
If I remove database and run openquery I get an error "cannot open cube
'Test'".

Can anyone explain me where is my error and how to solve thisproblem?
Thanks a lot.

There are a couple of things that you need to get right in order to get
this working.

1. The SQL Server where you are creating the linked server needs to be
running under a domain account that has permission to query the cube.
When you query the linked server it is SQL Server that then queries the
cube on behalf of the end user.

2. You need to have the MSOLAP provider setup to run in-process. The
MSOLAP provider will not work if this option is not set. When you create
a linked server from Enterprise Manager there is a button for the
provider options, you will find the in-process option in there.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1157622763.299708.295560 (AT) i3g2000cwc (DOT) googlegroups.com>,
vzsnake (AT) gmail (DOT) com says...