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
Making Period and Movement Dense: Report Performance Issues with QTD/YTD Views — 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

Making Period and Movement Dense: Report Performance Issues with QTD/YTD Views

Accepted answer
131
Views
22
Comments

Hi everyone,

I am looking into making Period and Movement dense in our FCC application and am finding that the QTD/YTD View performance is unacceptable. 1-second Smart View pulls now take 7 to 10 seconds, not to mention larger pulls take extremely long.

I checked the performance troubleshooting document, including adjusting Solve Orders as needed, but the performance is still really slow. I also tried making parents in one of our custom dimensions Never Share, but when I ran Consolidation/Translation, top-level values still showed as $0.

Has anyone found a way to get the QTD/YTD Views to perform well with DSO enabled? Are there workarounds for those? It would be nice to enable this option since it reduces our application size by about 80%, but I'd prefer not to make our users sum up periods using Excel formulas

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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