Level mismatch in trying to bring data
Hi I have this scenario where I need to bring in data from
a source which is dimensionalized by Product L3 (leaf) level and Account to
a target which is dimensionalized by Product L3 (leaf) level and Area.
Mapping table has Product L1 (Top level of Product) and Account. It has Area as list formatted line item for mapping purposes.
If the mapping table would have only Account, then I could use SOURCETABLE.Lineitem[SUM:MappingTable.ListFormattedAreaLineItem]
However, since the mapping table also has Product L1 Top level as one dimension, It throws Level mismatch error.
Therefore checking to see how I can resolve this issue.
Any guidance would be appreciated.