Content of different email fields in OTBI

szoerner

We noticed that the email data that we get for the learners from OTBI is
inconsistent and would like to know where those differences may come
from and which OTBI email column we should use when generating
mailing lists for learners.
We use the following 3 OTBI subject areas:

1. Subject area "Learning Records":
   Our main subject area which we use for reporting about training
   completions, training times etc.
   
2. Subject area "Learning Management":
   We rarely use this subject area as it misses some columns like Offering
   Language and doesn't allow well to differentiate between the enrollment
   situation on the offering level versus the enrollment situation on the
   course level for individual learners.
   
3. Subject area "Worker Assignment":
   We use this subject area in order to create reports which are then used as
   the basic building block for Global Access Groups and Learning Initiatives.

While the email data for individual employees seems to be identical in
the subject areas "Learning Records" and "Learning Management", the
data in "Learning Records" is sometimes empty.

Maybe someone from the community can give us feedback on the following questions:

• Where does OTBI draw the data from that appears in the column
  "Assignee Primary Email Address" in the subject area "Learning
  Records"?
• Why is the content of the field sometimes empty for the
  learners even though there are email addresses for them in the other
  subject areas?

We look forward to your reply!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26723/content-of-different-email-fields-in-otbi

Hi @szoerner,

Welcome to the Oracle Analytics Community!

Please take a look into the following post where you can get the OTBI Subject Area to Database Lineage document which will be helpful to understand which column is coming from where.

HCM OTBI subject areas to database lineage mapping spreadsheet — Cloud Customer Connect

Hope this help.

Thank you.