Hi Guru's ,
Can u Explain what are Key Field's and Data Field's in ODS,and How they work.
Thanx in Advance.
An ODS key fields forms a unique combination of chars according to which data in the ODS will be summed up. Data fields are additional fields, chars or key figures.
For example, you have the following key fields:
Doc No, Doc line item (item no in the doc) and you load the following data:
Doc# Item# Amount CALDAY
1234 1 100 26.09.2005
1234 1 150 27.09.2005
1234 2 300 27.09.2005
1235 1 400 27.09.2005
The first two rows with the same key fields (1234-1) will be aggregated and into ODS will go amount of 250.
What I said is true if for Amount key figure the Add option is set.
But if you set an Overwrite option, then the second record will overwrite the first one and only amount of 150 will go to ODS!
But if CALDAY is also a key field, then into ODS will go all records without any aggregation, because key fields combination is different for all records.
So, ODS key fields choice and KFs settings are very important for data aggregation in the ODS.
U can check the URL which will be much helpful to u.
The characteristics will be referred as the key fields in the ODS. So u wil place all the charateristic info objects in the Key fields section. and the Key figures in the data fields section.
Here in ODS u can maintain--
You can create a maximum of 16 key fields
You can create a maximum of 749 fields
You can use 1962 bytes (minus 44 bytes for the change log)
You cannot include key figures as key fields
Assign points if it helps..
The key fields and data fields in the ODS plays a significant roles.
As these fields contains the characteristics and key figure information respectively.
When u design the ODS then u have to place ur Char info objects in the Key fields and the Key figure Info objects in the data fields.
for more info refer..
Hope it helps-
Assign poins if it helps.
Message was edited by: vishnuC