-
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…
-
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…
-
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)"]
-
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…
-
Anaplan New Workflow decision task
Hello all I have a question regarding the New Anaplan workflow . In the online course provided by Anaplan it says when a Decision Task is created and assigned for example to a user , when workflow starts that approver will see 3 option : Approve - Reject and Send back . i decided to create a Decision task but when it is…
-
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
-
Solution Architect Certification
Hi Everyone, I have completed my Level 2 in April 2019 & Level 3 in June 2020. After that, I have switched my job so both the models are in old organization's workspace & transferring them to new workspace isn't possible. Now, I wanted to get Solution Architect Certification & for that I have to update my models. So, can…
-
Suggestions on how to optimize data imports for a Real Estate Company with many products
Our company is a real estate developer and I am having a problem dealing with too much data. For example, we consider our condominium units as our products. These units are unique from each other (i.e. they have different unit number for each building and for each project development.) In short, no two units are the same…
-
Real estate financial modeling
I am currently working on building a real estate financial model from scratch on Anaplan, focusing on either acquisition, renovation, and development modelling or a simple condo development model. I seek guidance and references for creating these models on Anaplan.
-
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!
-
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!
-
LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation_ Error
The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation. Kindly help ERROR: The formula for 'REV03 Margin Calculation'.Cost of Sales is invalid ;REV02 Volume Inputs'.Volumes is…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hello everyone, on my activity, the totals for the other expenses are not populated as the same with the should be result in the activity. Here are some screenshots. This is my model: This is the should be: Any solutions to this? Thank you
-
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…
-
SUM based on Line Item Value
I have a line item that has a list value. In another module, I would like to sum based on that list value -- without adding that list as a dimension in either module. Is this possible? I know this syntax isn't right, but it would be something along the lines of Source.Amount[SUM: IF Source.Line Item = List.Value]
-
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…
-
Lesson 6.6.4
My module looks identical to the example, except for one additional "YTD" column. Can someone advise how to get rid of that additional column?
-
How do I exclude zeros from a MIN aggregation?
I am building an output module to show some statistics around account pipeline by industry. I want to be able to show the smallest pipeline. Since some accounts have zero pipeline, the standard MIN function returns zero, but I want it to return the MIN excluding zeros. How can I do this? Here's an example of what I'm…
-
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,…
-
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…
-
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
-
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…
-
Level 2 Sprint 2 DEM03 Growth Rate % line Item
For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference: The issue I am having is that I am unable to properly map the formula. Resulting in various error messages. I…
-
Processes within Processes
It's a really old idea from Exchange - Include Process Within a Process — Anaplan Community I thought I had a workaround of sorts - using Cloudworks but alas the "integration flows" element can't be put onto UX pages even though individually processes can be. Is this because of a page only being attached to a single model…
-
Unable to Dynamically change Line Items names
Hi all! I tried to follow the steps of this article about dynamic line item names change but I can't get it to work, so I would like some help on why it's not working. For context: I am building a Price/Volume/Mix analysis which I gave the end user the ability to pick which versions they want to see the comparison, naming…
-
How do i start training for Anaplan Level 1 Model Building training Anaplan’s NMX
I have been stuck with Unicorn Candy Company Model building Level 1. Since, I am a student i do not have access to Workspace. How do i get workspace so at least i can start practicing model building. I am new to Anaplan any tips to master would be appreciated.
-
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.…
-
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…
-
What is the process for model builder anaplan certification
Could someone tell me the process on how to register for this certification ?