I have problem that is driving me mad.
Server environment:
x 2k3
SQL Server 2000
Analysis Services 2000 ver. 8.00.194

Client environment:
2000 SP4
Excel 2000

I have created cube to analysis services and I am trying to access it using
client workstation and Excel 2000 (OLE DB for olap services). The problem is
that server is found and connection works but the cube is not visible on a
selection tree. Foodmart sample cubes are shown and working ok. I have added
role that allows access to my cube for everyone i.e. there should be enough
rights to access to cube.

On a server side I can see the cube just fine.

HELP

Turn on a few of the logging features in the registry and check the
logs. I would bet it is a security issue. Since you can see Foodmart
but not the others. I vaguely recall 1 occassion where a user could see
one cube but not another, after a bunch tests we just reinstalled Excel
and it fixed the problem.

List of registry keys that you can use to enable logging
http://support.microsoft.com/kb/q143180/

Steve Muise
Neudesic LLC

Also check what provider you are using. It must be the one for Analysis
Services 8.0.

The earlier one without the version number is the SQL 7.0 version and
for some reason works with Foodmart (I think because it was upgraded
from a 7.0 sample) but often does not work with cubes that were built
from the ground up in AS2k.

I have also seen rare instances of the 2 providers being cross linked so
it may be worth trying the other provider if you are indeed using the
8.0 version.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1127755464.489489.272180 (AT) g43g2000cwa (DOT) googlegroups.com>,
Steven.Muise (AT) gmail (DOT) com says...

Thanks, I will try those. I was actually using 7.0 version on a client-side
i.e. that might be the problem. What is the best way to install provider 8.0
to a client side? Just use Reporting Services Sp2?

"Darren Gosbell" wrote:

There are 2 files called PTSFull.exe and PTSLite.exe that come with SQL
Server and new versions are included with each SP. These are the client
side libraries for accessing AS2k. PTSFull includes the MDAC, PTSLite is
just the Pivot Table Services component that are required to access
Analysis Services.

Running either of these is how you install the OLEDB provider for
Analysis Services. It needs to be run on each client. (but it can be
scripted for a silent install if you need to push it out to a large
number of clients)

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell