tomas_mbacz
We have just migrated a cube from AS2000 to AS2005 using the migration
wizard. As a result of this migration, some of the dimensions are now renamed
and under AS2005 we cannot rename them to the same name they had under AS2000
(the dimension names under AS2000 contained "." in them).
Exemple: "order date.YQMD" --> "order date YQMD"
We use Excel 2003 Pivot tables to access to the cube data. When the pivot table refreshes the data for the first time from the newly migrated cube, it "loses" the renamed dimensions (there are typically about 6 concerned dimensions per table).
My problem is that this renaming affects several dozens of Excel 2003 Pivot Table
files used by multiple users (unfortunately, each user uses their own copy of
an Excel PT spreadsheet). And therefore asking each user to manually add back
the dimensions in their pivot table is not a good plan.
My question is - is there a way how to change the name of the dimension/hierarchy/members in such a way that the Excel file considers the dimension to be the same as before the renaming
Does anyone have any experience on how to solve this puzzle in Excel (VBA code which would change the "definition" of the Pivot table before refreshing it ).
Thank you for any ideas.
Tomas