OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real Time
Summary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and dimension for a particular month. Filtered for posting status code = P, accounting period (Jul-25), JE source = projects, accounts 4-9 (P&L), calendar set (RU Calendar [main calendar] and year 2025. Fund type is one of our GL dimension (secondary balancing segment)
When adding accounting class code, performance goes from about 5 seconds to over 5 minutes.
How can good performance be achieved from this subject area after adding accounting class code? OTBI analysis does not perform well after adding this, is there any other indexed field I can add to increase performance?