How to clear stored QTD and YTD from normal consolidation process
SummaryWe are leveraging the Consolidate by View to help with performance and DB size and accidently ran the normal consol which stores data at QTD and YTD
Due to consolidation performance and trying to keep the size of the application down, we have migrated to the FCCS extended dimensionality and only leveraging consolidate by view and translate by view on FCCS_Periodic member. I by mistake ran the normal consolidation process for Mar 2021 which now has data at the store QTD and YTD.
I tried running a full clear statement via clear cube and then running that normal consolidation and translation to try and get that cleared out but that does not seem to have worked. Is there a better way to try and get rid of the stored data at QTD and YTD, or am I stuck having that data in the application now going forward?