Modeling

Ability to refer to the total of all line items in a module
Presently to get a total of all line items in a module we have to create another line item and manually add the other line items in the module. This is both time consuming and error prone. Also if there is ever a addition of a line item in the module the formula for total has to be updated. Instead if we had a simple…
Anaplan Way Certification
Hi All, I want to enroll for Anaplan Way certification but it is showing to enroll in classroom classes. Kindly guide me on this how to enroll for Anaplan way. It would be helpful. @Misbah Thanks , Ayush Srivastava
level 1 exam activity 5
added all the formulas for bonus ,car allowances,medical...but adding all car cost, medical are showing zeros
Optimizer: Dynamic Time Setup
This video will demonstrate how to setup a dynamic time list for use with the Optimizer. Download the attachment for instructions on how to setup Dynamic Time. https://www.youtube.com/watch?v=hD7Wt4wcxwM
Optimizer: Exercise Walkthrough
This video is a walkthrough of an Optimizer exercise. Download the attachment for a printable version of the exercise instructions. https://www.youtube.com/watch?v=rwwXAB9Rbp4
Increase the limit of list item beyond 999 999 999
As a anaplan coe lead, i need to enable more complex and scalable use cases into anaplan and integrate seemlessly with high volumes system working with event or log based architectures. To cover these, one limiting factor is the hard limit over the 1billion minus one on lists. I d like to have this limit raised to higher…
How to look up first instance of a numbered list
I have a module (Module A) that applies to a list. Job Title Salary Bob John Katie I have a different module (Module B) that uses a numbered list. The display names of the numbered list matches the names in the regular list. How do I look up the first instance of the "Job Title" in Module B so Module A shows Bob's Job…
Level 3 Sprint 2 Assign action [Finalize Assigments button error]
Hi Good day, Invalid selection message Can anyone give me some hint? Thanks
Error message L1 model building - 6 Module 6.6.5
The formula for 'SYS01 Time Settings by Year'.Forecast Year? is invalid: Forecast Year? = 'SYS00 Time Settings'.Forecast Period? 'SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member I received this error message when I try to enter formula to the line item Forecast Year And I am also not sure…
Enhance Users list with Subsets by Role/Manual/etc
We use users list in many of our filters modules/line items but the usage of the filters might be only for some set of users. We don't have option to use the relevant people only in users list for these modules. Which will result in more sized modules. Having option to manage subsets in users list by role or by manual or…
Trigger an action with a boolean
It would be nice if we could trigger an action and/or clear a line item based on a checkbox. For example when overriding values, we often use an "Override?" boolean to make a line item writable. If the user unchecks it he expects for the input to be cleared/reset. This can be achieved with an additional action, which is…
Level 3 Sprint 2 Employee Details into G3 Sales Reps
Hey Team, I have encountered some issue(s) with importing the datahub saved view employee details module into the G3 Sales Rep list in the Sales planning model. After a completing the import, the results (per the attachment) are not the employee names but numbers. Could you advise on how best to quell this issue and…
Sum function not working correctly
Hi, I have a data module with Dimension E3-Emp. This data module has following dimensions as List type Line items (Site, Tier, Rate, Tenure) When I try to create a module to group Emp HC by Site, Tier, Rate, Tenure and E1-Emp Class ( Super Parent for Emp). The result doenst look good. My formula 'DATA01 EMP Roster'.HC[SUM:…
Level 3 Sprint 4.5 Finalize Assignments Action Button
In the screen shot for 4.5, there is an action button for "Finalize Assignments". I have read through the user stories and the in the build steps and I cannot find any reference to this. What does this action do?
Export View with 4 dimensions to the left side and time in the columns
Is there a way to export with 4 dimensions on the left side and time (months) in the columns? I created a saved view and used tabular multiple column export (filtering the specific months with a boolean in a separate module). However if I put the line item and time in columns it errors stating line items must be in columns.
SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member
Hi team am receiving an error
Removing unnecessary Top Levels
Removing unnecessary Top Levels (or better yet, not adding them in the first place!) Author: Allison Slaught, Certified Master Anaplanner and Principle Solution Architect at Anaplan. To improve efficiency in your models, it’s important we only calculate where necessary. One way we can do that is to only use Top Levels…
L2 Sprint 3 - 3.3.6
Can anybody please help me with why my data is showing 0 instead of 16388 in Confirmed Purchase Order Receipt (week 3) after following the instructions in the screenshot? I have applied the following formulae: PO Submitted: IF Submit Purchase Order Request? THEN 1 ELSE 0 Confirmed PO Delivery: POST(PO Submitted, Final…
L2-Sprint 2, DEM03 module
Hi, In L2-Sprint 2, DEM03 module we created few line items and applied some formulaes, after applying formulaes the data is populated for only FY2020 since we have only 2019 actual data we pulled the data from 2019 to 2020 by applying OFFSET function. In DEM03 module, for Baseline forecast line item we applied a formulae…
Module Lines System Generated 'Created by' and 'Modified by' Detail
All module lines should include system generated "Created By" and "Modified By" detail for audit trail, compliance, and support reference. It is not always clear as to whom created or modified a line in a module. If a consultant or contractor is making changes to lines, the only way to find that detail is by combing…
How to import Negative Values from txt files
Hi All, I am importing data from tab separated txt files and I noticed wherever the values are negative, its populating as positive numbers in Anaplan. As shown in above example the negative values are denoted by a negative sign after the number in the txt file. Is this format supported by Anaplan? Thanks in advance
Allocate a summary level data input into other
Hello, In one module, I want users to enter one growth number for a country. I then want that growth number to be applied to every single product in that country (in another module). There are thousands of products in the country, so I don't really want to have to enter the same growth number multiple times. However, I…
List Properties - show on UX?
Hello, I am guilty of using List Properties extensively to ease export referencing, and I am aware of the need to 1.05-03 Avoid using List Properties - however, this can be a really good tool that saves on line item space. Does anybody know if it is possible to present List Properties as part of a table in the New UX, or…
Sync on dashboard
Hello All, Hope everyone is doing good! I have 2 different grids on a dahsboard and both are pointing to a common dimension, however when i select a project in one grid ( top one with one of the dimension being the project ) the bottom grid is not in sync with it ( its not chaning the project ) , I noticed that the bottom…
How to update the Date as Blank from import Action
Hi, How can i update a Date Column which already had Valid Date with BLANK from Import Action?
Add back the 'Used in Dashboards' reference for Modules (with NUX)
With the NUX in place and being the standard for dashboarding, it would be good to have the ‘Used in Dashboard’ reference working again within the Model. This would be good for the transparency/auditibility of the model, for all users. With the Classic UX, it was easy to see when a Module was used in any of the Dashboards.…
how can to get more command on writing formulas in line items
It will be helpful if you have provided some suggestions or resources to gain more knowledge
User Stories - which "tool" should I use when writing them?
Hi guys, Which tools/softwares (excel, word etc, TAW app) are you guys using when writing User Stories? Is there any nice templates out there? Regards, Stig
Options to improve performance when loading flat list used in reporting
Hello, I'm loading flat data between 2 Anaplan models and in the target model, I'm using the Sum function to dimensionalize the flat data into a reporting module. The reporting module needs to have 5 lists + time and also requires summary to be on so data can be reviewed at aggregate levels. As a result the import action…
Position of Totals
I have two nested dimensions, A & B, in rows and time and line items being in columns. I want to show time totals (All Period and Qtr) first and then the months but even if I sort, Anaplan defaults back to its general time sequence the moment I put Line Items in Columns. I don't want to manually select and then show time.…

Modeling

Discussion List