SELECT AND LOOKUP

Hello Community,
anybody to help me, I'm trying to pull data from Module which has Time,Version,Lis as List and Amount as line item in Target module which does not have time and version means it has (Lis and amount as dimension) I'm trying to avoid hard coding {Source Li[SELECT:VERSIONS.ACTUAL,LOOKUP:GLOBAL DRIVE.FY]}.

Thank you

1_137821.PNG

2_137821.PNG

Accepted answers

Neeharika

You can make a system module in which you have 2 Line items

SYS01: Module for Selection

Dimension: None

Line items: Select Version, Select Drive (Formatted as their lists in the system )

then in the target module you can use lookups Like:

Source Li[Lookup:Sys01: Module for Selection. Select Version,Lookup:Sys01: Module for Selection. Select Drive ]

Neeharika

Hi,
If you are using Anaplan built-in Version, unfortunately, there is no simple way to remove select.
but if you use a custom version you can definitely use the system module for that.
Limitation: You cannot set versions as a format for line items.

All comments

Neeharika

You can make a system module in which you have 2 Line items

SYS01: Module for Selection

Dimension: None

Line items: Select Version, Select Drive (Formatted as their lists in the system )

then in the target module you can use lookups Like:

Source Li[Lookup:Sys01: Module for Selection. Select Version,Lookup:Sys01: Module for Selection. Select Drive ]

musoresempaul

Thank you @Neeharika
but i think they cannot be formatted as lists in line item because they are native versions not custom version

Neeharika

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…