We usually create and change queries in Production, however, recently we transported a query up from Development and it overwrote and an existing Calculated Key Figure in Production.
When looking at the Calculated Key figure in production we changed it back to the way it was before the transport using BEx but when the query is run the results are still based on the Calculated Key figure that was transported from Development. So it seems there must be two Calculated Key figures stored in Production with the same technical name but with different GUIDs.
Does anyone know what table(s) hold this data and would it be possible to change it to point to the correct Calculated key figure and possibily delete the incorrect Calculated key figure that was transported up from Development?
Thanks in advance,
Ron