Modeling

Create subset in list based on subset from another list
Hi, I have a List 1 where one of its properties from List 2 In List 2, I have a subset which is manually created and not expected to change I need to create a subset in List 1 such that it will be automatically checked based on the subset ("GE" in pic above) in List 2. how can I go about doing it?
Finding Minimum
Hello All, Here I need to find Minimum of values in Expansion. But I dont need zero to be minimum. ExistingExpansion14016181820202222243401400000 Please help in finding the minimum. Suggest the function for the same. Regards, Jeevan
Level 2 - 2.4.4.1 Update DEM03 Demand Forecast Module
Hi I dont think I'm doing this right. I've produced a correct looking output - which disappears when I change Hierarchy levels. The clue I think is in the words " Next, look at the Summary Method settings for the line items. * The Demand Forecast values will be viewed at every level of the Product hierarchy - by Product…
Using an Anaplan Model to manage User provisioning
Hi All, I am looking to explore the feasibility/how-to of if a anaplan model can be used to manage Users, & Roles. The goal is to centralize the security management, almost as it it were a "data hub" that would then push the user roles to the other spoke models. Has anyone implemented something like this or know how this…
TEXTLIST() vs [TEXTLIST:]
Hi All, I have read and re-read @rob_marshall's (and Planual's) cautions against TEXTLIST but wanted to check if there is a performance difference between Textlist the calculation function and Textlist the aggregation function? Maybe a performance difference would come basis how the functions read the data? Planual doesn't…
How to have first cell in a time period as an input and subsequent time periods as formula
Hi, I am looking to set the first cell in my time range as an input and the following time periods to be based on the first cell. I think I use the offset function for future years but I'm not sure what to do for the input. Appreciate any help with this. Tom
Level 1 Exam - Question 5
Need to update the formula in EMP02 with EMP03's info. But I keep getting an error and I have no idea where I have gone wrong... Can anyone point me at the right direction? This is the formula I used... IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP:…
filtering
Hi, Despite I filtered the module for monthly forecast, it shows same. My screenshot: It starts from Jan 19 but it should start from Jan 20. Expected screenshot: Thanks, Mark
Level 2 sprint 3 Build Distribution Summary Dashboard
In the activity following instructions were given, where I am confused with the highlighted one 1) Applying a filter to DAT01 Beginning Inv - I am confused as in how to show which Product SKU is stored at which distribution center, what i thought was in the line item Nutzo bar EN SKU & New york as distribution center…
MAX() and MIN () functions over time periods
Currently you can compare time periods using operators '=', '>' and '<' which is great and very useful. But when it comes to comparing more than two dates, it becomes a nightmare to find a MAX or MIN. Unlike with number or dates, you either have to go through countless IF THEN ELSE cases which is probably impractical or…
SPREAD Function
Hello Everyone. I am Using SPREAD Function on Monthly Time range. I want to Spread value of only one Single Column. i have used boolean and if else condition for that but not getting it. Spread Function is adjusting All column values. and I want to spread value of only one column.
Not getting Task Id while running API call(Export Action)
Hi all, I am using python for integration. After authentication part, I got Export Id through API call. Now using that Export Id for getting Task Id with API Post Method : headers = {'Authorization': 'AnaplanAuthToken %s' % token, 'Content-Type': 'application/json'} data = json.dumps({'localName': "en_US"}) response =…
Suggestions on how to re-model a module
Hi, I currently have a Debt Reporting module in Anaplan which is built on the list P6 Bank Loans. How it flows is P3 Products > P4 Fund Entities > P6 Bank Loans. So within certain products, there may be several bank loans under the same facility. What would be the best way to report under Facility, rather than Bank Loans?…
8 5 3 Import Data into Volume Inputs
Hi All, I've seen a lot of different issues and answers for this activity, but I haven't found the specific one for my issue. What it should look like I got this part correct: But, the finished result is supposed to look like this and I can't figure out how to get there
9 2 5 5.00%
I'm confused about where I'm supposed to insert the 5.00% mentioned below
Modeling in Anaplan with alternative tools: Part 1
Today we are thrilled to feature Certified Master Anaplanner Mitch Aist (@maist1) in part one of a Community story on how to model build in Anaplan with alternative tools. Inclusivity and accessibility are key as we create the future of Anaplan and build solutions and experiences for all users and stakeholders. Mitch’s…
Data mismatch error
currently working on the level one exam and stuck on question 6 with rev04 model getting the formulas in. i know the formulas are right but the error pops up. so is there another step before entering the formula that i should be doing to bypass this error?
Actions working differently in different environments
I have an Process which contains 4 actions. This Process is in DEV, Test and production environment. The process works well in Prod but not in DEV and Test for the end user. No change was made with respect to the actions in DEV. Also tried setting model same as end user's role. But still its throwing error in Test and dev.…
Add Versions as a native option for a line item/property format.
Description of the enhancement required: Version as a format An example of the enhancement: When uploading a planning file (budget, Q1 forecast, Q2 forecast) from excel, a number of identifiers for my transactions are uploaded as text and later on in the transactions module turned into line items based on a list so I can…
Polaris Calculation Engine
Hi, Can anyone tell me why Anaplan has named their new calculation engine as "Polaris". Is there any kind of significance to the name "Polaris"? Thanks BB
L1M1 12.4.6 Activity: grid view (2nd part of task)
Hi everybody, wondered if anyone could help me on this as i've been stuck for some time. basically we are supposed to have our grid view look like attachment 1, however, mine looks like attachment 2 &3, i've double checked the formulas, don't have a filter on,etc and cannot figure out why the numbers don't match, as they…
Different output
Hi, I am following all the steps but my screenshot is different than expected, what could be the reason? My screenshot: Expected: Thanks,
Break Circular Reference
Hi all, I'm trying to set up a project planning model in Anaplan. As part of this setup, I'm trying to calculate the start date and end dates based on the dependencies. The logic I'm trying to build is as below, Start Date = IF ISBLANK(Dependent Step) THEN Project Start Date + Lead Time ELSE End Date(LOOKUP: Dependent…
Line Items' format
Hello, Even though I edited the Line Items' format, it shows nothing. I don't understand where I am doing wrong. Could you help me, please? Thanks, Mark IT SHOULD BE LIKE THAT;
How to identify duplicate text in lineitem to buila a unique list?
Friends, need your input and help in meeting the below scenario where I have a module n Dimension (IDs) and few listtype line items. There are repeated values if I concatenated line items (fyi in Anaplan; NAME(A) + NAME(B) + NAME (C) + NAME(D)) and need a unique list from those concatenated values. Tried RANK but can't use…
Planning our Modellers Forum 2022 vision!
Good morning all! So just to keep you up to speed with what is happening in the world of the UKI Modellers Forum...this morning @Paul , @ChanD and I are having a planning session to chart an exciting roadmap for the year ahead. Expect to hear from us with some future dates...and hopefully...some in person offerings at our…
NEXT or Previous cell values without Time dimension
Hi All, Is there any function in Anaplan, which can be used to get the next cell value from first line item in a new line item. or 2nd scenario is to ignore the prior cell values, For example: IF SL1(List item) ignore first 1 cell, for SL2 ignore first 2 cells,SL3 ignore first 3 cells ....and so on. I have done this using…
Lookup and use case
Hi, I am new on using Anaplan. I was looking for use of lookup between source, mapping table and target. I read below statement but could not understand properly. "If your mapping table contains the Target List and maps to a Source list-formatted line item or list-formatted property, then use LOOKUP in your formula." Does…
Level 1 Model Building Exam - Activity 7
I am trying to build out the UX but my data is different in some spots than what is shown in the example. Not sure what to do
Center of Excellence Series - Master Planning
The flavour for this year is not just about recovery but building strength in your capabilities to achieve the growth with scale you planned for, last year was unexpected, we all had big plans that might not have come to fruition, as many of our capabilities were tested. I’ve set myself the challenge this year to help the…

Modeling

Discussion List