Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

standard Income Operating Statement by Division

Question
15
Views
0
Comments

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?

.