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

Rapid Clear Period Problem

edited Mar 14, 2019 12:47PM in Planning 16 comments

Summary

Iterative loads and how to remove originals quickly

Content

Hi,

 

we have a process where actuals are loaded via flat files to PBCS BSO cubes, and smart push is run to push data to ASO.

It works, but in times of closedown when everyone wants results yesterday clearing data from the BSO cubes is taking a long time. For one cube it is taking around 20 minutes.

To clear data we use a clearblock business rule, which is no more complex than fix(version, scenario, period)  clearblock all; endfix

I have looked at tuning this in our test system but the timings between test and prod are massively different, i.e. less than 5 minutes becomes 20+ minutes again test to production - when the data is the same (fresh clone of Production)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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