## LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Occasional Contributor

## LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

I am currently on sprint 3. Even though I have almost figured out every formula in INV 01. I am not able to get the formula for pulling data for shipping times weeks. I am currently using the formula:

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

1 ACCEPTED SOLUTION

Accepted Solutions
Master Anaplanner/Community Boss

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Hi @Parth1106,

I would suggest following approach, first compare dimensions between two modules

TRA01 Shipping Metrics by Week: Time, P2 Products, Shipping Methods

INV01 Inventory Ordering: Time, P3 SKU

Both modules are on weekly level, therefore that goes directly.

You correctly used LOOKUP: 'SYS08 SKU Details'.Product to go from P3 SKU to P2 Products.

However you are still missing something, try to compare modules and figure out what is missing in your formula.

Let me know if you have additional questions, I will try to help!

12 REPLIES 12
Master Anaplanner/Community Boss

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Hi @Parth1106,

I would suggest following approach, first compare dimensions between two modules

TRA01 Shipping Metrics by Week: Time, P2 Products, Shipping Methods

INV01 Inventory Ordering: Time, P3 SKU

Both modules are on weekly level, therefore that goes directly.

You correctly used LOOKUP: 'SYS08 SKU Details'.Product to go from P3 SKU to P2 Products.

However you are still missing something, try to compare modules and figure out what is missing in your formula.

Let me know if you have additional questions, I will try to help!

Occasional Contributor

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

HI @filip.sypniewski, I do understand that I am missing the reference to the shipping method in my module. I earlier used the following formula:

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center Details'.Default Shipping]

But on using this I am getting the following error:

Dimension of mapping used for lookup doesn't match any dimension of the result.

I have tried with every possible module in the lookup function still I am not able to map the shipping modules in this formula.

Thabks

Master Anaplanner/Community Boss

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Hi @Parth1106,

you are correct that you also need to include Shipping Method dimension in your Lookup.

So you need to match your INV01 module with TRA01 module which contains this dimension.

Let me know if you managed!

Occasional Contributor

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Thanks @filip.sypniewski  I got it. Thanks a lot for your help

New Contributor

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Hi @Parth1106, I am stuck at the same point. Could you pls help.

Occasional Contributor

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Hi @yagupta ,

Can you please specify at which point you are stuck.

New Contributor

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Hi @Parth1106 its resolved now. Thanks a lot for your response.
Occasional Contributor

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

Hi I have tried the same exact formula and gotten the same error message: "Dimension of mapping used for lookup doesn't match any dimension of the result"

Any updates on how to do this? Its the last formula I need for this activity

New Contributor

## Re: LEVEL 2 - Sprint 3 Shipping Time Weeks INV01

HINT, you have the Shipping Method in the same model. I was also struggling with that. You can refer to the example in EXAMPLE of LOOKUP in the

Regards.