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?

Accepted answers

All comments

vivekdasgupta

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

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

Thanks,
Manisha

jobr01

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

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

I managed to solve it but thank you anyway 🙂

JBeauchs

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

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…