Cross Referencing Between Lists - Dimension of mapping used for aggregation doesn't match any dimens

Hi All,

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?

Accepted answers

Tiffany.Rice

You will need to define the relationship between the two lists using a System module. Your SUM formula would then reference that mapping (module dimensioned by one list with a mapping line item formatted by another list). This can be a manual input or formula driven if the two lists have a common linkage. If you are trying to match based on text descriptions than you may try using the FINDITEM() formula.

Here is some additional info on System modules: https://learning.anaplan.com/course/view.php?id=982

All comments

Tiffany.Rice

In layman's terms that error just means the modules are based on two different lists so there isn't a logical summation. Your SUM formula will need to include conditions for both the Day to week mapping as well as the SKU mapping.

jedge@dsi.com

Yes I understand that, what I'm trying to figure out is how to cross reference the 2 types of SKU codes so it will aggregate appropriately. Any thoughts?

Tiffany.Rice

Here is some additional info on System modules: https://learning.anaplan.com/course/view.php?id=982

rob_marshall

jedge@dsi.com ,

Quick question, why are you using a fake time list at the day level and not the real time scale?

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…