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

[Former Member]

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.

[Former Member · Accepted solution]

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

[former_member188080]

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