Model Builder

Create Shipping Export Module and Create a Saved View
The question dont know why it is empty Everything seems perfecrt but why there is only ZEROS ? Help please ?
Sprint 3 exam Doubt Country made in
hello for the exam question to find out stock expection for all the prodcuts for Mar 20 for countries . as per the data i have uploaded it shows me 14 and the list of the countires but in the options there are not more than 5 countires i dont know where i made mistake and i feel all my formulas are correcT . can anyone…
3.4.3 Activity: Create Country Summary Module
Hello can anyone please help that formula for country made in is correct ?
3.4.3 Activity: Create Country Summary Module ux page conditional formatting
hello I am stuck at this because I don't find the proper conditional formating option in custom view to create the above said condtion to highlight great than 0 ; what i have is to write min and max value
Top five new model building tips and additions that changed my life
Author: Ayesha Zoha, Certified Master Anaplanner and Manager at Cervello. As we all have started using the new modeling experience, here are my top five features which have made model building easier and more efficient: Formula indentation. One of the significant additions in the new model building experience is the…
How do I convert the format from Text to List?
When I edit the format and switch from text to list, I get the following error message: "Format of mapping used for lookup doesn't match any dimension of the source." How do I fix this?
Step-by-step: User-based sorting
Author: David Edwards is a Certified Master Anaplanner and Principal at Columbus Consulting. While there is sufficient documentation regarding how the user list can be an effective tool for UX filtering and dynamic cell access, there is also the opportunity to leverage users when designing custom sorting functionality…
3.5.3 Activity: Create Distribution Center Summary Module
my whole data is ZERO , can you check my formula is correct etc
3.5.5 Activity: Create Distribution Center Summary UX Page
Hello Can anyone help me how to get rid of the values in the line items in product SKU by Distribution grid ? i have created a saved view for distribution centres which is has values . but to get the final results to show only the dimensions without values how it is possible as per the requirements ? even if i turned on…
3.6.1.1 Create Product Supply Manager Role
Hello can anyone help in saying the the logic how to apply these conditions ? first create the roles and give the read write access to the modules ? create access control module for products and SKU and map their names to it ? how ? im totally confused how to do the logic when to create access control module( DCA) and…
Module to module import problem - list item mapping problem?
Hi Anaplaners, I have created a module-to-module import action within the same model. The source module and the target module have identical dimensions, line item no., line item format etc. However, it seems like there are some kind of mapping problem for the team list. As you can see from the below screenshot, in the…
Begining inventory Sprint 2 and 3 level 2
Hello I was working on inventory module but somehow i did something and my nos got changed in the begining inventory . now it shows only the total sum instead of 13000 for nutzo bar en can i know how to rectify it ? i dont know how it got changed etc
DCA Related Question
suppose you have used user list on a line item and you have received a read only access here. The value in the cell is 100, And then you have imported the data into the module from a CSV file so, what will happen system will update the value into the cell or it will not update it ?
Problems with new custom chart palettes - dec 23
i I have created a custom colour palette Problems 1 only a max of 20 colours possible 2 when choosing the custom palette in charts, it displays the colours in the order of the custom palette but when i choose to select a different colour; it does not show me the colours of the custom colour palette; so i have to choose the…
Creating Scenario Planning in Anaplan
Hey Folks, I am considering building a couple of scenarios to my base case by creating a new list called "Scenarios" in my model. Really the only driver for all different scenarios is going to be "number of new heads" so i think I can do away with adding the new list in only a few relevant modules on a need basis. I want…
modify email notifications?
My client is sending a email notification and there is some weird formatting things in the notification pop up: it shows Recipient and no space between Recipient and the email address. Also, the Recipient context doesn't align, it steps down. It looks messy. Is there anyway to make changes so it looks neater and more…
INV01 Inventory Ordering - Summary method not adding up well
Hello, Could anyone help me with the monthly totals of "INV01 Inventory Ordering" module? I think I have the rights setting ( see picture INV01 - Summary setting), but as you can see in picture INV01 - Summary error, it is not adding up well. Find attached the summary settings for module AD02 too, as it affects the…
Can a create action be added to a process?
I have a client who wants to add a create action to a process. He's not sure that this type of action can be added to a process. If this can be done, can you please provide instructions? Thank you.
Chart Palettes Dec 2023
Hi I like the update. However I noticed an issue; once you create a custom colour pallette for charts you cannot edit it if you want to change colours for example. You have to create another one(time consuming) Any advice? thk u Ravinder I found the edit button now: BUT the max number of colors has been reached - only…
Allowing users to submit confidential requests
Audrey Neet is a Certified Master Anaplanner and Principal Solution Architect at Tru Consulting. In most use cases, we can rely on selective access to control who has access to what list items in a model. However, there are a few use cases where a stronger level of access is needed, such as access given only to a specific…
3.3.5.2D Remaining Line Items , Reorder flags
Hello can you help me in perfecting my formula ? Reorder Flag: Identifies the week that an order must be placed before the ending inventory would drop below 0. As you see in the week 11 FY20 column, the reorder flag is not ticked even though the value is negative My doubt is, as per the hint, they suggested the use of the…
3.3.5.2A Beginning Inventory formula
Hello I need some help in this formula Beginning Inventory: This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week for all other weeks of the year. i have just created these in my…
How do you import line items from one specific list in a module?
Hi, I want to import data from a module contained in another work space. This source module only has one list with no top level. Specifically, I am trying to import the line items from one list item "Cost". On my attempt, I tried the following steps: Pivoted the list item needed as a page, and the line items in rows…
November 2023 Community Q&A Challenge — join the discussion and collect a badge!
Building on the incredible success of our inaugural Community Q&A Challenge in September 2023, we're thrilled to announce our second Q&A Challenge! In the Anaplan Community, we've always believed that the key to success lies in members coming together to connect, share knowledge, and support one another. Your enthusiastic…
Level 3 4.6.5 Sale Planning Model: DAT01 module
Hi Community, I was wondering if I did my DAT01 correctly? Because to import DAT05 historical sales from Datahub to Sales Planning module, I will need to set both dimensions as A1 Account and P2 Product list. However, when I start to build DAT02, my dimension was A2 Accounts>Product list (according to the learning module)…
Add new line item to import action
Is there a way to add a new line item for a source module into an existing import action? I have created a new line item 'X' in both the source and the target module. The new line item 'X' appears as an option to map to in the target module when editing the action, but it doesn't appear in the source module list to select…
Do ignored columns (from imported files) take up space from my model?
Hi guys! Do ignored columns (from imported files) take up space from my model? Thank you very much!
Can't add a parent to a existing list
Hi all, I am having some troubles adding a new hierarchical level to an existing list, which is called BU01 Business Unit and it's not a numbered list; the new parent should be BU00 Business Unit Combine: If I try to compile the parent hierarchy column, I get this error: If I try to delete All Business Unit from the Top…
Button on Dashboard not working
The picture above highlights the problem, every time i use the button Add Sub-GL/Vendor Item, the chart to the right should update with the name, GL account, for each department. I tried to add a new vendor expense under admin finance and legal called "anaplan", the gl account i choose was called software/subscriptions.…
Building a pyramid visual using a bar chart
Author: Subham Garg is a Senior Data & Insights Architect at Anaplan. Anaplan doesn’t have a pyramid chart option for reporting. However, there are certain metrics that work better with a pyramid chart than any other chart format. For instance, sales pipeline or number of employees at different ranks in a company are best…

Model Builder

Discussion List