Hi,

Running Windows 2000, SQL 2000 + Analysis Services. I have also
installed Service Packs 3a. I am running Office 2000 Professional.

The default Farmsfood Database and Cubes have installed as normal. I
can browse each table when on the Schema tab and review the data. Each
Cube can be processed individually.

However as soon as I switch to the data tab I get the "Unable to
display Cube until processsed"(Unspecified error) message.

The one problem I did note was that if I was to process all cubes from
the menu tree the process fell over at the last hurdle telling me that
the form foods data was not initialised?

Can anyone help?


thanks in advance

install SP3 OLAP client components on office worstation and stations with OLAP console

Or go into Add/Remove Programs and do a 'repair' on Office. This is a
well-known bug that is being caused by Office replacing some but not all of
the Analysis Services rlls. So you end up with 1/2 Office components; 1/2 AS
components. So you can fix it by either updating AS (by going to SP3 --
which you should do anyway) or by 'repairing' Office (by using Add/Remove
Programs).
Hope that helps.
--
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.


"Alex" <alex_priv (AT) interia (DOT) pl> wrote

Hi

Thanks for the feedback. I have already tried the approach of attempting to repair "office" and re-install "AS" but I'm still getting "unable to Browse Cube" error message. :

I'll keep plugging away though, thanks again...