-
Adding Months in Text and Numbered Format Line Items and Numbered Format Line Items Only for FY
Hello Everyone, I had A and B as text line items and Third and Fourth as numbered line items. I created a logic to add two filters in the grid: one to show only the Third and Fourth items in the FY view and another to show all line items in the monthly view. In the first image, you can see that we created a Line Item…
-
8.8.4 REP02 Formula
Hi I keep having trouble figuring out what I did wrong in the reporting modules. I am unable to enter the revenue and cost of sales formulas into REP02 it says my "Dimension of mapping used for aggregation doesn't match any dimension of the source" I am not sure what that means or how to fix it. Could anyone help me??
-
Four tips on Anaplan model documentation
Author: Timmy Thomas is a Senior Anaplan Model Builder at Autodesk, Inc. Documentation within Anaplan may seem like a mundane topic, but it is crucial to the long-term success and vitality of an Anaplan model. Inevitably, there will be change management to deal with throughout a successful model’s lifespan. Whether the…
-
How to create a module with a Boolean option that switches off "write access" on all Boolean boxes?
I am familiar with how to create DCA to switch off the write access for a list item. This example is costs for a land appraisal. Here is a module with rows that are editable. Here is an override module where I can change access from Write: To read: Now the Pricing method for the first 3 rows are greyed out: I can create…
-
Current User Lookup as List Format
Every module has the ability to turn off all users and show only the current user, but it order do show the current user, the users list is required in the applies to. The is currently a formulas to task current versions, time periods, etc but there is no formula for current user without applying the list to the module's…
-
Between Anaplan Time Range and Model Calendar, which is the optimal approach for model optimization?
-
Displaying Total but not the underlying Items
Hi all, i have an unusual demand regarding a dev, I am asked to display the value of a parent but not the childrens value, however the items are displayed. Basically, i have a Hierarchy that goes from C1 to C5, but the focus here is on C4 and C5. I need to do something like this : The "A" Parent is on C4 Level, and the…
-
YTG & YTD Calculation by using custom list
Hi All, I've one use case where I've create list which includes YTD & YTG as list item. Then I've create a mapping module between Time & YTD & YTG list item as shown in below screenshot. But when I am using sum to get data which is dimensioned by YTD & YTG List, result is showing 0. Can anyone explain why I am getting 0…
-
Nested Ifs | Model Optimization Team series
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
ANY formula issue
Hello, I can't seem to properly make this aggregation formula work correctly because it's based off a boolean which apparently is not filtering the list items correctly. TARGET MODULE, WKK51 Sales Returns - Actual/Forecast lists: week, scenario, customer group. timescale: NOT APPLICABLE SUM Formula: IF…
-
Make REST API Calls From within Anaplan
Hello all, I was wondering for whether it is possible to make rest api calls to another service (say servA) from within anaplan. The other service servA will of course then make some work and then maybe make a rest api call on anaplan back. I understand by reading some other posts regarding REST, that it is possible to…
-
Best practices - max rows in a grid
Hello, On a page, according to best practices, what is the maximum number of rows I can have for a grid? I heard it's 300 rows but not sure if solved Thanks!
-
Same line item to be editable and formula based
I have one line item and I need data to be formula based for first 5 years (Already defined in a sys time module) and next 5 years (i.e future years) to be manually inputted. We dont want an extra line item for that editable part. How can I do this.
-
How to lookup transactional data without having many-dimensioned calculation module?
I have a module that contains ledger data and includes information such as suppliers, produts, departments and ledger mappings as well as the cost/income on a monthly basis. I want to create a module that end users can input into for their department where they're entering details for their next year's budget. For this,…
-
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.
-
Delete Dormant Users from the Anaplan Tenant Admin Tool
The ability not only to disable but also delete dormant users directly from The Anaplan Tenant Admin tool. The assumption is that the Anaplan Tenant Admin tool can also offer a feature to enable the Tenant Admin to identify how long a specific user or group of users have not logged on to Anaplan models facilitating the…
-
How I Built It: Limitless interdependent multi-select filters
Author: Daniel Badura is a Certified Master Anaplanner and Lead Architect at Dr. Oetker. Hello Anaplan Community! In this ‘How I Built It’ tutorial, I show how you can build filters that filter filters, without using any dependent dropdowns. Each filter allows multiple selections, and they are all mapped using a single…