Level 1 Model Building

Hi!

So I have completed the Level 1 MB training, I have moved onto the Assessment portion in order to be L1MB Certified. However, I have stumbled upon a build that I do not remember learning. I went back to every single Level within the Level1 MB and was not able to get any answers or direction upon which to build. I would really appreciate any help possible, I am trying to just move on to the question portion in order to complete the assessment. Thank you!

Issue: Building a formula for a module for its volume list by pulling data from another module

Accepted answers

All comments

Constantin

Hi @ifeldman ,

Can you share a bit more details? If you have any printscreens would be helpful to understand what you need to do.

Thanks,

Costa

ifeldman

Hi @Constantin, since my question pertains to the L1MB assessment, I cannot post questions formatted from the exam. However to give you more context, I have to make a formula for the line item 'Volume' in REV02VolumesInput. Hope that provides you enough information to help me out, thanks in advance!

Kanishq17

@ifeldman

Hi,

I believe you can directly refer from the input data module as there dimension is at P3 SKU and target is at P2 product, so since P3 rolls up to p2 , the value will automatically be aggregated so use input module.line item in REV02

ifeldman

@Kanishq17

Thank you for your response! Can you be a tad bit more specific about the type of formula I would use with those different sections?

Abhiram K

@ifeldman

As far as i remember Rev02 module is populated by import action (Volume input.CSV).

The CSV file was shared as part of course.

~Abhi

Kanishq17

Hi @ifeldman

Just use DATA02 Input volume.volume as formula in the rev02 line item as it is direct reference

JosephA

I imported the "employee" csv file, but it did not show all the columns, what did I do wrong and how can I correct? I've attached both CSV file and a download of excel file from my model. Thanks

Employees_92081.csv

E2_Employees#_92081.xls

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385