INV 01 Shipping Time Week

preetdhar80

Hi I'm stuck with this formula for last 2 hours. Pls help clarify what is wrong with this?

INV01 Shipping Time Week - I'm getting "Format of mapping used for lookup doesn't match any dimension of the source"

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP: Shipping Method]

Shipping_Time_Week_134711.PNG

Accepted answers

All comments

KirillKuznetsov

@preetdhar80

First of all you have to compare the dimentions between the source (TRA01 Shipping Metrics by Week) and the target (INV01 Inventory Ordering). The different dimentions have to be mapped in such a way that you could have a table with a list of elements of the one dimention to be put against elements of another one.

Could you please share which dimentions are in the source module?

In target you have SKUs, so each SKU has to be mapped to an element from a list used in the source module using list-formatted line item.

preetdhar80

Hi, this is part of the Anaplan 3.3.5.2 > Shipping time weeks data calculation. Most solutions suggested on the community suggest the formula I had earlier shared but somehow it does not work.

TRA01 has
P2 Products & Shipping Methods as pages.

Shipping Time (weeks) and Cost per 1000 units as line items.

Time in weeks.

INV01 is attached.

INV01_134717.PNG

KirillKuznetsov

@preetdhar80

TRA01 has two dimentions on your screenshot:

Time (weeks) and a dimention with Nutzo Bar_EN element in it. Do you have a line item somewhere in your model where this Nutzo bar_EN (it's dimention) is mapped to SKU elements. Like below or anything similar??

Product	SKU List
Nutzo bar_EN	SKU1
Nutzo bar_ES	SKU2
Nutzo bar_IT	SKU3

This will be concidered as your mapping table and all you would have to do to pull the data from the source is to refer to this mapping table using SUM function.

preetdhar80

Nutzo bar is the Product and Nutzo bar_EN is the SKU.

I have also attached other two modules I' referencing to get the correct data. Somehow I think TRA01 has an issue, if you see the yearly number for shipping time is exorbitantly high.

DAT02_134724.PNG

TRA01_134724.PNG

preetdhar80

I found the issue. In blueprint mode the 'Applies to' field was blank (instead of a '-' ) and that resulted to multiple incorrect calculations across modules.

Anaplan is amazingly funny 🙂

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…