Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Employee Address Historical Data

Accepted answer
44
Views
4
Comments
Ulitka
Ulitka Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Forum

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

Tagged:

Best Answer

Answers

  • Mohammed Rafi
    Mohammed Rafi Rank 4 - Community Specialist

    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
    Ulitka Rank 3 - Community Apprentice
    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
    Mohammed Rafi Rank 4 - Community Specialist

    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.