Summary:
Content (required):
Hi Team,
There is an issue while joining two Subject Areas related to Procurement and Payment (trying to join below subject areas as in attached file : PROCSubjectAreas.png).
Requirement – Need to subtract Approval Date , Payment Date in one OTBI analysis which are being fetched from two different subject areas.
Issue : Fetching undesired data in the OTBI when I join below two subject areas in one analysis. {Procurement and Payment related Subject Areas}
I have done below checks while joining two subject areas:
1)Have a common folder between 2 Subject Areas of least granular level (i.e. supplier)
2)Added one measure column from each subject area
3) Checked the dimensionality check box
4) Also added columns from two subject areas
--Please validate and let us know your inputs on the above issue.
-Sridhar
Version (include the version you are using, if applicable):
Oracle Fusion Applications - 22B
Code Snippet (add any code snippets that support your topic, if applicable):
