Financial Reporting integration query optimization


This fix improves query performance during Fact integrations


The FINANCIALREPORTINGGENERALJOURNALREVERSALS view produces Cartesian products and with certain datasets this can have significant impact on the cost of the Fact integration. Applying this hotfix replaces the join that caused the Cartesian product with a where-clause, making the overall query more efficient.

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.