You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI - Cross subject area question

edited Jul 30, 2020 4:11PM in Reporting and Analytics for HCM 4 comments

Summary

OTBI - Cross subject area join issue

Content

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 )  , 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!