Cannot clear all data from old scenarios-years
JWAGSMay 25 2010 — edited May 28 2010We are on 9.2.1 and are trying to clear old forecast and budget scenarios from prior years. Our HFM admin used clear data on the specific scenarios/years and also used a rule to remove the data from base level entities. Then ran consolidations to remove values from the parent entities. However, since we also have values in other currency values (like entity currency adj, parent currency adj, etc) we cannot seem to get rid of the data. I analyzed the data in SQL and there continues to be a lot of data even after all these steps.
I had heard from other admins that a direct deletion of data from the SQL tables had been done in the past and that this was much more efficient and effective. Plus it's much easier to delete journal entries too.
Please advise if we are doing something wrong or of any suggestions to clear the data using delivered functionality rather than deleting directly from the tables.
Thanks
Jeff