GL OTBI report with filter on segment tree code running very slow
Summary
GL OTBI report with filter on segment tree code running very slowContent
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
0