Level 1 Model Building

ifeldman

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

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?

abhi1017

@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