Modeling

Filter using Selective Access on Line Item Specified as a List
I have a data set I would like to open to end user with a line item (Cost Center) set as a list(also cost center) with Selective Access enabled. I would like the functionality to filter the data set so that end users will only gain access to their respective Cost Center(s). I know the workaround for adding cost center as a…
Automatically remap line items in import actions
As a model builder, i would need that in the following conditions : - an import mapping uses manual mappings for line items - the source line item name(s) are changed in the source module, that the manual mapping would be updated automatically or alternatively that we get a blocking mechanism that alerts us upon trying to…
Inputting a formula based on range of dates
Hi All, I'm fairly new to Anaplan and have a module that gets start period and end period. What I want to do is use these time range in order to set a specific amount based on a formula. I want to apply a specific formula on the time periods with respect to the start period and end period. To give an example, in one cost…
Level 3 Models - Time Settings - Should we consider the year as 2021 or 2020?
Hi, I started doing my L3 certification in 2021 and found that some of the data files provided in the training course had 2021 data while the Check your build sections had snapshots of 2020 model data. So I am confused about the time settings we need to use to build our models, should it be 2021 or 2020? I have completed…
Rounding issue
Hello, I'm having an issue in which a sum of rounded items is still showing some unexpected decimals. See screenshot below. Is there a workaround for this other than using formula as the summary method? Thanks, Josh
Error Message
Hi, I have a error message that keeps on popping up when I'm trying to create a formula. Please advice. Image is attached. Thank you
Summarize Boolean
Hi there, Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the expected result when I was implementing ANY & TIMESUM functions. Please advise me. Thanks,
Ranking across Multiple Dimensions
Ability to rank dynamically can be achieved by using the Group by property/parameter in the RANK function. We will need to determine a method for calculating a group by value based on the values selected by the user. Normally, the RANK function is fixed to the dimensions in the grid, but in our case, we need it to change…
Importing Multiple Rows based on a Quantity Value based Cell?
Hi Everyone, I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item? For example, if I wanted to create 5 new employees that will have the same salary and reside in the same state and cost center. Is there any techniques that…
Import and Automate Current Date Import to Anaplan Using Python
Connect or Python Summary As a supply chain Anaplan data integration modeler, you might be asked by your business partner to display actuals for elapsed periods and forecasts for unelapsed periods. If you are not using the current period, which must be manually updated by a workspace administer, and you want to automate…
Get code nex to list item in module dimensioned by time
Hi, I have the following module: Lists: E1 Employee Time: Month Versions: - Line Item: Salary I need a pivot with the employees as rows and month by column. All fine uptil now. But then I would like the employee code to show up next to the employee list item name. What would be the best way to go about that? If I add…
Smart Filter not working in NUX
Hello, We have a dashboard which features a smart filter for sales rep. When you select a name from the smart filter, the corresponding grid's selector only holds the accounts owned by that rep. This functionality is fully operational in the classic dashboard. However, when we imported that classic dashboard into the New…
Be able to see subsets below their parent list in the Lists tree
It could be great if we could see in a tree view the lists and their attached subsets. It is particularly useful when exploring a model previously created by someone else.
Backup - Archive PY cells
Rather than functioning towards excel for the previous year / excluded year data to save for future. There must be a process which will archive the data as soon as year got changed in TIME settings (with the warning popup) within given model and ready to refer as and when require. [Benefit]: Get rid of multiple models…
Auto Suggestions towards model improvements
Anaplan must offer a functionality which auto suggest (time and again) what are the least referred lines items / lists / modules from model optimization point of view. This will help dev team to optimize the model with the unnecessary objects. (e.g. Business may get a big / small list implemented but over the period of…
Creating Formula Question
Hi, Would like to know how to create a Formula with the following structure for a Line Item (1). Closing Balance of Line Item (2) as of the end of the month, and this will show/happen only on the 10th of every month. My attempt END(Line Item (1) OFFSET( Closing Balance of Line Item (2), ?, ?) Please advise, Thank you
A way of determining redundant list items; list items with no data in any module
I'm looking to ensure my modules are as small as possible. In addition to other optimizations I would like to ensure every list item that is contained in some of my bigger reporting modules is needed. I'm defining 'needed' as there is some module in my model that uses the list it's within and has some non-zero value for…
Level 2 Sprint 1 DAT03 cells blank
I am at the end of Level 2 Sprint 1. I am going through the checklist to make sure everything was completed. When I got to DAT03 I noticed there is no data in any of the cells. When I did the first import, there was data there. So, I reimported the data from Historic Volumes and it said the import was successful, but I…
Formula
HI, Have a module with assets and time dimension, some of the assets starts from the middle of the year. when on selection of total assets, The "No of payments" lineitem not showing sequential numbers and anaplan is not accepting(ss for the same) the "formula" summary . Below is the formula for No of Payments = IF…
Calculations using list items within a line items?
I have a line item that needs to reference one of the list items instead of a line item. What does this mean? I have a list of staffing types that use a model configuration to calculate based on what the user selects. Each staff type is mapped, then calculated off the drop selections the user picks. The main one is the…
Help with Level 1 7.2.1
Hello, I've tried a handful of combination with this import, but I'm just not grasping the mapping concept even after the tutorials. Could someone please help me match this up? Thanks
Circular reference
hi, have 3 lineitem, a, b,c wherein c= a+b, a = previous(c), b= a*rate of interest, But, however, getting a circular reference when writing a formula in the lineitem "b". Below is the screenshot of the explination, Any help is highly appreciated.
LISS changing look and order when using as Dimension
Hi, I created a LISS for my P&L but when I then use that LISS as a dimension for a reporting module it changes completely - see attachment for example. I've tried re-creating the module as well as another LISS from same source module but I still get the same strange result.. Best regards, Johan
Level 3 query
Hi Friends, I am not able to understand the exact requirement of the question. What is the total sales target for the medium sales account in Canada?
Enabling Subsets to be maintained from user interface or even a formula.
Sometimes there is a necessity to be able to update the Subset from the User interface. For example when you add a new Equipment and you are using a list of subsets to limit the size and selections. In this case it is only possible to update the Subset after you have created the list member. It is an inconvenience and…
sumif excel equivalent
Hi, I'm stuck on a sum select formula ?? Circuit Pull.Project[SELECT:Projects.X, SUM: Circuit Pull.Range] ?? Essentially what I'm looking for is to hard code a specific project below, project 2 but I can't figure it out in anaplan. Thanks in advance!!!
source and targert modules are dimensioned by two different dimensions
How can we link these EMP02 and REP04 modules to get total car costs by the region and role. When I am using formula i.e car costs = emp02 .carcosts[lookup: sys08.region, lookup.sys08.role] it is throwing folowing error. I under stand my REP04 is dimensioned by Region and Role where source module Emp drivers dimension by…
NEW UX - Export Boards as PDFs process
Hi Anaplan, It would be great if the NEW UX had the capability to export boards as PDFs for reporting. Many customer are asking for this as they have previously created many reports using this in the OLD UX so would like to see the functionality in the NEW UX. Thanks, Usman
Dependent Page Filters
I have a view published with list-1 in rows list-2 in columns list-3 in pages list-4 in pages. The dropdown for list-4 is dependent on item selection from list-3 and vice versa. Filters are created for that but when applied, I couldn't see the option of Current context. For Example, List 3 has A,B items List 4 has a,b,c…
Creating formula question
Hi, How would I create a formula that would give me the number of days in a given month?

Modeling

Discussion List