Modeling

Lvl 3 TAR04 Account segment total by country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the individual segment data(small,medium,large) aren't. See attached image; first grid is my build and second the one from training. I checked my system module and all segments are mapped to each account. what is it that I am missing?
Anaplan Level 1 Certification cost and support
Does Level 1 and Level 2 certification cost me anything? Will able to download the Anaplan Certificate after completing both the levels? What does instructor led version mean? Please brief. Please find the attachment.
Ability to add multiple values to a text filter
Description of the enhancement required: Text list filter delimiter An example of the enhancement: Text line items can be filtered by more than one value. How would it help their business process: Filter of text string with a delimiter. Want to be able to set a filter on a text line item for more than one value without…
Get to know the model experience as an end-user
Welcome to the Anaplan modeling experience (MX)! The Anaplan functionality you know and love, with a modern look and feel and simplified, intuitive navigation. In February 2023, the updated model experience became the default for all users. In April 2024 the ability to toggle back to the old classic experience will be…
L3 Account Segment by Country
Hi, I was validating my build of TAR04 module. While my All Segment data is matching, the segment data aren't. See attached image; first grid is my build and second the one from training. My understanding is that this would happen is I dont have the right Segment for each Account. Can you let me know if this is possible?
Help me with this issue.
I have this two modules: AND I want to pull the territory ref ID sys/fil07 to the inp/ter01 so it would only show territories available for that employee, i have tried to do loots of formulas but they dont seem to pull it correctly, not sure if because inp/ter01 is made with subsets its messing it up or something is wrong,…
Data allocation from one level to other in different module
Hi, I have 2 different list (L3 and L6) I have 2 module, 1st module has L3 list is used and 2nd module with L6 list is used. User able to enter data in 1st module (L3 list) and data should be copied into 2nd module at L3 member--- 1st ask and data should be divided into L6 respective child members evenly. Thanks, Asha
Bring line item value from parent to child, distributed equally, from one module to another.
Hello, I have a list hierarchy that looks something like this: * Department A (Parent)* Office 1 (Child) * Office 2 * Office 3 * Department B* Office 4 * Office 5 * Department C* Office 6 I have now created two modules, one where Department list is a dimension (Module Department) and one where Office list is a dimension…
How do I find or trim an inconsistent string of characters in a line item?
I am currently importing data with a concatenation of 3 General Ledger identifiers and a customer code. A sample would look like LE10000.LMF10000.1000000 for the first GL indentifiers. Everything is consistent and All LEs are 7 digits, all LMFs are 8 digites and all account codes are 8 digits. I have customer codes that…
Data hub - What Data should reside in Data hub
Hi Team, New to Anaplan Modeling. Based on the training, its my understanding that data hub is important to act as source of truth for data that is shared between multiple spoke model. I see data hub as a repository for list, hierarchies and data modules that are shared in more than one spoke models. My question is what…
Model impersistence across pages in the application
Our case: We are separating clients data into different models and manage access via those models administration We have a single application that points to those models and allows users who have access to switch between them (assuming that they would switch between clients data sets) When user switches pages of the…
Increase the Cell count limit on line item blocks for Anaplan
As a model builder, I would like to see Anaplan increase the upper limit of cell count on a single line item block (currently it is set as 2,147,483,647 = 2^31-1 cells), so that I don't have to model certain filtering modules/logics outside Anaplan. I know this is successful when the limit is increased to 4,294,967,295 =…
'Used in Dashboards' and 'Used in Action/Import' for SAVED VIEWS
When performing model clean-up's OR revising actions / New UX dashboards, it would REALLY helpful to have a view within the model settings area to review the full list of SAVED views along with the following key information; * 'Used in Dashboards' * 'Used in Actions/Processes' * 'Used in New UX Dashboards'
Count items in a flat list?
Hello, I am trying to count how many items are in a list and display it in a module? In the example below we have 3 items in the list. Does a function like this exist?
Filters on import to list actions
As a model builder, i need to be able to filter the list items created based on a criteria. This is required as we currently operate models that determines a calculation scope of contracts and the needs to import the corresponding cashflows to calculate profitability. Currently we need to import all cashflows from our…
Versions as list format
Make Versions available as a list-format. Benefits: Allows the end-user to select the version they want to look at from a drop-down making for better variance reporting. Allows you to map from a normal hierarchy into a version dimension *Excel add-in needs to support & support with filters
Introducing the Connected Planning Playbook
Connected Planning isn’t easy. That’s why we can’t help but smile a bit when we hear our customers and prospects say, “Well, of course, Connected Planning at Anaplan is great. It’s what you do!” The reality is: our own Connected Planning journey was hard. And, if it was hard for Anaplan, it had to be hard for our…
Additional practice models/builds
Hi Anaplan Community! I've completed the certified builder program, but am wondering whether there are any additional practice builds out there that I can attempt? e.g. I'd like to practice building an ICM/SPM model. Thanks!
Train the Trainer
Will there be "Train the Trainer" courses beyond Level 2, so our Team can be certified Anaplan trainers? If so, has the course changed titles? We can't seem to locate any current "Train the Trainer" courses. Thank you for any help you can provide.
List item has nothing showing in 'Referenced in Formula', but it is referenced?
I have a list that shows no references, and i was removing ‘dead’ lists however, when i tried to delete it i got an error saying it was used in a module. And after looking i found it was indeed used So why does the reference not appear in the list information?
Ability to record timestamp of input as a separate line item
It would be extremely helpful from an end-user and a workflow perspective to have the ability to capture the timestamp of a manual input as a separate line item, instead of having to look through model/cell history manually. That way you could easily see when the latest input was entered.
Building a Long Range Planning Model
Hi, I'm a new Anaplan user (completed L1 model builder). I'm starting a project to get our current Long Range Planning model from excel into Anaplan. This is my first project and I'm wondering whether other group members have any similar experiences. There is a template LRP model in the App Hub which I'm considering using…
Level 1 Modeling Activity #5
Hello - I have been having similar issues with the formula updates to the Bonus%, Car Costs, Phone Costs and Medical Costs in the EMP02 Module - when I try to update the formula as below I receive the error message. I am seeing posts about removing the Role List and reimporting without the Parent Column and the reimporting…
SKU to Format, Flavour, etc
Hi Guys. I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3. The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore…
Retrieving user selective access in module
Hi, I have an issue in my Workforce Planning model I can't quite get my head around. The scenario is the following: I have an organisational hierarchy with Cost Centers and then Individuals as childs. I have selective access enabled to my cost center list and only certain users have access to certain cost centers (and…
Is it possible to have a "Create" Action on a list with no parent?
Is it possible to have a "Create" Action on a list with no parent? If not then is there a workaround?
Schedules Mapped by Entity Name in Anaplan
In Anaplan, I have a schedule that needs to have the name of an entity name change to the English version. I was put on notice recently, that the schedule is being mapped by the entity name. Can anyone provide guidance on how I would be able to see in Anaplan exactly how that schedule is being mapped by entity name and…
Sum based on Parent in Hierarchical List
Hi, I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item. How can I calculate this sum, as it is the sum of all items in L3 under L2 a…
Level 2 - Sprint 1 - 1.5.2
Review DAT01 Beginning Inventory Module * Module Name: DAT01 Beginning Inventory * Dimensions: SKU Flat list, s Location Flat: Distribution Center? list * Category: Master Data Line Item Format Purpose Beginning InventoryNumberBeginning inventory count (opening stock) for each product SKU by Distribution…
Retrieving last non zero value for daily exchange rates
Hi, I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 2021 but none for 2nd and 3rd of Jan 2021, so the daily exchange rates for 3 Jan 2021 should display the rates of 1 Jan 2021…

Modeling

Discussion List