-
Level 3
SYS 03 is already built in module and it already has formulas. These formulas not pulling any data. Please advise.
-
L2 INV01 Formulas
Something is off on my formulas but I cannot figure it out since the differences in the screenshots below are so close. My module: Module from L2 3.3.7.2 Formulas: * Beginning Inventory: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning…
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hi All, I am on Sprint 3 of MB level2. Could someone please let me know if there is any mistake in these numbers on Stock exceptions review page. I am not sure if they are correct or not as they all are showing in red values after apply conditional formatting. The source module is obviously INV02 and INV01 ( for SKU level…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello Everybody, I get this error when i lunch the process, can you help me please ? Best Regards,
-
TRA01 Shipping Metrics by Week
Hi I wanted to know whether the below mentioned formulas are right for me to move forward with level 2. attaching the screenshot for the same. shippping time(week) :- YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)') cost per 1000:- YEARVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')
-
3.3.11 Activity: Create Saved Views for UX
I put in the line items and formulas, but I am confused about the summary method to use. I already reviewed this resource and have referenced this.
-
8.5.2 Activity on level 1 model building. How to reduce the imported data numbers?
I am doing my level 1 model building training. When I import the data in 8.5.2 Activity I get a price higher than it should be (in the picture it says 84 when the example says that it should be 0.84). Why is the data doing this when I import? How can I fix it?
-
Level 1 Exam activity 5
Hi I am stuck on the calculation for the car costs, phone costs and medical costs'. One should say the following formula would work for the car costs: But I am getting this error: Can anyone help please?
-
SPRINT 3 3.5.3 INV03 Module
Dear Community I m a bit stucked with the INV03 formula for the Stock Exception My Formula : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Distribution Center, SUM: 'SYS08 SKU Details'.Product] but i cannot see any amount popping up here and i have some amount in INV 01 Module Do you know…
-
SYS08 SKU Details
Can anyone offer a suggestion as to why the Code and Product sections are grayed out here and not mapping?
-
Level2 Sprint 3 3.3.5.4 Update INV01 to Allow Override of Order Amount
Hi I have got struck up with the activity attached the same, below is the formula which i have done. please correct me if i am wrong. IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount
-
Sprint 2 2.3.10 Create Demand Forecast
Can anyone help me with acitivity 2.3.10. I have the formula for the growth rate % and whenever I input it, it states that the line item isn't recognized. Pictures are attached. thanks in advance
-
2.3.13.2 Create a User Experience Page
Hi, I have to create a user experience page now. When creating a user experience page, I don't know whether I should select board or worksheet. I went for a worksheet and this came up: Now the instruction is this: Include the following: * Time, Account, and Product Family context selectors * Import Volume Growth Rates…
-
Growth Percentage Not Being Calculated
Hello All, I notice that the growth percentage is not being calculated in my model despite my being confident that the formulas are correct. Can anyone suggest why this may be happening?
-
Distribution Capacity Module -3.5.4.2
I am going around in circles with this task. I finally got to a place where I know where the numbers are pulling from into Inv04 module. I need to calculate the beginning inventory by month and distribution center. The data source time dimensions (Inv01) is in weeks and the target in Months (Inv04). Initially, I was under…
-
3.3.6 Level 2 Sprint 3
From the Training we are provided this example When I tried to replicate the situation to move forward, I got this:1. Why does Production Order have blue 0s from training material if we put it in as "No Data"? 2. Where did I go wrong with my Shipping Costs Formula? Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by…
-
7.2.1 Activity: Help needed
Hello, Having trouble with Activity 7.2.1, I keep getting this failure and I'm not understanding what's wrong. Please help, thank you. Below are screenshots of the failure and my mapping.
-
What are two types of L3 exams?
Hello, One of them is self explanatory that it is based on micro lessons. What is technical exam? Is it about the model we built during the course? How many questions in each exam?
-
Level 3 sprint 2 - How to populate G4T Territory>Account# list
I am stuck in G4T Territory>Account# list in Level 3 sprint 2. A2 Account>Product# list was similar to this one and we imported from data hub. It was clear for me. We assigned combined codes for the intersection cells in account-product matrix then imported it. In G4T Territory>Account# list is confusing. I couldn't figure…
-
Level 3 Sprint 1 Story 7.3 unable to match the data
Hi I am trying to match With But no success. I mapped Segments directly from SYS02 any suggestions?
-
13.3.4 Activity (Add formula to Profit and Loss Module) - understanding what these formulae mean
Hi I am working on the above activity, but struggles to understand what these formulae mean in the following format (If, then, else) with the sum function in the formulae: IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and…
-
level2 :Create DEM03 Demand Forecast Module
Hi I am trying to get the growth rate but adding 'DEM02 Volume Growth Rates by Week'.growth%(lookup:'SYS08 SKU Details'.Product Family) formula but the message is coming as invalid. I tried to lookup the SY08 product family as an intermediary module since dimensions are not same but still the message is showing invalid.…
-
Employee Expenses
Hi, I want to be sure in the Level 1 exam, the question is asked for FY even though the Employee Expenses are not based on time. So, since all Employee Expenses are given as currently values, the values for all FY are the same, is this normal? Thanks, Mark
-
SYS 08 Module
I believe that I have a bit of an importing issue in my SYS08 module. When mapping, I notice that the 'Code' section is grayed out. Everything else seems to map properly. My module looks like the screenshot below. Can someone possibly tell me what I am doing wrong? Any assistance would be greatly appreciated.
-
2.4.7 Activity: Create Saved Views for UX
I have created a saved view as required for this activity but my work is markedly different from the example provided and i have not been able to figure out why. Here is my saved view as opposed to the example Example : My View: Here is how i set up the Pivot for the Saved view I want to view the Initial Demand Forecast…
-
Offset Formula Help
Hello, I am unsure what went wrong, but my Offset formula for FY20 is no longer populating. I had it working previously, but I don't know where I went wrong. I've been using the appropriate formula for calculating it and triple-checked the SYS01 it was pulling from. I was confused when my FY21 values weren't showing up in…
-
Query on conditional formatting in Level 2 Sprint 3
Hello In the training lesson Level 2 Sprint 3 -3.3.4 Create Stock Exceptions review ux page, they have asked me to * Apply conditional formatting to highlight the Stock Exception count greater than zero. * expected output I have applied conditional formatting in custom view while publishing the module into ux page. The…
-
11.3.4 Actual and Forecast Values are the same
Hi there, My actual and forecast values are showing the same output. My forecast values should be different as seen in the example, but I can't figure out how to show the different output for the forecast values.
-
2.4.7 Activity: Create Saved Views for UX
My DEM03 gROWTH RATE% FORMULA: 'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family] It went through, however in further training 2.4.7 of Sprint 2 it is asking me to create a saved view which should look like ( below screenshot as per the course) But this issue is my DEM03 contains…
-
2.3.9.1 Import data into DAT03 Historic Volumes Module
Hello, I have been having difficulty completing the 2.3.9.1 activity. I utilized this forum to address my previous issues but I am still having trouble. The Historic Volumes aren't being populated. 9.2 and 9.3 seem to have populated appropriately. Please see the screenshots attached.