You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to clear stored QTD and YTD from normal consolidation process

Accepted answer
edited Apr 6, 2021 2:21PM in Financial Consolidation and Close 4 comments


We 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?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!