Below are the steps am planning to start with in constructing this:
- Consider Cost Source Master data as a transform based on the defined keys between the two data sets from source to target Ex: Cost source to Labor, Cost Source to Other Cost Pool, Cost Source to Fixed Assets will get the matching&non matching records based on the keys
Ex: Cost Source Master data transform it by naming as unallocated Cost source: Labor Key check&&Other Cost Pool Key check&&Fixed Assets Key check (this can be achieved by looking up to the source to the target) : If none of the three targets are not matching with the key – This is considered as unallocated for Cost source.
This procedure has to be followed at each source object by creating an unallocated Object name, consider all the unallocated objects and append it to one newly created modelled object.
- Unallocated costs at ITRT
- Unallocated costs at Business Services
- Unallocated costs at Business Units
Inputs & any other short cuts in achieving this!!Much Appreciated!!