Change OLAP Data Source in Excel Pivot Table - 06-06-2005 , 05:08 PM
I have an existing pivot table (created by someone else and sent to me) that
I need to connect to a new cube. When I Refresh, Excel tells me that the
database does not exist and lets me connect to a new data source. The wizard
only lets me select to the database level, and does not let me select a
particular cube or partition within the database. Also, if the cube is not
named the same as the database, Excel cannot find it. Ideally, I want to
select a particular partition and will have a separate workbook/pivot table
for each partition. I am running Excel 2003 SP1 and Analysis Services
8.00.382. How can I do this?
My workaround is to create a separate database for each partition and to
connect each pivot table to a database. This seems clumsy and contrary to
the design of Analysis Services.
Thanks in advance.
Re: Change OLAP Data Source in Excel Pivot Table - 06-06-2005 , 07:05 PM
Like SQL Server RDBMS, a "connection" consists of the server and the
database information. The cube, partition and dimension are driven based on
the query itself.
You have to modify the query, i.e. set a different slice to select a
different partition, etc.
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"KarenJ" <KarenJ (AT) discussions (DOT) microsoft.com> wrote
Re: Change OLAP Data Source in Excel Pivot Table - 06-09-2005 , 02:00 AM
Instead of creating all different databases you can create different cubes.
You can alter the cube name of the pivot table.
In de connectionstring you can set servername and database name.
in the commandtext you can set the cube name.
"Dave Wickert [MSFT]" wrote: