nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Employee Address Historical Data

Ulitka

Hi! How can I create an OTBI analysis that displays an employee’s full home address history, rather than only their current home address?

Find more posts tagged with

Analytics

HCM Analytics Content

OTBI

Accepted answers

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/28179/employee-address-historical-data

Hi Ultika,

I don't think you can pull address history in OTBI. You will need to build a BIP report.

Person Address History — Cloud Customer Connect

Worker Address History in OTBI! — Cloud Customer Connect

Thanks.

All comments

Mohammed Rafi

Hi @Ulitka

You need to use the subject area,

Workforce Management – Worker Assignment Real Time

Add the columns from the Person Address folder:

Address Type,
Address Line 1
City
State,
Postal Code
Country
Effective Start Date
Effective End Date

Add a filter on Address Type = "HOME".

Ulitka

https://community.oracle.com/products/oracleanalytics/discussion/comment/74946#Comment_74946

Hi Mohammed, this would only show me the current address, or an address at the chosen date. But I need a history of addresses during a period of time.

Mohammed Rafi

Effective Start Date and Effective End Date these two columns are important to show history rather than the current record.

Go to criteria tab then Filters and then remove filters such as
Effective Latest Change = Yes
Effective End Date is after current date
Current Record Flag = Y

Please make a note do not filter on effective date unless you want a specific timeframe.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/28179/employee-address-historical-data

Hi Ultika,

I don't think you can pull address history in OTBI. You will need to build a BIP report.

Person Address History — Cloud Customer Connect

Worker Address History in OTBI! — Cloud Customer Connect

Thanks.

Upcoming Event

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders