Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

in Financial Consolidation and Close 24 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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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