Publishing Pivot table - newbie -

[Vanessa Berni]

Hi all,
I' ve created my cube with Analysis Services 2000; the data are stored in a
Sql Server 2000 DB.
If I create with Office XP a pivot table related with my cube all works
fine. When I try to publish the same page (using "save as web page" in my
excel XP) I get the following error : "the query could not be processed o
the data provider didn't supply any further information".

(I have no problem with publishing the tutorials cube!)
Can you hep me?

Thanx...

Vanessa

 

[Daniel_Ricker]

Could you explain what you mean by "created my cube with
Analysis Services 2000"?

When you say "the data is stored in a SQL Server 2000 db,
it sounds like you are using a local cube instead of the
AS Server.

If you are using a local cube, then the problem is
probably with how AS Client accesses the cube. When the
AS client bits access a local cube file, it is locked for
single use and not readable by any other client. This is
because client cubes can be refreshed and the entire
structure of data in the cube file changed.