Modeling

Level 2 - Sprint 1 - Lesson 1.5.6.1 Creating Historic Volumes Module
Hi, I'm unable to import data into the DAT03 Historic Volumes module. PFA screenshots. As far as my understanding, the data is not being loaded because of the volume mapping. There is no option for mapping the volume. Please let me know what I'm doing wrong and how I can resolve it. Thanks in advance.
TEXTLIST() for displaying values
Hello all, I've been wondering about a way to display selected values. To give an example, In my screenshot, three countries were selected and i like to display them to give users a sort of a recap. So i tought using textlist() as follow : However, it doesn't work and it seems that the problem resides in the fact that my…
Anaplan Image upload new UX
Can anyone share how does Anaplan able to access the images uploaded in a private sharepoint folder without asking for another log-in authentication? We have a current project right now that we need to show the logo of each brand in the new UX page. What we did was to upload it in a sharepoint folder (that only few people…
Stuck on L2 Training
My computer did something weird to my model,How do i restart my model building?
6.8.3 issues on code
hi team i m trying to add code text by using CODE(ITEM('G2 Country')) but in toggle mode, it not show code
Time Filter - Quarters and Year only (not half year)
Hi, I would like to only show quarters and the full year value (not half year values) for the current year. How do you create a time filter to only tick the quarters and year in the current year but not the half years. Thanks.
Headcount alignment playbook
Table of contents: * Problem statement * Proposed solution * Stakeholders and responsibilities * Data sources and integration * Return on investment * Conclusion Problem statement Anaplan has had challenges getting our finance, human resources, and sales teams on the same page of what our headcount is and what our…
Anaplan Model Builders and Drummers
In Anaplan model building, we have to make sure that the four cornerstones (model, data, business process, and deployment) during every phase are addressed. All of them are equally crucial for the success of the project. I think that, in a way, model building is like drum playing. As drummers are able to move both arms and…
Update fiscal year action / Current fiscal year as production data
As a workspace admin, I need to be able to update the current fiscal year as production data and/or via an action for authorized users This is necessary as upon fiscal year change, currently our users need to go through a structural model change
Count redundant word in a text line item
Hi Team, Is there a way to count a redundant words in a text line items? for example, I want to count the word "Anaplan" in a nested text line item that contains: "Anaplan is a cloud based tool. Anaplan can be very useful in planning reports". Is there a way to get a result "2" here. Appreciate your help. Thank you, Elaine
Forecasting
Hi, I have 48 months of historical data in my Personal Project and need to forecast for the next 12 months. I believe that Anaplan has AI feature. How can I achieve to forecast by using that feature in my model? Any ideas or examples? Thanks in advance, Mark
Landing page when you open a model
Hello Team , so when we open a model from the app page it lands on 'Time' tile in Model Settings. If we have a model role that has selective access, it generally opens onto a blank tile and then when they click on the module they have access to , they can see the data. Is there a way we can set what tile or module a user…
New UX: open a source module
Hi, obviously, the New UX is still under construction, but i want to share one more thing that I am missing there now. So far, it is not possible to open a source module of a given card. The only way how I can find it out now is to go to edit and 2 steps back to the screen for choosing source module. Or am I wrong? It…
Create Survey Panel for Users in NUX
Dear Experts, Any suggestion or guidance how can we create a Survey Panel like this in NUX for the users? Many thanks, Ishan
Updating Salesforce with Anaplan data in real-time
Has anyone seen an environment where Anaplan updates Salesforce in near real-time? If you have, what tool(s) are you using to run the inter-system integrations? What is the export frequency set at between the systems? We have a use case where an end-user inputs data into Anaplan, then clicks a process button to "submit"…
Best way to capture updates on line items and time of updates
Anaplanners, what would be the best way to capture updates to line items and the date in which line item is updated:- the ask is if line item is updated we have to capture the date on which it was updated. So one way I thought of is that if I can replicate the line items with copy line items, and then an action to paste…
3.3.12 Activity: Create Product Replenishment UX Page
I'm having trouble editing the final tables in the UX page. After I add the grid cards and link to the modules "SYS00 Time Settings by Month module, Planning Period Filter saved view" and "INV01 Inventory Ordering module grid published to the UX page", the boolean selectors are greyed out and uneditable in the dashboard. I…
Timescale - Working days
I really miss the possibility to select Working days as a timescale not only days. I would like to have the possibility to use all of the "time formulas" that is only to be used when you have a timescale. We do our Supply planning on a daily basis but we only works working days the weekends are closed. what we had to to…
How to Calculate Forecast period revenue in proportion of actual sales of CY
Dynamic calculation on Weeks vs Cumulatebyweek
Hello all, I have a tricky point, and cannot succed to solve it. There is Confirmed orders (already sold) and Forecast orders (we produce in advance because we think we need to have some stock for many reason). My company will produced all the quantities, but not exactly at the correct weeks (sometimes late, sometimes in…
Saved View Import Have some code self attached to it
Hi, When I am trying to import a save view from the different models in a different workspace, the save view names are getting added with a hashtag code and the import is also not working, the Error is failed to locate the Save view , Anyone have faced a similar problem?
2.3.10 Activity: Level Mismatch on Common Dimension OR Dimension of mapping used for lookup...
I am currently working on the Level 2 Sprint 2 2.3.10 Activity: Create Demand Forecast. In this activity, I need to create a formula which takes weekly growth rates by Product Family in one module and populate them by Product (child of product family) in another module. There is a third module which includes both…
Summary Value - Top level not defined in list
Hi, I have requirement in which I need the Total Cash value - which is kind of top level but the top level is not defined in the list configuration so I have tried my best to get the Total cash value for the "Sweep In" checks but unable to get the value without using the select statement as I have to make this list as…
Multiple UOM
Hi, For a client we have a setup where we need to plan and report on multiple UOM (liters and units). Currently we're looking into setting this up as following: * Client needs to decide per SKU on a 'planning' UOM. A UOM where all planning for that SKU will be done (inputs, overrides,...) * Create two Anaplan versions:…
12.4.2
My REV 03 has the values matching with the course, but they are not getting populated to REP01Country margin Report. Below I am attaching my screenshots!!
Percentage Calculation
Hi All, I am facing an issue in the calculation of percentages at summary level.I have a module where I have a percentage calculation field where the percentages are calculated and are imported to another line item from there in the same module. As the second line item displays the option of user inputting the value under…
Help us inform the future of Data Integrations at Anaplan
The User Experience Research team is looking for Integrations Admins and Integrations Developers who have spearheaded a first use-case integration into Anaplan to participate in a 60-minute research session. If this sounds like you, we’d love for you to sign up for this research study! You can sign up by filling in this…
Forecast to get value from Actual version
Hi All, I am facing a challenge while replicating the Actual selection to Forecast. Can we have a formula where forecast will take the same Boolean selection as actual. In the Column are versions(Not list).
Level 1 Model Building Exam - Model Building Activity 5
Hello, I cannot figure out the formula for Bonus and other line items for Level 1 Model Building Exam - Model Building Activity 5 I created the EMP03 Employee Drivers by Role module and added the department and role to it. In activity 5, we have to change the module EMP02 Employee Expenses "Bonus" line item formula to…
Previous quarter values
I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot.

Modeling

Discussion List