
Model Builder
Model Builder
Discussion List
- 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, t…
- 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 t…
- 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 "…
- 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…
- 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 Produ…
- 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 …
- Hi guys! Do ignored columns (from imported files) take up space from my model? Thank you very much!
- 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 Comb…
- 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 …
- 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 char…
- Hello Everyone can I know why there is a circular reference error when I try to enter this formula ?
- Hello Everyone I have finished Level 1 and got the certification and continued to Level 2 introduction class, and I have finished it . but when I opened the sprint 1 class, the cursor was not changing…
- On the Actions and Modules tab, similar to the 'Used in Dashboard' column it would be useful to have a 'Used in Pages' column which shows where action or module in used.
- The ability to edit and set the default column width in maximized view would improve the user experience immensely. Now users need to adjust column width every time they open a maximized view which is…
- This is the screenshot of the module containing both boolean line items.
- Hi Anaplan Community! I am working within an Operating Expense financial model, I have a module to allow for manual adjustments by department. This module contains a line item "Amount" with no formula…
- Hello It's will be helpful to have the drag and drop functionnality directly on each line item in order to rearrange easily on purpose Regards Patrick
- I've encountered a strange issue in our model. To give you the context - We run a scheduled process through REST API to copy data from one version to another version. We tried running this using cloud…
- Hello It's will be helpful to have drag and drop functionnality in the Actions page in order to rearrange them inside their respective bloc (Process, Import, Export or Other Actions) so it will be eas…
- Hi, I have created a LIS from two different modules with a total of 3 line items. The two line items I selected from the first module however are having a parent child relationship when I use the LIS …
- It would be useful to have a preview window of the results of development done in a model before creating a revision tag (for synchronization). This involves setting up the ALM. This mode exists in th…
- According to the given screenshot, error thrown by Cloudworks is - "Hierarchy import has both Name and Code unmapped". Although, manually the import action is running fine. Need some help. Thanks,
- Hi, I'm trying to create a logic into the line item "End". My goal is to count the number of times a specific month appears without including the first occurrence. If November appears 4 times, I would…
- Hi Community, To give the backstory of this - I have a module, where I first import one data file into, with Loan-Hedge ID List) and line items as the dimensions. The second file I import is a similar…
- Hi team, Got a problem I am trying to work through and have hit a roadblock. I am working on a forecasting tool and having trouble with dynamic selection of variables for basing my calculations on. Fo…
- I'm working on my L3 Model Building, It has been paused for quite sometimes due to my confusion in how to fill The TAR01 Detailed Sales Target module. I can't even create a module to verify the The TA…
- I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!
- Hello Comunity, I am trying to build a LiS on order to have a selection of the Forecast and the Type of the FTE. The problem I have is that when I try to build my LiS on my Forecast Model, the FTE Typ…
- Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. There were so many detailed answers to the September Community Challenge —…
- Hi team, Im working on a rolling forecast module and have the following dimensions Versions (page), Time (columns) and Cost Centre, Gl and line items as rows. one of the line items is an input called …