Clearing Data in ASO Cube in Oracle Planning and Budgeting Cloud Service (PBCS)

Have you ever had issues with clearing data in an ASO cube on a PBCS environment? Previously, there was not a way to automate the process of clearing data in an ASO cube. But now, with “Clear Cube”, you can clear data in many different ways in an ASO cube. You can now schedule to clear all data, clear all aggregations data, or clear partial data. This is very useful when you want to only clear certain pieces of the database in an ASO cube.
Why use Clear Cube?
Clear Cube allows you create a clear data job where you can reuse it for automation. For example, when you want to clear out the monthly data before loading actuals, you can create a partial clear data job and use substitution variables to control which month you want to clear out.
Watch the demonstration!