-
2.3.9.1 Import data into DAT03 Historic Volumes module
When i am running the process as described * Run Process 9 Import Data from the Hub. I am getting error as Any help will be appreciated.
-
How to pull property data in line item
Hi, I have module with two lists and in that module for one line item i need to pull data from one of the List's property. for example: i have Employee list with its property as "Position" and i have module with Employee & Product as List and i have Line item as Position. So i need to pull Position of all employees in that…
-
Help needed: formula is invalid
Hi, My name is Usha Priya. I am trying to add formulas to the SYS01 Time Settings by Year System module. I get a message saying the formula is invalid. Please find below the screenshot. I need some help to solve this issue. Thanks.
-
Prevent Future Date Selection
Hello! I'm building a model where users can input the dates when they complete certain training events, and then taking that information and creating visualizations/analytics off of it. In order to keep the data clean, is there a way to prevent the user from selecting a date in the future since I only want to deal with…
-
Formula to get code of a parent
Hi, What formula can be used to get the code of a parent list inside a flat module? for example in this particular module the parent is a numbered list and I want to bring its code in the 'Code' line item( Text Format). What method can I adopt to achieve the same? Thanks
-
Sprint 2 Activity 2.3.9.1
I’m really stumped here on this activity and can figure out where I went wrong. Could someone assist.
-
2.3.10 Activity: Create Demand Forecast
As per the below activity information provided, do we need to write the formulas for all the line items in the module or need to write the formula for only Growth Rate % line item? Can anyone provide clarity on this activity for me?
-
REQUEST: setting to always show the Formula Edit bar when in blueprint
Allow the MB to turn the Formula Preview Mode ON for all Blueprint views. This would be a persistent toggle. So anytime you switch to BV you would see this at the bottom.
-
MX SUGGESTION: Give the MB a ‘x’ option during this import to List step.
It can be finicky clearing any fields you don’t want filled. Would be nice if there was an ‘x’, perhaps to the far left of the field selector?
-
SUGGESTION: Improvements to Delete from list using selection
When defining Delete from list using selection… can we consider adding:* The ability to use Tab to move from the Action Name field to the Delete Items from: field * Same request for moving to Selected using: * Allow the MB to type any portion of the Line Item in the Selected using: field instead of a need to type…
-
MX REQUEST: better handling when opening a Module from the Line Items view
Allow the Open button in the Line Items view of Modules to open the module that holds the currently selected Line Item. Right now the MB must scroll up to find the title for the module and then click Open . As some modules have many line items this can be frustrating. Example: In order to open the Module that holds this…
-
REQUEST: allow this search result field to show more text in the results
Maybe just move the ‘Object Type’ column to the far right? Or put it before the ‘Name’ column as we know the max width the ‘Object Type’ column could show. The names of the modules are getting cut off. I know we can't have an infinite amount. But there's some white space that we could use.
-
SUGGESTION: Ability close all tabs to the left/right of the selected tab
Allow the Model Builder to close all tabs to the left/right of the selected tab via right click menu. It would be part of the existing ‘Close’ options.
-
MX SUGGESTION: better tab position control
Allow the Model Builder to move a tab to the front/end of the list of open tabs via right click menu. It would be options beyond the ‘Close’ options.
-
REQUEST: Ability to add/remove dimensions from the ‘Pivot’ modal while in Model view.
Give the MB the ability to add/remove dimensions from the ‘Pivot’ modal while in Model view. It seems like such an organic place to be able to do it. Similar to initial Model setup. Could also help to avoid the awkward command click method for multi-selection in the Blueprint ‘applies to’ method.
-
MX REQUEST: support colored blocks in Formula Editor
Allow the builder to select if the colored text in a formula is colored text or a colored block. the colored blocks would be AWESOME! Mockup: The purple would be the same as the font color was. just an inversion. like highlighting.
-
MX REQUEST: allow the user to archive portions of a MODEL!
Often I find myself taking a standard demo model and building completely new structures for a specific customer/demo. I start from a standard demo model so I can reuse structures and concepts from it. Then, when I am done, I want to keep only the new stuff and any basic structures/data that I ended up using.It would be…
-
MX REQUEST: Model Search work with ‘Applies To’ section of a module.
Allow the Model Search feature to give results where the search term shows up in the ‘Applies To’ section of a module. I could see that this level of result could get thick. Maybe it is a flag the user can check to say they want this in the results?
-
MX Request: support this modeling sequence
* Edit the formula of a Line Item that is formatted as a Number * Enter a formula, the output of which will be Text * Submit the formula * Be presented with a modal that informs me that this formula, as entered, will not work in this Line Item * The modal gives me two options: Cancel so I can modify the formula to result…
-
MX Suggestion: add some formatting to the drill-in view.
This formatting would signal to the user what lines were actually used to derive the result. Here is a mockup: I highlighted in green the portion that was actually needed to get the result. The idea would be to make these first two lines bold or something.
-
Need Help: Circular Reference Error
Hi Anaplan Community, I have been thinking of ways to pull Prior Year value into Current Year. Previously, I used OFFSET() formular where I would offset -52 weeks. I have created a demo module below to showcase the original formula, the formula that give me circular reference error and the backup formula. Recently, to…
-
Using Saved Exports as Import Data Sources
I suggest implementing a feature where we can use Saved Export Definitions as Import Data Sources. Right now we can use a File or Connect to Anaplan Model - I would love to be able to select Saved Export Definitions in addition to current option of Lists, Modules and Saved Views. The natural place for this, in my opinion,…
-
Use setting grids as a model Import Dat Source
There are certain fields in the settings tables of a model that would be very useful to be able to easily import into a module for further calculation/model usability. The uses I have already encountered would be: * The 'user settings' table - this would allow filters and dynamic cell access more easily based on role, or…
-
Anaplan Time Days Mapping with Custom Days List
Hi, I have created a module to map Anaplan days with Custom Days List (snapshot attached). But while I am trying to use the Custom list in Sum formula it is not giving any value. Time settings at my end are at week Level (4-4-5). I have build this mapping because while aggregating days into months gives wrong summation due…
-
Reminder - UKI Modellers Forum - join now!
Just a note to remind you all that there is a UK Modellers Forum which is available to join here. I'm really excited to be a group leader there with my colleague @Paul and we are just off the back of a planning session for this year...and beyond! The aims of the Modellers Forum are to: * Share Product Roadmap and intro you…
-
Issue with formula editor :clicking on a list or list item does not work anymore (e.g. for finditem)
Hello All, Since the new formula editor release, I noticed that when I am editing a formula and go and click on a list or list item, the formula does not get populated with the list / list item. Now instead, I need to type the name of the list (e.g. when using FINDITEM or ITEM formula). This is bad! Is anyone else having…
-
Selecting Lists from General Lists in New Modelling Environment
Hi, I am little late to the party regarding the new modelling environment. However, I have started to use it and the experience seems to be very posititve. However, I have been unable to directly reference lists from general lists when requiring them in a formula. I am finding that when trying to reference a list directly…
-
Level 2-Sprint 2 Import Historic data Action
Hi, I'm working on sprint 2, my model has successfully run action 9.1. the issue is that it's ignoring most of the data. Can you tell me if this is ok or should I modify something on the action import source Also attached is my Import structure Best!
-
Level 2 - Sprint 1 - 1.7.3.2 Import into SYS08 SKU Details module
Hi , I am trying to import the details Level 2 - Sprint 1 : 1.7.3 Activity: Import from Data Hub to Supply Chain Model 1.7.3.2 Import into SYS08 SKU Details module Use the saved view from the Data Hub model to import into the Supply Chain model SYS08 SKU Details module. My mappings Import has been completed but with errors…
-
SUM & LOOKUP
Hi All, Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details as expected However, if, don't want to use SUM & LOOKUP at the same time, then what can be the options - * I tried with…