Enhance Data Source 0Customer_Attr

[Former Member]

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

[former_member182470 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Suman,

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

Regards,

Amba

[former_member182470 · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[former_member182470 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Suman,

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

Regards,

Amba

[former_member182470 · Accepted solution]

Hey good to hear that..Good day

[ravi_chandra3]

Hi

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,

[Former Member]

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.