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
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…