Modeling

exam 1 activity 6
why my region row is blank
exam level 1
stuck in Activity 2 i am stuck here please help
Parent hierarchy & Top level
Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and another is child list (say 'Y'). Now here in first list 'X' (which is parent for the other) there is only 1 member 'All X…
Ability to import a table from a report page to a board or worksheet
Hi everyone, I was wondering if it is possible or if anyone knows how to move a table from a report page to board or a worksheet. In this specific case I had to use a report page in order to use the "variance in report pages" functionality which does not exist neither in board or worksheet pages. This is what I have…
Statistical forecasting App in UX
Hi all, I can see that there's a statistical forecasting App on the App Hub that can be downloaded but it looks like everything is in Classic dashboards. Does anyone know if there's a version of the app that uses the UX? Thanks
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
Compare TEXT Values in Anaplan
Technical Summary Statement The objective of this article is to compare values in a TEXT formatted line item and identify the values that occur more than once (duplicates). Problem Statement Sneakerz is an up-and-coming shoe company with a variety of shoe brands in its brand portfolio. They are expanding internationally…
Time to Tidy: No More Mess in Your Models
As winter is now behind us and the annual process of “spring cleaning” begins, I find that it is a good reminder to not only clean and organize my house, but also to clean another area that most likely needs some organization: my Anaplan models. The beauty of Anaplan’s platform is that it gives the model builder an…
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
Reset boolean when selecting a new hierarchy in UX
Hi all, Hope someone can help me I have a 2 grids connected and set with restrictive access, What happens: First: When I select the country (1st card) to be updated on the graph (2nd card). The selection is kept when I change region. Example: US-Chicago Second: But if I change region to Europe, the Chicago previous…
LEVEL 2 SPRINT 3 INV01 3.3.7.2
@JaredDolich I am at the point where I have added DCA to INV01 and added formulas to AD02. My numbers do not match the example given. I know in the past I've been told not to worry about the numbers being off but is that the case with this example? Here are my numbers: Thank you for your help.
View access based on User list
Hi, I have a module where users create New Cost lines. Since the security is based on Groups, users can see costs created by other users within the group. Now the ask is that users should see the costs created only by them, for example, User A would see cost items created only by A, B should see only B's lines etc. Note…
Pulling value from another line item in the same module
Hi I have an Emp List. An employee can have 2 records in the list (the 2nd one with an extension ABC OR). I need to pull the values of the 2nd record in another line item of the 1st record. Could you please suggest how to show the values in Red below? Thanks Is ABC OR?Projected salesABC OR SalesJohn DoeY1000520John Doe ABC…
DYK S2 - WEEK 3 (Updating Source Objects)
Third Modeling Tip. Watch this video to know more DID YOU KNOW S2 - WEEK 3 - YouTube Thanks, Misbah Miz Logix
DYK S2 - WEEK 2 (TEXTLIST)
Second Modeling tip. Please watch this video to know more DID YOU KNOW S2 - WEEK 2 - YouTube Thanks, Misbah Miz Logix
The new Modeling Experience is here!
If you attended ACE 2022 or have been keeping up in Community lately, you’ve probably heard about exciting new changes to the Anaplan model building experience. That’s because the new and improved Modeling Experience will soon officially become the default modeling interface, but you can start using it today! Though the…
"Referenced in formula" for list subsets
As a model builder I want to be able to see where my list subsets are mentioned in formulas. Currently this column is presented only in General Lists section but not in the subsets tab. This is a screenshot from a General Lists section: There are "Referenced in Applies to", "Referenced as Format" and "Referenced in…
[Start here] Modeling Experience
If you are an experienced model builder, you are already familiar with the power and flexibility that the Anaplan platform provides when solving your teams' planning needs. In February 2023, we made the enhanced Modeling Experience (MX) the default experience for our users, and from April 2024, the old classic interface…
6.8.6 Activity: Add Formulas to Location Details Module
Hi Team, I got the error message in 6.8.6 Avtivity, I couldn't create formula here, anyone help me? Thanks
level1 lesson 11.3.4
i am unable to set the Formula
level 1 lesson 11.3.4
i am not able to apply the formula
Top Level Item and Parent Hierarchy
Lists in Anaplan have two main settings related to how data is aggregated: * Top Level Item * Parent Hierarchy They may both be set on the “Configure” tab on the List settings screen. Top Level item This list has been set to have a top level item, “All Regions.” When used in a module, the top level item contains the…
Summary Settings in module Blueprint view
I'd like to know the difference of Summary settings combination in the blueprint view between: Summary- Formula, Time Summary: Same as main summary vs Summary-None, Time Summary: Formula If possible can anyone explain me with a small sample data like this:
Tell us your thoughts on ALM via a short survey!
Customers and Partners, Please take this short survey, which should take you less than 10 minutes to complete, to tell us your thoughts about ALM. Thank you, User Experience Research Team
level1 10.2.1
what would be the formula of total here?
Pricebook to flow down from Parent to Child
Hi, The above are currently in the system where L4 is a list of distributors. I do not want to touch/amend since i am new to Anaplan and do not want to mess up anything. I created a new list as below; I have created a system module to link L3 distributor to L4 Customer in the earlier list. After which, I have also created…
Applying different formulas to list
Hi, i'd like to ask about how to apply different formulas on each item in a list. As You can see, Module 1 shows actual data from the current month. Module 2 is a forecast module, where the baseline column is from the previous month actual data, while the Growth % and Growth column is an input column for expected growth…
How to create a module where i can link existing module to a new list
Hi! Not sure if the subject header make sense but here it goes. I have a existing module that have pricing by distributor by month by SKU, example and lists used as below; Different distributor will have different prices by SKU The above are currently in the system which i do not want to touch/amend since i am new to…
lesson 10.2.5
how to change time to closing balance?

Modeling

Discussion List