Loading Master Data into ODS

[Former Member]

Hi,

Can anyone tell me how to load the master data into the ODS?

Thanks

Yadav

Edited by: yadav on Apr 12, 2008 8:04 PM

[Former Member]

Dear Yadav,

Placing atleast one key figure like count means ,,,there should be atleast one key figure in ur ODS now,,,

So COUNT is a dummy key figure which helps u in the creation of ur ODS..

So creats an key figure info Object Zcount of type key figure..

At the update rules of ur ODS,,when updating that COUNT info object...place with a constant with value 1 and in the report hide that count..

Hope this helps u,,,

Assign points if needful..

Best Regards,

VVenkat..

[Former Member]

Dear Yadav,,

U can load the master data to ur ODS..

The Process is same as loading Transaction Data into ODS but..

1. U need to do flexible Update instead of Direct Update...

2. Maintain all the Attributes in ur DATA part...

3. The record on which Updation depends should reside in the KEY FIELD section.

But there is difference in loading master data to info object and ODS..

If loaded in Info Objects..REusability is there.

But in ODS no reusability...

Hope this helps u...

Assign points if helpful...

Best Regards,

VVenkat..

[Former Member]

Hi,

Could you explain the 3rd point clearly please?I am stuck in the 3rd point only.

Regards

Yadav

[Former Member]

Hi

It means,Your Main Master data object should be in Keyfields section and attributes you should keep in data fields..

Ex: If your master data is Employee and attributes are age,gender,address etc..

Then you should keep Employee in Keyfields and age,gender,address should keep in Data fields..

Hope it is clear..

Thanks,

Teja

[Former Member]

Dear,

In addition to what Ramkumar has mentioned, you need to use the Flexible Update infosource instead of the 'direct update'. This will allow the master data to be updated in the ods.

Thanks

[Former Member]

Hi Sriee,

why do u say instead of Direct update,load into Flexible??

Can u explain in detail what u meant by that???

[Former Member]

Dear Yadav,

Maintain Objects in the Key fields.

If the KeyField combination is same, then the data will be overwritten in the ODS.

Place the Attributes in Data Fields.

Maintain atleast 1 keyfigure like COUNT.

Regards,

R.

[Former Member]

Hi ,

Thanks for your reply.

I created master data using flexible update

Also I assigned the attributes under key fields.

What do you mean my atleast one Key figure Count has to be maintained?

Can you explain me clearly please?

Regards

Yadav

[Former Member]

u cannt load master data in ODS. u can only load trasaction data in ODS.

u can load master data for a infoobject. create a trasfer rule on ur infoobject and specify a datasource and load the master data.