Excel problem when upgrading from SSAS2000 to SSAS2005

Excel problem when upgrading from SSAS2000 to SSAS2005

Hi!

 

Our customers have build a large report-base on top of our SSAS2000 OLAP 
cubes using Excel Pivot tables as a client. When we recently upgraded our 
cubes from SSAS2000 to SSAS2005, we met some unexpected problems in the Excel 
reports: 

 

When referencing a cell in a pivottable with dataconnection to SSAS2000 
cube, the formula looks something like this:

=GETPIVOTDATA("[Measures].[Value]",DATA!$A$6,"[Plan]","[Plan].[All 
Plan].[Actuals]")

 

When referencing a cell in a pivottable with dataconnection to SSAS2005 
cube, the formula looks something like this:

=GETPIVOTDATA("[Measures].[Value]",DATA!$A$6,"[Plan]","[Plan].[Plan 
Name].&[Actuals]")

 

As you can see, it seems like the dimension-reference is changed. This 
offcourse breaks all our customers reports when changing datasource from 
SSAS2000 to SSAS2005. The upgrade was done using the upgrade wizard, and none 
of the dimensions/cubes have changed names or structures. 

 

Have anybody else seen this problem?

date: Thu, 28 Feb 2008 01:49:01 -0800 author: Espen Albrektsen am