Modeling

Sorting - List Members
Is there a certain trick or a set of procedure to handling sorting list members. I can control the first creation of list and import the record in sorting order but how does future addition to the list should be done so that they are always alphabetically sorted. I notice that after the first load, newly added members gets…
Too many cells for ISFIRSTOCCURRENCE calculation
I Import a C11 list to 2 spoke models from Hub. I use the same DataHub and Same Hub Saved view to import into this list. However the import into list is sucessful for one of the spoke model but not the other. The saved view and the import definition is the same for both the spoke model. For one the process is completed…
Quarter to month
Hello ^^ How can I convert a line item formatted in quarters (e.g., Q4 FY23) to a line item formatted in months, displaying the last month of each quarter Q4 FY23 =⇒ Dec Q1 FY23 =⇒ Mar etc Thank you
how to copy a lIne item from a module to another one ( Text format )
Hello, I hope you're doing well. I'm facing a challenge and could use some assistance. I have three line item text formats in a system module, and I need to retrieve the information in text format from the same line item with the same name from another module. Here's what I've tried: I went to the target module and simply…
Show a "Used in NUX Pages" column on the New Modules View
In Anaplan Classic, in the old modules view, there is the column "Used in Dashboards" which informs of all classic dashboards using each module. This same concept is needed within the New Module View for New UX Pages, so that model builders can quickly identify all NUX Pages using a module. I know that the opposite is…
Quarter to Text?
Hello Community, How can i go from the line item Quarter ( Quarter ) to Quarter ( Text ) example : Q3 (Quarter format) to Q3 (Text format) Thank you
User access
Hi friends I need to publish a module to the dashboard, there are about 10 line items in the module. One user should only be able to see the first 3 line items where as other user should be able to see last 4 line items and so on. I need a solution for this problem. Thanks in advance.
Level 2 Sprint 3 INV01 Inventory ordering Boolean line items
Hello guys, I've noticed that my Boolean line items have stopped functioning somehow. It was okay when I first created them and stopped working when I added DCA. I checked the formulas and write accesses but they seem fine.... Any ideas?
Conditional Parameter
Hello, I hope everyone is doing well. I have a query regarding Anaplan. I have several system modules where I have created unique IDs, each with a different length. In the user experience (UX) part, it's the UX user who chooses the name of the file to import. Then, the ID becomes the File Name + ID. For example, if the ID…
The Truth About Sparsity: Part 2
In part one I defined sparsity, shared how combined hierarchy lists have been a common technique to avoid it, and dispelled some of its associated myths. I also discussed some issues you will encounter when using combined hierarchies. In part two I will discuss the modeling considerations for handling sparsity and the best…
Text to quarter ?
Hello Everyone, what is the best formula that we can use to go from this to this: Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)
Line Item 'Held or Revised' and 'To change' in Level 3 Sprint 1
Hi Community, I am confused how to approach the line item Held or Revised and To Change in my TAR02 module in my Sales Planning Model. What does these line items mean? I did some experiments with these but nothing fruitful. For reference, this is part of activity 8.2 of Sprint 1 of Level 3 certification.
Search box in 'Model Management' Dialog Box
Hi, When we click on 'Manage Models' dialog box, we get an option to select a workspace. When we select a workspace, we get a list of models to choose from. But in case there are numerous model in a workspace, then it becomes tedious to search for without a search box. Can we have a search box to filter ? Thanks, Aravind M
Show the code instead of the display name in dropdown list
Hello My client does not want to have any display name, just the # generated by anaplan. In the same time, it is very complicated to choose an item in a dropdown list seeing only #s. Is there a method for me to show code of the numbered list ( which is existant ) instead of the #? Thanks
Level 1 Exam - Question 5
I dont know where i'm going wrong.....this is the formula I'm trying to use.... IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: ''SYS08 Employee Details'.Role ] ELSE 0
Multi-language Pages & Object names
As a model builder I need the ability to create multi-language Pages for end users, who work within global multinational companies and prefer to make the analysis on the basis of information in their native languages. I see this as an additional settings tab within Anaplan, where languages can be added in Languаge List…
"Applies to order" in formulae
Does the order that we list LOOKUP: \ SUM: arguments also need to be consistent with the "applies to" ordering? Logically it would as I believe the reason behind this is to do with how Indexes are built in the background but am uncertain and would love confirmation.
OEG Best Practice: Dimension order
Dimension order affects calculation performance Ensuring consistency in the order of dimensions will help improve the performance of your models. This consistency is relevant for modules and individual line items. Why does the order matter? Anaplan creates and uses indexes to perform calculations. Each cell in a module…
List Formated Module Line Items
I have a list of employees This is a master list used across models One of the properties of this list is the Employees Initals I would like to either: a. Select an employee from a drop down but for the "value" displayed to be the initals or b. Use the Initals Property as the source for my drop down Suggestions gratefully…
Publish a list as page selector to a dashboard
Hello, I have a nested list like the following. I want to publish only the parent as a page selector for a particular dashboard without giving the user the ability to select specific child. How can I do that? Parent Child A 1 A 2 B 3 C 4
Level 2 - Sprint 1 - 1.3.10.3 Import Data into G3 Location List
Hey community, I am having some challenges getting the same output as the course shows. I have not been able to get the distribution center boolean to appear in the G3 Hierarchy list. Please see the screenshots below: * Course question and output * My output (missing distribution center boolean) * My location flat list *…
History Check & Roll Back for NUX Pages
Hello Anaplan Modelers, I would like to suggest an enhancement/idea on NUX, checking nux pages history like we are checking for model history. This would be helpful for a team to identify who did what Chages for what page on what day. Also like we are restoring/rolling back our models wherever we need, the same way if we…
How to Identify First Month of Every Year?
End date that should be a working day only
We want to get the End date but it should only fall on the weekday, we have tried other workarounds but it didn't work as intended. See screenshots fyr. END DATE (working days only) = START DATE + Duration Days we also have a module to count the weekends and holidays so to get the END DATE (working days only) END DATE…
How I Built It: Number lists
Author: Soumya Bhattacharya is a Certified Master Anaplanner and technology consultant at Accenture. Hello Anaplan Community! This ‘How I Built It’ tutorial represents one of the benefits of a Number list and how we can use it to dynamically update the module line-item description. This function helps to build a dynamic…
Block / Disable create form action based on a line item
Hello. I want to know if it's possible to block/restrict the creation of an item ( via a FORM ) based on a line item. For example, if the total wallet = 0 then the user should not be able to add and create a new item. thank you
Add Folders for Modules and Lists
Similar to the idea posted here, but with this idea could be a possible solution? * Add folders to object contents (e.g. module, list, and actions). * Allow the creation of sub-folders. It goes without saying, but this would really improve model organisation, especially for larger models. The functionality could be similar…
More advanced Grouping, Sorting and Filtering of the lists of Modules / Dashboards / Actions etc
During Anaplan training a user creates 5 or 6 modules / dashboard etc. Easy. Our model has a staggering list of actions, modules and dashboards. In our model are we have: * 593 Modules * 248 Dashboards * 1767 Actions Model builders need a more robust wayto manage this. Having the ability to filter these lists by a type…
Smaller Time Range | Less than a year Time Range | Day granularity
Anaplanners, I would like to have a time range in a granularity for less than a year. Somewhere between a month or a Quarter. We have a business requirement where we have to import and export working hours for each user per project per DAY. This activity will be monthly and may not be necessary to have more than a month,…
Changing a workspace name & model names
Hi guys, So I have a question and I hope that you can help me. I have a workspace containing many apps but its name isn't really relevant. Same for some of the apps within this workspace. I want to change their names and I was wondering if there were some risks linked to that change. For example with Datahubs or other…

Modeling

Discussion List