-
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,…
-
My View on Classic Dashboard Sometimes Changes Options
Has anyone else experienced where My View has changed for a user? This dashboard is hardcoded to only show Actuals, but for some reason it shows Forecast for the user. As you can see the option is grayed out and the selector is not active. When I had the user changed to Master View and back to her My View, it's back to the…
-
Problem with dimensions
Hello I have a question that I am struggling to solve: I have these two SYS module, Store City here is a property of a numbered list with store code I have second calc module, historical volumes loaded with this set of data And the third calc module, organized with formula. So far so good, the issue is that I cant come up…
-
How to assign specific people in the Notification Designer Panel
Hello, I would like to creat a notification form and assign specific peoples to this action. But Anaplan doesn't show me any users in the drop-down list, despite the fact that we have several hundred active users in this model. Could you help me to fix it please ? Etienne
-
Level 3 : QUO06 Module & Sales Reps Flat# list not used !
Hello Anaplan Community, I have completed Sprint 1 and Sprint 2 of the Level 3 training, and all my answers were correct (they matched the answers provided in the Check Your Build section). However, I did not use the QUO06 Tenure Calculation module and the Sales Reps Flat# list that were prebuilt in the model by Anaplan.…
-
Level 3 Certification, create new modules or use previous modules ?
Hello Anaplan Community, I'm working on the Anaplan Level 3 certification, and I'm currently at the Assigning Accounts & Sales Reps process. I'm facing some confusion regarding modules while trying to keep the D.I.S.C.O methodology in mind. Can we display SYS modules on the UX? For example, can we add a line item for input…
-
NUX Or Classic Dashboards in Level 3 Certification ?
Hello, For the Level 3 certification, are we required to create dashboards using Classic Dashboards, or can we use the NUX instead? Thank you for your help, Noura
-
What is the process for model builder anaplan certification
Could someone tell me the process on how to register for this certification ?
-
Should we build Dashboards along with build in Level 3?
Hello Anaplan Community, I'm working on the Anaplan Level 3 Certification and following the instructions for the build. I'm almost finished with Sprint 1. However, I'm wondering whether I should be creating the dashboard alongside the build (as it's not specified in the instructions), or if this part will come later in the…
-
Dynamic Fake Weeks to Fake Months?
Hello ) Need to run FakeWeeks and FakeMonths to support a Optimizer-setup. As a part of the requirement I need to be able to sum FakeWeek-data into FakeMonth-data. As the fake time lists are dynamic and used for a forecast which moves with the current period of the model I can not use a manual mapping. I am close I think,…