Skip to Content
Former Member
Jun 08, 2008 at 02:28 PM

BI 7 - Multiple loads to single ODS : Aggregation problem


Hello everyone,

I have problem concerning multiple loads to a single ODS. Several datastores contains different fields concerning the employees. I combine all these fields in one datastore to which I connect all the other datastores. The key of this datastore is basically the employee. I load all these fields from different datastores and after activating all the requests at the same time I would expect the datastore to aggregate according to the employee so all the fields are filled for each person in a single record.

I've done the same on BI 3.5 and it works great, but on version 7 (patch 12) only the fields of the last activated request are filled, the others are empty.

Does anyone have an idea what is going on? I'm using a Standard ODS, with only 'Set Quality Status to 'OK' Automatically' flagged. I've tried it also with 'SIDs Generation upon Activation' flagged, but the result is the same.

Thank you for your help