-
Lag inside an If statement , best practice?
Hi I need to put a lag function inside an IF statement. What is the best practice for this to optimize model performance? Should I break it into to line items? Or would it be more efficient to do: IF NOT x > y THEN 0 ELSE LAG() ? Thank you
-
Allow the same action to run multiple times within a single process
Description of the enhancement required: Allow the same action to run multiple times within a single process How would it help your business process: There are many situations in which this would be helpful. One example Setting a production plan based on prioritising SKUs. i.e. The capacity of a production line is…
-
How to get around circular reference with an average?
Hi all , I have been having trouble with this problem. I created a simplified example of the issue. I have a daily module. First I must manually calculate the Average balance with the sum & average line item because I only want the average to be calculated with "Working Days" (not holidays and weekends). (I must select all…
-
Running alternate hierarchy
We currently run the following hierarchy within our system This works for how the business currently reports, however in the future will need to still be able to report in the above hierarchy but then we would also need to report in the following structure. As you can see the bottom level would be the same, however I would…
-
Select combo box allowing multiple items selected
It is to have the possibility to address select combo box allowing multiple items selected
-
L1MB Time and Versions
Hi there, I am busy with the Model 1 training course and see at the section where we need to input the following a message pops up warning me that I can lose data. I just want to double check that because I am in my Training Model that these settings wont impact our real company model? I am just want to make sure that the…
-
Issue with Margin Summary Dashboard
I am encountering the same issue, and I guess the filters are not working as expected. The above screenshot shows the Forecast Periods Grid created inside REV03 Margin Calculation. The filter works perfectly fine to filter Forecast months, as shown in the output below. However, when I switch to a new module and come back…
-
Ability to Rename Line Items on Front End
It would be great to have the ability to give line items "display names" on the front end. This would be similar field card- for field cards you are able to update the label for line items:
-
Build a random number generator in Anaplan
Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Anaplan does not have a RANDOM formula or function, but random numbers can be useful — I was interested in it for generating sample data, but it could potentially be useful for other applications such as Monte Carlo…
-
Variance Analysis With Native Versions Made Easy
When creating a model using versions, one of the first questions is, “Should I use Native Versions, or should I create a Custom Versions list?” Will I need to do version comparisons; do the comparisons need to be dynamic? With Native Versions, I can create another Variance version and create a formula, but a) it is not…
-
7.2.3 Activity: Import Data into Employee Details Module
I can't see the Target items, please help me.
-
Anaplan License Tiers
Hi, There used to be a nice table of anaplan license tiers and what is included in each, such as Basic, Professional and Enterprise. I cannot find this anymore. Can someone send me where this can be found? This information is super important for studying for master anaplaner exam.
-
Access after free subscription
Hi everyone, Just a quick question: are you able to access the learning contents after the free subscription ends, or will I need to subscribe to access Level 1 and 2 contents? Thanks!
-
Want to make an action card that allows me to insert new data into a list
want to create an action card for a list lets call it user list ( Numbered List). I want to make an action where i type in a new name and it makes a new entry into said list. I thought Create Actions should work but they dont seem to apply here.
-
Hyper connect
How can we download Anaplan Hyper connect from informatica website?
-
Scheduled Process not Working when Scheduled, but does work when manually run
We are having an issue with an action/process not updating when it runs as scheduled that I am hoping to get some assistance on fixing. This process runs overnight every night and is designed to store a snapshot of the weekly lag 0 forecast. The source is a Saved View with a time filter of current week to end month 3 so it…
-
New UX Idea - Apply one more model source to all pages of the app at once
One of our model a dev and multiple prod models linked to a single dev via ALM. We have developed New UX App based on dev with a lot of pages in it. My aim now is to apply all prod models we have to this app, but the existing procedure is not effective for this idea. I want to have ability to add new source to the excising…
-
Add a seperate role for End User Page Builder
We have a challenge that our end users cannot share (publish) views / reports (pages), because the risk is too high to assign the current Page Builder role to them. The Page Builder policy allows actions that could be detrimental to our business (I aware of recovery options but we prevent issues rather than resolve them).…
-
How to create a Filter Of Time based on a combo with different time
Here i want to have a time filter based on the combo . Where user filter highlighted(Red Colour) year . then dynamically the time filter should be applied 2025 to 2026
-
A conversation with Kevin Cho — Journey | Anaplan Community Podcast
Welcome to episode 15 of Journey, an Anaplan Community podcast. Tune in today to hear host Kas Gengadaren (@KasG), Anaplan’s Senior Program Manager of Global Ecosystem Experience, chat with Kevin Cho (@kevin.cho) — Certified Master Anaplanner, Community Boss, and Planning Systems Manager at Atlassian. Kevin is an…
-
[Start Here] Anaplan Connector for Informatica Cloud – Part 1: The Basics
Welcome to the basics of the Anaplan Connector for Informatica Cloud. What you’ll find here is a quick overview of the connector before we get to the fun stuff: best practices, use cases and tips and tricks! You’ll find notes on what the connector for Informatica Cloud is, who it’s for, and use cases to give you a taste of…
-
Level 3 Sprint 1 3.3 Check your Build
\\Hi, I am struck with Level 3 Sprint 1 activity. As per the screenshot it refers to TAR01 Sales target module. However in the downloaded version, has different dimension and does match with the screen shot. @Dikshant Can you please help? So I created another module TAR 04 with line items mentioned in 3.3 Check your build…
-
L2 Sprint 3: Unable to get the correct formula for Shipping time weeks
Where am I going wrong, please advise. It must return 4 Weeks but it is Zero
-
Integrating Sankey Diagram Visualizations For Power BI Dashboards
I have used ChartExpo.com to create Sankey diagrams. Has anyone else used this tool, and if so, how have you integrated these visualizations into Anaplan?
-
Summing Previous and Current Weeks Open Orders
Hello, I am looking to write a formula to incorporate orders that were placed in previous weeks but are left out of current week. In the example pictures, the current week has 312 units open, but the current open from previous weeks and current week is at 10,056 units. The residual is not included in my module is throwing…
-
Ability to Create/Provision Users via API?
Hello, Is it possible to create new users and assign access via API? The API documentation doesn't seem to specifically mention this as an option. I suppose setting up an import to the user tab could work? Thanks, Ryan
-
Incorrect % line item summary
Hello Everyone, I've a list with 10 members where each member has a value of 10%. The summary for this line item shows 0.999.. instead of 1 in the backend. When I'm comparing the summary with 1 it gives me incorrect value. Does anyone know the reason for this? The summary is correct as 1 when the value entered is 50% for 2…
-
Model Changes Tracking
Hello, Recently, I have been involved in a Model Building activities. Project has two teams. Original MBs and my team to take over. My question is : if there is a way to track who created a particular module, line item or applied changes? (Apart from "History" tab)
-
Recording now available! July 30 quarterly platform release event
If you missed our July 30 platform release event, the recording is now available! In this webinar, we highlight the most recent feature releases and how to take advantage of these in your environment. Our Operational Excellence Group (OEG) goes through a demonstration of the most recent platform features, provides a…
-
Splitting single line item into multiple line item
Hello Team, As project requirement I need to split the total annual amount into month wise and under different heads. I have created one input model where end user will input the amount. expected output is as below Amount will get spit based on certain rule defined. I am clear about the calculation of amount and output…