-
L2 Sprint 2 2.3.9.1 Import data into DAT03 Historic Volumes module
H All, What happens in this case. I already pulled DATA from DATA HUB model in to Supply chain model DAT03 Historic Volumes module manually. What happens if I run the process 9 9.1 Import Historic Volumes9.2 Import Opening Stock9.3 Import Shipping Metrics Will I receive any errors in DATA in supply chain. Or The earlier…
-
Please help about this Error Message
Hi As part of my training activities : I am getting this error message while applying the sum formula. "Data type mismatch: format other than LIST or DATE being referenced as a relation" I am applying this formula 'REV03 Margin Calculation'.Revenue[SUM: 'SYS06 Product Details'.Size] Can you please help me to resolve this…
-
INV01 Inventory Ordering Conditional formatting.
Hello, could anyone please tell me why my conditional formatting is not working? All highlighted in green or red? Thank you! Really really appreciate if anyone can help. I spent hours to find out but cannot :(
-
issue with inventory modelling
i hope this message finds you well i would really like to have your insight and troubleshooting skills on the issue i am having with the inventory ordering module the following are the line items and have related screenshots with respect to the problem. formula of the line items: IF NOT 'SYS01 Time Settings By Week'.'1st…
-
Level 1 Lesson 12.4.6 Not able to project months into FY (ie FY = 12 months)
In EMP02 when I apply my conditional formatting, the module is not able to ID a Fiscal Year as 12 months and instead only show the total for the FY as 1 month (I checked to make sure that the value shown was 1/12th of the check work value. Any guidance on how I can fix this issue, I'm a bit afraid to change the time scale…
-
facing issue in modelling
In REP03 Profit and Loss Report module some of line items showing correct results but some are incorrect like headcount and car cost
-
How to use Timesum function?
In Level 2 sprint i got stuck at Timesum function, please help me out
-
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…