Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to clear stored QTD and YTD from normal consolidation process — Cloud Customer Connect
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
22
Views
4
Comments
edited Apr 6, 2021 2:21PM in Financial Consolidation and Close 4 comments

Summary

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

Content

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.

Register

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