-
To use Lookup in a Flatlist
Hi All, I have a scenario, as follows: Module 1 : To get Headcount in this module Dimensions: L6 hierarchy, L6 Flat List(same hierarchy as a flat list), Cost Centre Line Item: HeadCount Time by month Module 2: Dimensions: L6 Hierarchy, Grade, Contract Type Line ITem: HeadCount Time by month I wanted to get the headcount in…
-
Working Days Calculation
Hi, I have been using the long formula for working days suggested in the Anaplan help, and it's been giving me some issues, so I created a new one It's shorter and easier to follow and thought I would share You need 5 fields* *Holidays is optional and can be removed example of calcs Hope it helps Kev
-
Anaplan Performance Issue
Hi All, I am facing issue in terms of Anaplan Model Performance. In my model I have a Filter Criteria Module which allows user to filter the dataset in a particular module based on the users selection. Dimensions in Filter criteria module is Z-User which allows me to provide selective access to the particular module. If I…
-
Source Model usecase
I have actions(imports data from different model) mapped to model which was deleted last month.But the action is still running fine without any error and updating target modules. Instead of deleted model we have new model which has same structure as old. In source model I can still see old model name and mapped too column…
-
Hide one dimension in a column when there are 2 dimensions
Hi everyone, Anyone knows if it is possible to hide the time dimension without taking it out of a certain module? In this specific case I want hide the years (FY20 and FY21) but still have time as a dimension. My final objective is to have this table on a dashboard without the year indication on the columns. Just for…
-
Revision Tag: Roles -> Actions
Hello, I have a quick question in regards to revision tags. If I were check the box to grant a user access in "Roles → Actions" in DEV, would that require or qualify to use a Revision Tag in order for it to sync to PROD? Or what would be the best way to update the change, so it reflects in PROD?
-
Number of working days in a month
Excel uses the formula function NETWORKINGDAYS to calculate the number of working days in a month How would I do this in Anaplan? Link to an input module?
-
Can a parent and child in a list have the same code?
Hello, Can a parent and child in a list have the same code?
-
How to best design your model to facilitate variance analysis.
I have a requirement to create a model that can facilitate variance analysis like Compare CY Sales, with PY Sales and show % along with doing the same for CY Sales vs Budget. What would be the ideal model design? Should I be create versions or should I create line items for CY, PY and Budget in the module and then…
-
Level 2 Model Builder- Sprint 2 DEM03
In module DEM03 there is a formula to pull forward the historic volumes data from the previous period, I have been able to do this up to the FY20 however beyond this the cells are blank. Below is my working formula which populates the forecast up to the end of FY20. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?'…
-
Level 2 - Sprint 3 - 3.3.7.2
I need guidance regarding this
-
keeping last duplicate in numbered list
hi community, transactions is a numbered list and module has 3 line items, 2 are text and 1 is number formatted so the ask is to find duplicate combination of customer, prod and value in the list and in case of match , keep the last item and delete the first item here, 1 and 4 are duplicate , 3 and 6 are duplicate , but we…
-
How to get data from source module with time dimension to target module without time dimension
Dear Team, Hi again! I would like to inquire on how to get data from source module with time dimension to target module without time dimension. For illustrate further: Module 1 - Upload of Year to date balances - with time dimension (Month) Module 2- Deduct the current period(month) from previous period(month) to arrive at…
-
Finding the first working day of the month
Hi guys, I am trying to create a calendar. In this calendar I need to pull out the first working day after day X. For example : I have a module with holidays, working days etc. as booleans and on the other side I have 1st of january 2nd etc. Let's imagine the 1st of jan is a saturday. I would like then to check the 2nd of…
-
Compare numbers in different modules
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…
-
Setting a Date formatted line item to Blank
I am trying the following. Not sure if the issue is that the Date format items can´t be blank or something on my formula
-
Community perspective: Building two approaches to ragged hierarchy
In Two approaches to ragged hierarchy, I presented two ways to fix a ragged hierarchy into a balanced one. Now let's proceed with building based on these two approaches. 👀 Blueprints are included for your reference. Building Hierarchy - Loop20230207.xlsx 1. Common preparation Many platforms with a hierarchical structure…
-
How to fill a line item recursively
Hi! I have one module where one of the line items is my inventory amount and on the columns I have a list where I put diferent fiscal years (note that I cannot use the formula PREVIOUS() because this module is not connected with Time, and I can't connect it either). So my list is composed by: FY22, FY23, FY24, FY25, FY26,…
-
Auto-Hide line item based on selected list member
Hi, Is there a way I can hide line item based on the selected list member? I tried to use line item subset but no luck since I have a date format and boolean in my line item. See attached picture. GLA, % of Sales and Sales Quota should be hidden when i select a different list member. Thanks, Tom
-
Which Model Builder Training Program is Right for Me?
The Anaplan Academy has training solutions to fit the needs of every aspiring model builder. Use the chart below to determine which program works best for you. Paid Programs Public Workshops | Private Workshops Free Programs Talent Builder Guided | Talent Builder Independent | On Demand Training
-
Extending a week
Hi All, Is it possible to add a week in the model calender for a new year without adding a new year in the time settings. TIA.
-
Import filter by user
Hello, We are updating a spoke model from our data hub daily, and I need to enable end users to individually update the spoke model for their specific list member (property) only. Currently, imports from the data hub are running daily into staging modules. Now I need a way to allow different users to run a process to…
-
The Planual Rises
It’s time. For the last 18 months, we have been working hard to fully understand how the Anaplan engine works, what the associated best practices should be, and how they should be put together in a digestible format. It’s 4:11 p.m. I am in a very hot Pier 29 building in San Francisco, standing in front of an expectant…
-
Add the current user to a field when they approve an item
I have an approval process with several gates, i have restricted to ability to approve, but all i want to do is when the approve button is pressed is apply the current user details to the Approver and add Todays date. The date part is done, as I already have the date automatically updating in all models. How can i get the…
-
Version subsets and selection as a format
It would be great if you could select Versions as a format of a line item. This would make it much easier to pull data from a specific version into a module without versions, for example using a lookup within a line item. It would also be great if we could create subsets of versions in models where there are many versions,
-
Lvl 3 TAR04 Account segment total by country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the individual segment data(small,medium,large) aren't. See attached image; first grid is my build and second the one from training. I checked my system module and all segments are mapped to each account. what is it that I am missing?
-
Anaplan Level 1 Certification cost and support
Does Level 1 and Level 2 certification cost me anything? Will able to download the Anaplan Certificate after completing both the levels? What does instructor led version mean? Please brief. Please find the attachment.
-
Ability to add multiple values to a text filter
Description of the enhancement required: Text list filter delimiter An example of the enhancement: Text line items can be filtered by more than one value. How would it help their business process: Filter of text string with a delimiter. Want to be able to set a filter on a text line item for more than one value without…
-
Get to know the model experience as an end-user
Welcome to the Anaplan modeling experience (MX)! The Anaplan functionality you know and love, with a modern look and feel and simplified, intuitive navigation. In February 2023, the updated model experience became the default for all users. In April 2024 the ability to toggle back to the old classic experience will be…
-
L3 Account Segment by Country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the segment data aren't. See attached image; first grid is my build and second the one from training. My understanding is that this would happen is I dont have the right Segment for each Account. Can you let me know if this is possible?