-
3.3.12 Activity: Create Product Replenishment UX Page
Couple of questions based on my current UX Page and the screenshot from training * Is there any way to shift the context selectors on the top? i.e. if I want to have Time on left and Product on right instead of how it currently is. * Why are the Booleans in the INV01 grid not editable like they are in the material's…
-
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.5.5 Update Inventory Ordering to Allow Override of Shipping Method
Hi All, I need some help here regarding the Final Shipping Time in Weeks and Final Shipping Method Graphics attached. When I run this using the default position of Road and a 2 week delivery time it works fin, irrespective of the week I place the order. However, when I choose to Override Shipping Method, pick, say, Air…
-
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.
-
L2S3 INV01 Shipping Costs
Hi community members, can someone please take a look at my formula for 3 3 5 6 Update Inventory Ordering to Calculate Shipping Costs - Shipping costs line item Here's the formula hint provided in the course: Formula Hints: Shipping Costs: * In the TRA01 Shipping Metrics by Week module, the Shipping Costs are priced per…
-
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…
-
13.6.4 13.6.4 Activity: Add Line Chart to Margin Summary Page
Hi, For 13.6.4 L1 Model building I am getting my UX page like below, Please guide me to correct this. Model Building Answer Regards, Aslam
-
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.
-
Lvl2 1.7.3.1
I am not able to import P3 SKU from the data hub saved view