OTBI - Joins between Procurement and Payment related Subject Areas
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
Tagged:
0