Question Re: Enhance Data Source 0Customer_Attr in Technology Q&A

Enhance Data Source 0Customer_Attr

Former Member — Tue, 21 May 2013 10:37:05 GMT

Hi All,

Earlier we had done INIT load for Master Data 0customer_attr and we are doing Delta Load on daily basis. . Now we have enhanced Data Source 0Customer_attr with 2 new fields : 0SALESORG and 0CUST_GROUP. 0customer Infoobject is being used in many InfoProviders . We don't want to delete data from cubes , as it is a tedious job . Please let us know is there is any solution to populate the data for above new fields , without re-initializing 0customer_attr.??????

Regards,

Amba

Re: Enhance Data Source 0Customer_Attr

former_member182470 — Tue, 21 May 2013 10:51:56 GMT

Hi,

If you do not want historical data for two new fields, then you can just do init w/o transfer for your datasource. Your subsequent delta will pick delta to all fields along with new fields also.

Are these two fields are DIsplay/Nav Attr to 0Customer_attr? You need not to worry about cubes data at all. Because, Master data will be outside the cube(extended star schema concept).

You just need to decide to a full load for this master data. I feel you could do this without disturbing the cube data.

Regards,

Suman

Re: Enhance Data Source 0Customer_Attr

Former Member — Tue, 21 May 2013 11:00:44 GMT

Hi Suman,

We need historical Data for the new Enhanced Fields . These are maintained as navigation attributes in 0customer.

Regards,

Amba

Re: Enhance Data Source 0Customer_Attr

former_member182470 — Tue, 21 May 2013 11:03:00 GMT

Then, please do init with transfer to this 0customer. This will suffice your requirement

Re: Enhance Data Source 0Customer_Attr

Former Member — Tue, 21 May 2013 11:41:30 GMT

Hi Suman,

Thanks for the reply..

We have 2 infopackages, one for INIT load where we have selected initialize delta process with data transfer and for delta load we have selected delta process . Considering the above scenario can u please tell us the steps in detail.

Regards,

Amba

Re: Enhance Data Source 0Customer_Attr

Former Member — Tue, 21 May 2013 12:23:18 GMT

Hi Amba,

1.) Load data using Init with data transfer with your Init infopackage

2.) Once the init is done, run your delta info package which will start the delta's.

3.) Run attribute change run.

You are loading data only to master data info object. You are not modifying the cube in any way. So you can forget about the cube data.

Cheers,

Krishna Vadlapatla

Re: Enhance Data Source 0Customer_Attr

former_member182470 — Tue, 21 May 2013 12:26:15 GMT

Hi,

Step 1: Goto Init Infopackage-->Scheduler Menu-->Initializations options for source system-->Delete the request

Step 2: Run this infopackage by using init with transfer

This will bring all the data freshly to your 0customer. Run ACR(Attribute Change run). After this, your delta infopackage will come into the picture. This infopackage should be in your process chain

Regards,

Suman

Re: Enhance Data Source 0Customer_Attr

Former Member — Wed, 22 May 2013 04:24:54 GMT

create another infoprovider and in that infoprovider add the infoobjects which you have appended for the ds 0cust_attr,

and now load the data to this infoprovider and create multiprovider on the top of the old existing infoprovider and the newly created infoprovider.

hope u got it,

Re: Enhance Data Source 0Customer_Attr

Former Member — Wed, 22 May 2013 05:12:16 GMT

Hi ,

0customer_attr is master data , if you are adding two fields , no problem. Cubes data is transaction data , it picks master from 0customer .

we do delta update in masters , just for reducing uploading time . Because in full upload it deletes all the data & upload.

There is no need do any extra job , just add two additional fields in 0customer-Attr . Check it you may require to change attribute run .

Regards,

Anand Mehrotra.

Re: Enhance Data Source 0Customer_Attr

Former Member — Wed, 22 May 2013 05:57:09 GMT

Hi Suman,

Thanks for the Reply... Issue is resloved ...

Regards,

Amba

Re: Enhance Data Source 0Customer_Attr

former_member182470 — Wed, 22 May 2013 08:07:42 GMT

Hey good to hear that..Good day