-
3.3.5.2B Shipping Time Weeks
I input formula as below but no data gets populated for 'Shipping Time weeks' line item. already spent lots of time but still couldn't troubleshoot and resove the issue. Appreicate if anyone can shed some lights here. 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP:…
-
issue with the inventory formula of the line item.
i have been stuck at it for more than 90 mins.The following are the formulas of the line items, and modules and the values shipping by weeks are zero and issue with the dimension.can someone check and provide me with correct formulas. The formulas are obtained from following attachment. Thank you with regards Mohammed
-
Creating List activity
Please need more information on best practices to create a Hierarchical list.
-
Mapping data from module to module
IF we have data at Parent level in a module then how can we bring the data in a module having dimension at child level and Vice versa.
-
How to use Parent or List total in formula
I have a list called with a Parent named Total Fruit. Above are the quantities needed for each type. I need 8,526 pieces of fruit by formula, but that is misleading because the number of oranges and bananas is negative. I actually need 15,019 pieces of fruit. If I select oranges I expect my result to be (4,696). However,…
-
How to Make a Line Item Manual and Highlighted Yellow
Hello Anaplan Community! I have a question about adding new line items. When I add a new line item to a module in the backend of Anaplan, how do I know for sure the line item will be manual entry and shown highlighted yellow in the app page? For example, in the screenshot below I inserted the highlighted line item and as…
-
Why Name Data in importing Data to SYS08 Employee Details module is not coming?
can anyone help please i am trying t import the data but error is coming not the same in the screenshots of the module ?
-
Why am i not getting dropdown to choose size and country. Attaching photo for reference of both.
desired Output
-
Lists going blank after importing
After importing data into the list as soon as I close the tab or even switch from it on another list, all the imported data gets removed. What is the probable reason?
-
Create Inventory Ordering Saved View and Export
My exported file is not follow to the requirement, but i don't no how to fix it. Could Someone can help me please? This is my exported file: And this is the required file:
-
Formula:DEM03 Demand Forecast
[DEM03] I want to know Formula Override? Override Forecast Gropwth Rate%
-
L1 Exam - Importing Data02
Here why is the line item empty?
-
Level 1 Lesson 6 - SYS01 Time Settings by Year
I was replicating this module & I don't know how to show the next two year: how it's suppose to show : my screen : Can you please tell me how to fix it? also in the lesson 6.6.5 I don't seem to get the formula "'SYS00 Time Settings'.Forecast Period?" I have this as a message : Thanks a lot in advance Nada
-
1.5.6 Activity: Create Historic Volumes Module
I'm unable to create Module DAT03 Historic Volumes I keep running into a size limit error when adding both the SKU Flat List and Accounts Flat List. Question: I'm not sure what I'm doing wrong here, thank you.
-
2.3.8.2 Import into DEM01 Module
Hi everyone, I am trying to do the import into de DEM01 Module, but I keep getting this error. I've seen some similar questions here at the Community but can't really figure it out what everybody did to correct it. I am attaching some screenshots so you can see what I am doing. I really don't know what else I can do. Any…
-
1.7.3.2 Level 2 Sprint 1 Model Builder
I have tried everything. My question is, when I download the supply chain model- When I zoom in on model map, it has "supplied by" instead of "distribution center" so when I go to import my list, I am unable to map it to distribution center as it doesn't exist in the SYS08 SKU Details module. I am confused how it is wrong…
-
Level 2 Sprint 3
My models all got erased and then rebuilt but are lacking population of data in some areas. I have corrected most but I cannot get P2 Products to populate, it won't give me the parent, same for P3 SKU. This is fouling things up further along in the process. I have it right in the Data Hub P2 Products and P3 SKU but it…
-
issue with DEM-03 for sprint 2
The following is the screenshot of the the formulas for the line items. but the values i am getting are close to the correct values. did the process for the DAT01,DEM02 from the action tab. the values i am getting are really close to the correct values. please check the formulas and provide the feedback to obtained the…
-
7.2.3 Activity: Import Data into Employee Details Module
I tried multiple times to import the data but I failed and I don't know what is my mistake. Can someone help me? This is the result after my last import Thank you for your guidance Amalia
-
sprint 3 Country summary Module
Hi Members , Tried creating the below mentioned requirement with the formula written below , but not getting it correct . Line Item Format Purpose Safety Stock Flag CountNumberIdentify number of Stock Exceptions by Country and Product Family…
-
Where can I find the completion Certificate
Hi, I passed the Anaplan Model bulding level 1 exam. After submitting the answers it gave the result and an option to print. Now where do i find the certificate? The exam module in courses still shows 0% (not complete) Please suggest
-
3.3.12 Active Create UX page
I'm having trouble syncing time between grid cards and chats. Can someone tell me what to check? I don't know what i am wrong. This is my page. And this is the exercise
-
How to calculate intercompany ownership% calculation for a group companies?
Problem Statement: I have a requirement where I have to calculate the indirect ownership% of the entities based on the input of direct ownership% Example: The direct ownership% of the entities 'Entity 1' is the ultimate parent 'Entity 2' is held by 'Entity 1' by 50% 'Entity 3' is held by 'Entity 1' by 100% 'Entity 4' is…
-
12.4.6 Activity: Create Saved Views for Employee Expenses
I am not able to understand the below activity of how should I select the following line items only out of all the ones present . * Show only the following line items:* Headcount * Salary * Bonus * Car Costs * Phone Costs * Medical Costs * Total Employee Expenses
-
Level 1 Lesson 6 - 6.6.5 Activity: Add Formulas to Time Settings by Year Module
Hi, Can anyone help me with below? I don't have FY20 and FY21 checked (see below), however, the example has them checked
-
Importing file into flat lists
I was trying to import data from country CSV to a country flat list. but since the format of the source file was such that parent needs to be entered while importing or else it is throwing error. Due to which imported data comes as hierarchy and not as flat list. Please help with this.
-
Should I create a combined list or use a simple parent child relationship?
[Context: Demand forecasting for school books] I have 5 lists: - Book (SKU) - e.g. 56084746 - Subject - e.g. "Maths" - School year - e.g. "5º Grade" - Type of subject ( e.g. "Mandatory"/ "Not Mandatory") - if a subject is mandatory to every student of that school year Theoretically, each subject has two parents: the type…
-
Free Datasets to Play with in Anaplan
Hey, y’all! In a recent post asking when model building ‘clicks’ someone mentioned building play models to help gain an intuitive understanding of the process. This sounds like a great idea, does anyone know of any free databases this can be done with?
-
Top Level Summing
Hello, I have two modules A, B dimensioned by Region and Currency. The currency type has a top level of All currency due to that in module B the numbers are summing up x4 times based on module A(PFA screenshot). How do I get it to look at one currency at a time? I tried adding a look up and trying item(currency)= for each…
-
3.3.6 Activity: Test the Shipping Cost Formulas
I am stuck! My Confirmed PO Delivery and Confirmed Purchase Order Receipt are not updating correctly. This also seems to be part because when I Override the shipping Method, the Final Shipping Time in Weeks is not updating. I have attached screen shots of my module and formulas. Any guidance is much appreciated! Lesson…