Skip to Content
author's profile photo Former Member
Former Member

How to combining 0customer master data which is having 4year historic data.

Hi Experts,

We had a requirement that :-

we need to combine three different customers(masterdata) let us say X,Y,Z in to one i.e. as X.

But problem is those customers is having already 4 years historic data along with transaction data in the Inventory and other two cubes.

Now problem is how to make changes in the customer master data for the previouse data which is already existing in the cubes.

Client dont want to delete the data and reload. any other idea to achieve this.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2011 at 07:01 AM

    Hi,

    Create a copy of the existing cube and load the data from the previous cube to this cube.

    While loading, write a code in such a way that if Yor Z as customer replace with X and then load the data to the other cube.

    Then do the reporting on the new cube which we have created and loaded the data, or else delete the data in the old cube and reload the same from old cube to new cube with no logic.

    Regards,

    Suresh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2011 at 09:46 AM

    Hi,

    There are three options

    1. Yiu can create copy cube

    2. You can create new cube and reload the data and while loading you can write look up logic.

    3. You can add new field in existing cube and use remodelling concept to populate it.

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.