Data Model link between FSCM and OBIEE latency

Summary:

Data Model link between FSCM and OBIEE too slow.

Content (please ensure you mask any confidential information):

When I create a financial data model that links the FSCM data model with the OBIEE data model and several other data models, the report runs very slowly when querying over a long period (e.g., from January 1, 2024, to today's date). I need to schedule the report, but it takes about two hours and sometimes more to return the data for only 1 business unit. The report gets the taxes and their related lines in General accounting.

Then the GL data model is linked to payables and receivables to get the invoices and their related data.