Hi, we are trying to write a query which returns a standard Income Operating Statement by Division, combining financial data (actuals, budgets, encumbrances) with hierarchical metadata (funds, departments, accounts) to produce a comprehensive fiscal report.
The query is causing the performance issue. attached the query, please share the query if anyone has achieved this?
.
