Level 2 Conclusion DEM04 Demand Export

kunal_311
Frequent Contributor

Re: Level 2 Conclusion DEM04 Demand Export

Hi @einas.ibrahim 

 

Done.

Anaplant
Occasional Contributor

Re: Level 2 Conclusion DEM04 Demand Export

I had the same issue, just use one of the two functions, and don't over-read into the above explanation too much, Location wasn't mentioned in the explanation if that makes sense, so the problem you are looking to solve might not be the same, and you might need to use a function.
asage
New Contributor

Re: Level 2 Conclusion DEM04 Demand Export

@einas.ibrahim 

Care to explain a little more? Here is my issue:

 

I have a list that provides roles (name and code). I have data that provides employee and their role. In order to do a LOOKUP, I need to have my dimension as a list. Under the module that has the data, do I need an additional Line Item that associates the Role list to the Employee data?

 

Thank you

einas.ibrahim
Master Anaplanner/Community Boss

Re: Level 2 Conclusion DEM04 Demand Export

@asage 
Happy to help.
We are trying to organize the forums to make it easier for the community members when looking for answers. It seems like your issue is slightly different from the original issue of this post. It might even be for a completely different training.
Please:

  1. Post the issue in a new topic
  2. If this is related to any of the trainings (L1, L2), then it is best to post it under the "Academy & Training" Forum instead of the "Anaplan Platform" forum. However, that's not very important for now.
  3. If this is related to a training then provide the training step number or a link to the instructions. Also, make sure the title of the post clearly relates to the question topic.

In relation to your specific question:

Some clarifications are needed. Please clarify which are your modules (source and target if you can), a Lookup is not done on a list, but rather a module.
I believe if you arranged your information as I did in the screenshot below, It will be easier for you to form the question more clearly and for us to answer. You might even find the solution yourself.😊
Focus on the top 2 lines only for now.

image.png

I'll be looking out for your independent post. Please make sure you mention me so I get notified.

Good Luck

 

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
ConRourke
New Contributor

Re: Level 2 Conclusion DEM04 Demand Export

@einas.ibrahim 

 

Thank you for such a great explanation. I was using a LOOKUP and you made this issue very easy to understand. 

 

Cheers, 

Connor 

einas.ibrahim
Master Anaplanner/Community Boss

Re: Level 2 Conclusion DEM04 Demand Export

Thank you @ConRourke 

It makes me so happy to know I was able to simplify a concept and help someone. Please let me know if you have other issues in the future - by mentioning me in your post- and I'll be very happy to help when I can.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
cbevishnu1
Occasional Contributor

Re: Level 2 Conclusion DEM04 Demand Export

This is the best explanation i have come across about sum and lookup. Thank you
einas.ibrahim
Master Anaplanner/Community Boss

Re: Level 2 Conclusion DEM04 Demand Export

Thank you @cbevishnu1 

You have no idea how much your words mean to me. I really appreciate it. Best of luck to you on your journey. 🍀

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"