@Human008
From the screen shots you provided it is not possible to see the dimensions of either the source or target modules.
An error is likely to be a mismatch of dimensions meaning that you need to map any differences in dimensions from the source to the target.
Therefore, list out the dimensions present in your source and those in the target and identify any differences.
- Time - is there a change in the time dimensions from year to month, month to day etc?
- Hierarchies - is the target set at a higher level in the hierarchy?
- Missing dimensions - are there any dimensions that are simply missing in the target that are present in the source or vis versa?
- Versions - does one module have versions and the other not?
Use system modules to map across these differences in dimensions. For time you could use MOTHVALUE() or YEARVALUE() or LOOKUP within a time systems module the relative parent. Similarly, with a movement down a hierarchy use a systems module dimensioned by the list present in the target to LOOKUP the parent present in the source.
Where there a simply missing dimensions build dedicated mapping modules containing the list present in the target. Use line items formatted as the target dimension that is missing and map each combination of target dimensions into the source list.
Where there are more dimensions in the source use SUM to aggregate the source data into the corresponding target dimension. Create a module dimensioned by the source lists and use a list formatted line item formatted to the list in which you will SUM the data into.
Good luck,
Chris
Chris
HeathcoteAndHerran.com
