Re: Change OLAP Data Source in Excel Pivot Table

You can't.
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@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"KarenJ" <KarenJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DE3D5181-DB1C-45BE-BAEB-C257A550962B@xxxxxxxxxxxxxxxx
> Hi All,
>
> 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.


.

Relevant Pages

  • Re: Timeout problems due to huge Fact Table
    ... I've also experienced very poor performing queries that the cube itself has ... of dimensions & with 'materialize' set on the relationships in the dimension ... to fill your cube you are using a very complex query instead of a table. ... level and adding required table in the database. ...
    (microsoft.public.sqlserver.olap)
  • RE: Problem processing partition
    ... I am not sure if you tried to write-disable the original cube, ... the original database, and restore the database again to test. ... Does the original partition exists in the restored cube? ...
    (microsoft.public.sqlserver.olap)
  • Re: Change OLAP Data Source in Excel Pivot Table
    ... You can alter the cube name of the pivot table. ... In de connectionstring you can set servername and database name. ... partition and dimension are driven based on ...
    (microsoft.public.sqlserver.olap)
  • Change OLAP Data Source in Excel Pivot Table
    ... I need to connect to a new cube. ... database does not exist and lets me connect to a new data source. ... particular cube or partition within the database. ... named the same as the database, Excel cannot find it. ...
    (microsoft.public.sqlserver.olap)
  • Re: Total disaster recovery
    ... MS Exchange installation and databases, SBS monitoring and Companyweb. ... The partition was totally lost, all existing backups of this partition also ... I have managed a partial re-installation, with only a new database required ...
    (microsoft.public.exchange.admin)