×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Customer Address Change

Customer Address Change

Customer Address Change

(OP)
We have a requirement where when a customer changes his/her address the OBIEE report has to capture the previous address and the changed address. We are going against the Transactional Tables. Can someone guide me as to what steps I need to follow in EBS..

Regards

RE: Customer Address Change

This is a Type2 slowly changing dimension. That means that your DimCustomer dimension table must store different versions of the same record.

For this, I use a row_effective_start_date and row_effective_end_date to indicate which record was active an any point in time. The first version of a record would have a very early start-date (I use 01-Jan-0050). The last record would have a very late end-date (I use 31-Dec-9000). Every version except the last would have its end-date equal to (or 1 day earlier than) the next record's start-date. (In my case they keep them equal)

When you look for the record you want, you must specify the customer id and the date that you want to find the record for (for the purpose of obtaining the correct surrogate key). Once the surrogate key in your fact table points to the desired DimCustomer record, you won't have to worry about finding the right record in your reporting.

If you choose to maintain equal dates for your end-date and start-date of the previous/next records, you can end up finding 2 records if the search-date supplied falls on that boundary. In my case, I merely use the later of the two records.

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close