I created a planning level at the MTHPRODLOC level and copied that planning level to create PERPRODLOC (Month weight distribution)
I assigned MTHPRODLOC to a key figure and loaded values to it. I changed the baseplanning level of the key figure to PERPRODLOC. After which, my data was lost. I'm trying to switch back to the original planning level. Could you advise me on how to retrieve that data?
Once you have changed the base planning level of the KF from MTHPRODLOC to PERPRODLOC the stored data will be wiped. Also since you have changed the KF from a time dependent planning level to a time independent planning, hence the data is lost for ever and you wont be able to view that KF in the excel UI as well.