Cross Referencing Between Lists - Dimension of mapping used for aggregation doesn't match any dimens
I'm taking our demand planners monthly forecast and converting it into daily then rolling it up into weekly buckets. I've successfully gotten us down to daily, using a fake timescale, added the week commencing date and I'm trying to do a SUM function with each day that matches the weekly period being added up. The problem I'm having is my module for weekly has different dimensions than daily. That is, when demand sends us over the forecast it's in a different SKU formulation than how we look at it.
We look at it as SKUCODE - SKU DESCRIPTION whereas they just look at it as SKU DESCRIPTION. We have some mapping in place already that was done by our consultants, but rather than calling them up I'd like to understand this for myself. I keep getting something like this "Dimension of mapping used for aggregation doesn't match any dimension of the source" Can someone explain this in layman's terms?