Modeling

Add module's name to the Line Items grid in the Modules section
It'd be great to have a module's name in the Line Item's grid. Especially when I extract it to Excel
LI Format - Time Period - option to choose several time period types at once
Hello, When choosing the format "Time period" on a line item, there is a choice between several types (month, quarter, year, ...). But it is only possible to choose one type. Is there any workaround to give the end-user the ability to choose a month, or a quarter or a year in the same line item ? Thank you for your help.…
Group/Ungroup Hierachy Items in Module
Not sure if this has been posted earlier but it would be awesome if we have group/ungroup feature in Anaplan on dimensions within a module. Basically Tree View of Modules which will help in grouping & ungrouping of list items based on the parent nodes. This should be applied only if the list is in rows or columns
Conditional formatting for List formatted line item
Hi I have expense list (5 list items) and one line item (Key fig list formatted).So for each expense list I need to assign one key fig. Suppose for travel expense list item If I have assigned Key fig1 and for the next expense also i have assigned key fig 1 then it should show in blue color indicating that each expense type…
Find if a list member has already be choosen in a line item in list format
Hello, I have two different lists of employees : the 4.0 list the people that we planned for the budget and the 4.2 list the people in the reality. I couln't link the 2 numered lists because, the matching of the 2 lists can evolve from month to month. I created a module in which the user choose wich person from the 4.2…
Level 2: Activity 1.3.4 Update System Modules
In order to get the SYS05 Country Details module to populate properly to load I had to use the Region codes (AMER, EMEA, APAC) in the Region Flat file, but when I I try to load the SYS07 Location Details module it is looking for the region names to be spelled out (Americas, etc.). TIA
Level 2 Sprint 2 Model Calendar question, data not showing
Hi everyone, I followed sprint 2 step by step until I found out my data was not showing in DEM03, so I was searching for recommendations in the community and tried editing my model calendar. However, I think I messed up because, after a few changes, even my DEM01, DEM02, and DAT03 aren't showing data anymore. I tried…
SUMMARY Formula on ITEM(Time Period)
Hi team, I created a ITEM line item in a Time Map (Months) module & set the SUMMARY to formula. I expected it to return the FY but instead it returned the 1st item in the period. EG for FY19 it returned Jul 18 Any ideas on why this is not returning FY19? Thanks
Things to consider when building a robust import action
Import actions are foundational elements of an Anaplan model. Import actions can be scheduled via integration or can be called on demand via dashboards within an Anaplan model. Imports could happen from different sources such as lists, modules, saved views, and files (CSV, TXT). Import primarily import data into target…
Edit to and from Periods
Hi, I have a module with timescale in quarters. I only have actuals as my version and have set my edit from Q2 2020 i.e. July 20 to end of timescale. I've asked a colleague to test this (it seems as model builder I'm able to still update regardless of settings?) - and they were still able to edit all periods? Why is this?…
Nex UX - Compare more than one data series in a Scatter Graph
Currently I can only compare one set of data in the Scatter Plot graphs. However, it would be useful to compare different data series, as that would allow me to plot different trendlines and compare the expected performance of different scenarios. Otherwise the functionality of the new tool could be very limited.
New UX - My Pages User Role
Is it possible to enable/disable My Pages based on user role? My client is asking to make it available only for specific roles. I believe it is only model specific, but wanted to be sure. Thanks!
Circular References and 5 year Forecast
Hi, Circular References and 5 year Forecast. I am trying to use the Prior Year's final forecast as the starting point for the new year and get circular references because of the calculations in between. I am using the Previous year's Actuals as the starting point which is fine as this line does not relate to the…
Logging comments in Anaplan
Are there Anaplan folks who have worked with comment (text) logging in Anaplan for end users? The business prefers to log comments in the financial forecasting in Anaplan on multiple versions. Does anyone have a best practice in this? Building it myself rightnow, but curious whether people have best practices and tips!…
NUX - Card Configuration - Multiple item selection
As a page builder, I would like the ability to select multiple items in the card configuration. For example, to change the below items from line to column, I have to click through each item individually. I work with customers that have charts made of hundreds of items. If they need to edit the chart, they would have to go…
Data Encoding & Feature Scaling
Was wondering if: * there are Data Encoding features (like one-hot encoding) available to process categorical data into ordinal/numeric values, so that they can be fed into forecasting/ML algorithms available in Anaplan. * there are Feature Scaling (min-max) methods available to bring columns within specified ranges. For…
Can anyone help me with the below mentioned activities?
Hello comrades, Can anyone help me figure out : 1-How to create an employee drop down list to select display name? 2-
Specify Resulting Value for COMPARE Function
It would be helpful if the COMPARE function could be modified to specify different resulting values. Currently, the formula returns 0 if there is a match and -1 or 1 if there is a match. Ideally you could specify any values, but returning 1 if there is a match and 0 if there is not a match would provide a useful…
Activity 4.6.4
When importing the excel file I keep getting an error message saying “import complete but with failures” and the failure is an invalid code. It says US is not the correct code. Anyone know how to help?
Payment every year
Dear Anaplaner, I would like to forecast the payments of supplier contracts. Example: -a contract should be paid every year starting Nov 19. -so next payment would be, Nov 20, Nov 21, Nov 22.... I would like to use boolean to indicate which month should be paid ? Thank you for your help.
Copy data from 1 Year to Next 2 Years
Hi Experts, I have been trying to test some scenarios in Anaplan. One scenario is I have to pick Actuals from Last Year for all periods and copy them to all periods to Current Year and Next Year For instance Current Year is 2020 Last Year is 2019 Next Year is 2021 Data of all periods from 2019 must be copied to all periods…
Ability to create Version subsets allowing to have many different versions without impacting size
Hi Anaplan, As Anaplan grows users will require to create multiple versions allowing them to look at historical information without creating many archived models. The solution to this is to have many versions and be able to subset version lists, therefore saving on space and being able to view historical information…
Formula for current user
It would be useful to have a formula to determiner a user from the users list so I could write lookup statements to source data from modules with users list in dimensions
Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total
Hi, I'm trying to get a formula to retrieve the end of the month total of the line item. I know I need to use the END() function but not sure where to put it in my formula. my formula is below. Thank you IF 'S01 Time Filter'.Allocate to new line item? THEN MIN('Barrowing Base (payment for prior day loans)' + Cash Collected…
Adding a list subset in dimentions while making a module (Level 1 - 10.2.5)
I am on this activity from Level 1 training at the moment, making a module as per below. And it says to add Active? List subset as well as E2 Employees# and Time to the dimensions. I took it as doing this: But I got the following error message instead: I am not too certain what I should be doing from here to accomplish the…
Data Import
Hey I am having trouble with level 1 importing employee data in syso8 it says the following: Import into SYS08 Employee Details module failed: The column headers in the file you are attempting to import do not match the import definition.1 Line Item identifier(s) ("Active?") were not mapped and…
HELP
Hi! I have gotten a little behind because I am a little confused. I completed lessons 1-6 but still have not created a model. Would anyone be willing to help me?
Look Up Function Functionality in practicality
In how many ways can we use Look Up function in Anaplan model in real time ?
Question on Formula
Hi, I'm trying to create a Line Item Formula in where every 10th of the Month/ or next business day, Money comes out of another Line Item. Please advice. Thank you
Having trouble writing Boolean Line Item
Hi, I'm having trouble writting a Boolean Item that checks true if it is the 10th of the Month or the next business day if the 10th falls on a Weekend. The following is the formula I was using but not working. Thank you INPERIOD('S01 Time Filter'.Start of the Month + 9, 'S01 Time Filter'.Month)

Modeling

Discussion List