INVO1 SHIPPING TIME(WEEKS)

Manisha12
New Contributor

INVO1 SHIPPING TIME(WEEKS)

Hi,

I am getting an error putting this formula to the shipping time(weeks).

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

 

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

can someone help me with this?

6 REPLIES 6
vivekdasgupta
New Contributor

Re: INVO1 SHIPPING TIME(WEEKS)

Hi Manisha,

 

Try the below:

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

 

Regards,

Vivek

Manisha12
New Contributor

Re: INVO1 SHIPPING TIME(WEEKS)

Hi vivek,
I have tried the formula,you have given.It is accepting the formula but not getting any data.

Thanks,
Manisha
jobr01
Occasional Contributor

Re: INVO1 SHIPPING TIME(WEEKS)

I have the same issue. There is no data in the TRA01 module. Should I import anything? can't find this information in the sprint.

Manisha12
New Contributor

Re: INVO1 SHIPPING TIME(WEEKS)

Hi,

I have got the data in shipping time(weeks).In the TRA01 module, try applying the yearvalue() function ,you will get the data.

 

-Manisha.K

jobr01
Occasional Contributor

Re: INVO1 SHIPPING TIME(WEEKS)

I managed to solve it but thank you anyway 🙂

JBeauchs
Occasional Contributor

Re: INVO1 SHIPPING TIME(WEEKS)

I am having the same issue, TRA01 has no data in it. Where was that supposed to come from?