-
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
-
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 ?
-
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…
-
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,…
-
Can I import data into a list from a no dimension module
I have created a staging module without dimension and need to bring data into a list from that no dimensional module. I am getting 0 created 0 Failed 0 Ignored message. Isn't it possible to add a list item from a no dimensional module.
-
Module to List Data import
I need to add list items from a Sys module. The Sys module has no dimension. I have added the components like Name Code L2 Name L2 Code L3 name L3 Code. Now in the Numbered List I am doing the mapping as Code- Code, Display Name - Name and Parent - L2 Code. The Source module has no dimention. Its showing me 0 Created 0…
-
LOOKUP to a mapping module using a dimension that is TEXT and not LIST formatted
Hi All, Trying to make the below formula work, it is BOOLEAN format so expecting a TRUE result in most cases. 'M#5 AA Description Mapping'.Acquisition[LOOKUP: AA Description, LOOKUP: Cohort List] 'M#5 AA Description Mapping' is a module that contains the dimensions AA Description and Cohort List so formulae itself is…
-
Should we absolutely seperate Input & Calculation Modules ?
Hello Anaplan Community, Following the D.I.S.C.O. Methodology, I understand that it is best practice to separate modules for input and calculation. I'm working on the Level 3 certification and created two modules for account review: one for input and another for calculations, where I referenced the inputs (HOLD / OVERRIDE…
-
Issue with Cloudworks Scheduled Process Not Updating Target Modules
Hi Team, I am facing an issue with Cloudworks. When I run a process manually, it updates the data in the target modules. However, when I schedule the same process in Cloudworks, it runs successfully but the data is not copied to the target modules. There are no Selective Access or DCA applied. Is anyone else facing the…
-
Does PlanIQ retrain the forecast model everytime I run the corresponding forecast action?
I have a time-series forecasting use-case. I am forecasting on a monthly basis, i.e. the forecast horizon is 31 days. As I move into future I'll have more actuals data available, and I want to include those actuals also in the training. For example, while predicting for Jan 24 the training set was upto Dec 24, now i want…
-
Show yearly total every month over multiple versions
I have a module that calculates admin overheads variances between versions (actual, forecast, budget and prior month forecast). I first created a module (PCAL01) that contains the data for all versions and then created a line item subset from this. Next, I created a module that calculates the variance (POUT01) as seen…
-
Help me to prepare my ppt and report for intern learning level 1 and level 2 anaplan model
for 8-10 pages ppt and 20 report
-
How we built the famous word game : Wordle!
You all must be aware of the global phenomenon of “Wordle”. The way this little and simple word game struck the world is amazing! We loved this game so much, we tried to test our beloved software, Anaplan’s, limits yet again and tried to recreate this game on it. This is how we built Wordle on Anaplan inspired from…