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

OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real Time

in Reporting and Analytics for ERP 1 comment

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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