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

GL OTBI report with filter on segment tree code running very slow

edited Dec 17, 2018 2:26PM in Reporting and Analytics for ERP 3 comments

Summary

GL OTBI report with filter on segment tree code running very slow

Content

We have a few custom GL OTBI reports that were running fine until a recent refresh of the environment.  They were running and returning the expected results pretty quickly.  But, after a recent refresh of the environment, all the reports are running very slow and sometimes don't complete and throw up error messages.  On investigation, we found the performance issue is caused by filter conditions on the GL segment columns.  As a test, we removed these filter conditions and the reports run fine.  So, there is something (index etc.) missing on the segment columns/tree code etc. after the environment refresh

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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