OTBI - Cross subject area question
Summary
OTBI - Cross subject area join issueContent
Hi,
I am trying to build an analysis using 2 subject areas
Using Benefits - Enrollments Real Time and Workforce Management - Person Real Time and included Person number and dependent data from Benefits enrollment SA
and included fact columns from both the SA's as "Participant Enrollment Results"."# of Enrollments" and "Workforce Management - Person Real Time"."Person"."Person Count"
My requirement is mainly to show Benefits dependent data from Benefits Enrollment Subject area and Person Contact related info from Workforce Management -Peron Real Time subject area.
But the issue is , i am able to get the benefits dependent data properly ( if i have 3 dependents A & B &C for a person it is showing 3 rows for A & B &C ) ,