I have a module with dimension x and I want to get a line item y from another module with dimension z . How can I achieve this in anaplan? I am unable to use direct lookup modules
Hi @Ankitabhardwaj you can achieve this by creating a system module for mapping x and z and you can use lookup. Create a system module with x as dimension and one line item Z with z as format and in main x module u can lookup with this Z line item.you can refer the below example
Here i have module with y as dimension(Source) and one line item revenue.
And i have a module with x as dimension(Target) and one line item revenue.
I had created a system module with x as dimension and mapped y.
Then i just used lookup in X module.
I hope this will be helpful for you.
Thanks and Regards
Akhil Emmanual
Hey, thanks a lot for the solution, I figured out the same thing but this would be extremely helpful with all the screenshots attached for any person who would like to understand this process
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!