Convert To Formula
In excel 2007 I m using OLAP tool to convert my Pivot table to formulas and I m publishing(Excel Sheet format) those reports to my users after adding some more calculated columns to it. The problem which I am facing at the moment I have couple of hierarchies which are flexible, means in those hierarchies level values move from one to other for example I have GL structure with four levels
Level 1
Level 2
Level 3
Level 4
And values can move from level 3 and level 4, same like Customer can move from one city to other. I m really struggling how can I work around that problem because all my report are already using the old structure but by moving values in structures inside the DWH all my report which are using convert to formula now get screwed.
Can you please suggest me how can I get work around this problem
Thanks in advance
Qazafi