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?