topic Need help using LOOKUP or SELECT function in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105417#M25033

Hi,

 

I'm trying to create a line item in the target module that pulls in the values from the source module given a certain day.  Attached are screen shots of the modules. Please advise. 

 

Target Module 

neg177_0-1618597793192.png

neg177_1-1618597859047.png

 

Source Module

neg177_2-1618597919027.png

neg177_3-1618597961100.png

 

 

Thank you 

 星期五,2021年4月16日18:33:05格林尼治时间 neg177 2021 - 04 - 16 - t18:33:05z Need help using LOOKUP or SELECT function https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105417#M25033

Hi,

 

I'm trying to create a line item in the target module that pulls in the values from the source module given a certain day.  Attached are screen shots of the modules. Please advise. 

 

Target Module 

neg177_0-1618597793192.png

neg177_1-1618597859047.png

 

Source Module

neg177_2-1618597919027.png

neg177_3-1618597961100.png

 

 

Thank you 

 星期五,2021年4月16日18:33:05格林尼治时间 https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105417#M25033 neg177 2021 - 04 - 16 - t18:33:05z Re: Need help using LOOKUP or SELECT function https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105422#M25036

 

What would you expect to see for "SFS Funding" in January 4th for example?

 

 Fri, 16 Apr 2021 20:23:37 GMT https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105422#M25036 fabien.junod 2021-04-16T20:23:37Z Re: Need help using LOOKUP or SELECT function https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105443#M25046

 

 

The reason it is not working is because in your target module there is a dimension called Funding Only and in Source module

you have diff dimension called Loan Type. See what is the relationship between these two dimensions and then use the valid function to move the data from source to target module.

 

Misbah

 Sun, 18 Apr 2021 07:04:33 GMT https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105443#M25046 Misbah 2021-04-18T07:04:33Z Re: Need help using LOOKUP or SELECT function https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105501#M25063

 

 ,  

Isn't there a "LOOKUP: Month" missing? Where every day is mapped to the month?

The source module is dimensioned by month and the target is dimensioned by day

 

SYS Time by Day.jpg

SYS time blueprint.jpg

 Mon, 19 Apr 2021 08:15:57 GMT https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105501#M25063 fabien.junod 2021-04-19T08:15:57Z Re: Need help using LOOKUP or SELECT function https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105507#M25067

 

 

Good catch. Yes Indeed there is LOOKUP missing on that as well. But there is a dimensionality mismatch also.

 

Misbah

 Mon, 19 Apr 2021 09:03:01 GMT https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105507#M25067 Misbah 2021-04-19T09:03:01Z Re: Need help using LOOKUP or SELECT function https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105898#M25223

Thank you for your help. we figured it out. 

 Wed, 21 Apr 2021 20:44:37 GMT https://community.anaplan.com/t5/Anaplan-Platform/Need-help-using-LOOKUP-or-SELECT-function/m-p/105898#M25223 neg177 2021-04-21T20:44:37Z