-
How to filter time in NUX based on page selector parent.
Hi, I'm struggling to filter a table in NUX based on the page selector. Anaplan wants me to hard code an item to filter on. I want it to use the selected item in the page selector. I have a bunch of projects with their parent category Start and end month is set for each project. This aggregates with min for start and max…
-
How can I convert a text containing multiple items separated by commas into a list?
I have a text string like "X1,X2,X3,X4,X5" and I want to convert it into a list containing X1, X2, X3, X4, and X5. I tried using FINDITEM, but it only works for one item, and with FIND, I can only get the position of the first comma. How can I achieve this? Thanks
-
Workflow - Enable Completion Check
Hi, I'm building a simple workflow, and looking to incorporate the Enable Completion Check to control whether the workflow can be completed or not. My line item for Enable Completion Check I have set to false, specifically to check whether it is working or not, but I am still able to run the workflow. Is there something…
-
How to display selected line items depending on the selected level in the hierarchical list.
I have a three level list Country->Region->City. How can I display selected line items for a given level in the list. Let's say I have 10 line items in the module and for Country level I want to display 6 selected, for Region level 4 other selected etc.
-
Security around list updates
Hi, Just a question around how to best set security around who can update lists in our Anaplan model. Initial plan is to have list showing on application, with certain individuals able to update - is this done through page settings and restrict roles? Any advice would be greatly appreciated.
-
Average Duration for process to be run or Line items to reflect the changes
Hello Community members. Hope you are doing all well. Currently I am optimizing a model for a client that was having troubles with the duration of processes being run or the duration which it takes for line item to reflect manual change by users in a line item . Model has been optimized now. I know that for sure different…
-
sum not working
I'm stuck while building a module in Anaplan. In one module, I have numbers associated with the months of the year 2024, and the module has Anaplan's time scale dimension. In this module, I have a line item formatted as a list that contains four members. Each number is assigned to one of these four list members. In another…
-
lookup code
Think I must be having a mental block today but could someone advise what formula need to use in order to return the "Code" column shown in the left-hand side to the line item on the module shown on the right-hand side. Many thanks
-
Optimizer Error
Hi Everyone, I need your help in One of my optimizer use case. I am building optimizer which generate dispatch Plan. They have more then 15000 SKU and approx. 1000 transportation Lane. I am struggling in running optimizer with these many dimension which increasing a cell count of line item. Optimizer failed with attached…
-
LOOKUP by specific text
hi everyone. i would lookup only which is awarded or awarded (PO) in my contract details. how to do it in LOOKUP function? 'Contract Price'.'Final Contract Price'[LOOKUP: ContractDetails."Awarded","Awarded (PO)"]
-
how to add independent column in a module?
hi how can i add a column (status that can i can change from time to time) independently. regardless if the filter month has been change
-
Create DEM03 Demand Forecast Module
Hi, I am struggling to get numbers for the Baseline Forecast line item my formula looks like the below: IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG('DAT03 Historic Volumes'.Volumes, -52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' I do see the numbers for the year…
-
How to round up to 5 or 0
Dear Anaplan Community, I need help to round numbers up to the nearest number ending in 5 or 0 2233 — to 2235 2888 - to 2890 Any intakes?
-
Import module from another model. What will happen to the time settings of the module?
Hi everyone. if i have below 2 models: First Model: Time Model Calendar: Num of Past Years: 1 and Num of Future Year: 10 Second Model: Time Model Calendar: Num of Past Years: 1 and Num of Future Year: 2 now if i am going to import module from First Model to Second Model, is the module that i imported will follow the Second…
-
Anaplan Level 2 Model Building Sprint 1 Activity 1.6.3 Import Data into DAT04 Distribution Center Pa
Hi everyone, I am strugging with importing data to half year time demension. I have set up the import parameter as follow, but got the error message "Expected year half number in date/period" Any guidance is appreciated!
-
Question about Anaplan model-building process and support
Hello, everyone. In the near future, I will be introducing a supply chain model (from demand forecasting to supply and inventory planning) to a Japanese Manufacturing company as a Model Builder. As part of the preparation, I have completed Level 1 and Level 2 model-building training.Could someone tell me the process of…
-
Establish a connection between fake time and real time
I have a csv upload (see below) with a column for FY and an individual column with the qty value of each month. I cannot change the headers prior to import. To view this data by anaplan native time, I know I need to create a fake time to real time conversion, but I'm not sure where to start, thanks!
-
Publishing subsidiary views in FluenceXL
Has anyone had any success publishing a subsidiary view line item in Fluence grids? I have a line item in a module that is a subsidiary view used for mapping GLs. I need an end-user to update the mappings. Fluence will not allow me to publish and edit the subsidiary view mappings since the dimensions differ from the…
-
Sum if on a quarter level line item
Hey i need a little bit of help, i want to sum month values to a quarter level value but the dimension isn't really time related its more like converted The right solution would be 7000 in 'New Quarters Value' on Apr 24. May 24 and Jun 24 actually a simple sum if The upper Month dimension comes from a list(property) which…
-
Solution Architect Application : Can we still modify the modules ?
Hello Anaplan Community, I have just completed both the technical and knowledge exams for Level 3, and now I need to upload the model history and blueprint. My question is: Will we still be able to make modifications to our model after this, in order to prepare for the Anaplan Solution Architect application? Thank you,…