Warning Query was changed! Element XXX no longer exists in structure
We have encountered this error when opening a query in Excel with BEx Explorer. When the query is opened in the web browser, this error does not display.
The query was changed to remove calculated Key Figures that were added to the query and do not exist in the BW cube. We did not encounter this error until after the query went to production. Go figure!
I saw something here regarding refreshing the workbook but I do not know how this is done or why. There are other queries in the workbook which have not been touched.
Can anyone provide some insight and help with dealing with this error?
PS. We are on B/W 3.5