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