Best practices for adding a list dimension without modifying the existing structure.

MisumiDeveloper

The target module has an additional list dimension compared to the source module. Is there a way to automatically aggregate the source data into a specific dimension of the target?

Due to legacy reasons, the current module lacks a specific dimension. However, to enable budget vs. actual comparisons, we have to add a new list dimension, which results in data duplication across the new dimension. Manual adjustment is quite cumbersome.

jepley

Yes, it just depends on where you want it to go. If just to one list member you can use the below. If you are using a more complex spread then you'll have to get trickier— show an example if you have one.

Left table shows your source with no dimensions (or one fewer). I also put the selected mapping here (list formatted) since there is no dimensionality, but if there is, put this in a non-dimensionalized look-up module. On the right, the first line item shows what you have now, the second shows it directed to your chosen list member.

Is this what you're looking to do?