-
SYS14 Create Account>Product, Line Item "Data?" can't refer SYS12 and SYS13
I've create on Data Hub the module SYS14 Create Account>Product and looks like: But I am blocked by Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13 Account SKU filter. * If you downloaded a new Data Hub…
-
Level 1 Model Building Exam -- Activity 5
I thought I was pulling the data correctly but I guess I was not. Can anyone tell me if there is a problem with my formulas? Or maybe I should make some adjustments to my SYS08 Employee Details Module? Any Help would be much appreciated. Thank You!
-
Level 1 model building exam question 4
Hi guys, I'm trying to change the format of item list: Role, from text to list and the below message came up. Do you know how can I fix it?
-
Date Stamping the last time a Process was ran
Hello, I am aware that Anaplan does not have a Date Stamp ability and I have solutioned that; however, I am not sure how to apply a date stamp to the last time I ran a Process from the dashboard (e.g. If I run an Import today it should be stamped as 09/30/2022, or the last time it ran successfully). To do this, I was…
-
ETL - Summary for hierarchy
Hello! I am trying to build an ETL that will upload into a client's ERP system. They have some nuanced requirements, and I'm struggling to build one of those into our module. In the image below, I need to have the parent values displayed for the highlighted columns: This module uses L2 for account numbers, and the parent…
-
Set default roles access to none
As a model builder and workspace admin, i need newly created modules, lists and actions not to be accessible to any role except the full access role. This is necessary to follow security guidelines and best practices of "least privilege" (you only have acces to what your eligible to). Currently the opposite is done in…
-
New to the Forum
Hi Community, I am new to this Forum. I started e-learning Model Building Journey last year and I am happy to be now Certified Model Builder (achieved last week). I am working as Project Owner Support and I am looking forward to increase my Anaplan knowledge and enhance my building skills.
-
Hello All. New to this forum, go easy on me...
Hi all. New here but not new to Anaplan. I've been here nearly 9 years. I'm joining this forum to help out and spread knowledge. Will help create some content and articles - any suggestions, what do you need here as model contributors? Let me know what you need and what you want to see... Post your questions, there are no…
-
Model change has been rejected to prevent the workspace exceeding its size limit
Hi - working through sprint two of level two The module uses the lists P3 SKU and Accounts, Timescale is Week and Time Range is Model Calendar. Total cells is 34,721,544. Error message: Model change has been rejected to prevent the workspace exceeding its size limit Current model size: 417135690 Rejected model size:…
-
Convert list item to time period
We make a weekly copy of the demand plan to be able to calculate bias and forecast accuracy with 2 weeks lag. In a list we created versions : The last Property "Reporting Week" is formatted as Time Period "Week" The data is copied in a module with this list and the product list on the lowest level as dimensions : How can I…
-
Expand column width in Actions-Imports (and Import Data sources) or make it adjustable
The idea is very simple. The columns' width in Actions tabs are very narrow this always requires to Copy and paste to excel every time i want to check something in it. Would be great if we could adjust or simply have the default width much wider. @GeorgeDuckettMaybe your wonderful tool could have it in future release?
-
Delete from List using Selection must work differently for the nested list
My Idea: For the backward compatibility, add a check box in "Delete from List using Selection" action. When it's TRUE (default is FALSE) - running the action will delete all elements (leaf and parents) which have TRUE in the selection line item. This won't affect already excisting processes, but will allow to have one…
-
Upgrade Model search to ignore apostrophes (' or ’)
As a model builder i want to be able to search quickly through the entities of my model. Frequently I have to examine formulas which most of the time have references from the other line items and modules which have special symbols in naming (i.e. a dot (.) in module named '8.15 Transport tariffs options (Month)') So if I…
-
Select page link arrow position or hide it (>)
Idea: As a page builder I'd like to be able to choose there to locate the arrow next to the page link or even disable it. Usage: Talking about linear workflow it's not always that you (as a user) want to go downstream of the workflow. And looking at some cards can be confusing especially to the ones who are new to the…
-
Open referencing modules and related lists
As a model builder I want to be able to open modules which are referenced by selected module as a blueprint action. This is how I think it could look like: Also I want to be able to open list elements used as dimensions oth the module. (we could not have it in classic US as we could not open multiple lists but now we can!)…
-
Auto sorting subsets list when choosing Applies to or Format
As a model builder I have to search through "the list of the lists" to select necessary dimension in Applies to or a list for line item format. Most of the lists are ordered the same way as we put them in General lists and Line item subsets tabs using "Reorder..." button. But apart from that we have Subset which can be…
-
User to select columns for variance analysis
New variance feature is a long awaited one. And finally we have it! But this feature is almost a hardcode and it does not allow an end user to select which of the two columns to be compared. Before placing this idea I have open a topic in UX Designers forum to collect thoughts of the community about it: MR: User to select…
-
Option to display list properties on a grid
Customers very often request reports in which to show together properties and Time dimension as columns, similar to what they are used to see in an Excel: As of today, this is quite difficult to build in Anaplan. The most common solutions to deliver this requirement are: * OPTION A: Nest Time with line items on the columns…
-
RANK on Total & Sort Nested Dimension
Hey builders, I'm trying to match a mockup, but having trouble building it in Anaplan. User Story: I need to rank all projects by their total cost (highest to lowest) while showing the breakdown of Project Total Cost by each Cost Pool (if there is a value in a cost pool). Rows: Projects and Cost Pool Columns: Cost My…
-
Level 1 Model Building Exam – Model Building Activity 5 - 2 error messages
Hi Anaplan community, Whilst updating line items: Bonus, Car Costs, Phone Costs, Medical Costs I’m getting 2 types of error message: First error message: Data type mismatch: format other than LIST or DATE being referenced as a relation. I've spent close to 4 hours browsing Anaplan community, hoever I still haven't managed…
-
Activity 5
I have mapped everything right , but the medical cost for December 2020 is showing 36,800 and that is not the right answer. Can anyone please help me with , where I am making the mistake .
-
2.4.4.1 Update DEM03 Demand Forecast Module
Good morning, I am doing this activity by pivoting my module. With P3 SKU and account set up as default ( Nutzo bar EN and Candyate), i can flag or unflag the "override?" check box. Then I want to set up as the activity asks me but the checkbox of override? disappears, and cannot set up final forecast at 71 Is there any…
-
Job Aid: How to use the new Model Search
@VickiA posted all the New Modeling UX features in this post. Just wanted to show you where the "Model Search" magnifying glass is located. Took me a while to find it. It's terrific! Already used it to clean up one of my models - used it to search for line items used for filters that I want to change, particularly the time…
-
Percentile formula
It would save a lot of time and space to have percentile formulas in Anaplan. Percentiles are very valuable to eliminate extreme values from data sets and improve the accuracy of our forecasting models. Having a percentile formula would address the need for a median formula at the same time. Further below are a few…
-
Is there a way to view Months then Quarters then Years in a Module Applies to Time
Hi All, I have a Module which Applies to Time. Attached Screenshots. =>The possible view for the Timescale is Jan Feb Mar Q1 Apr May Jun Q2 Jul Aug Sep Q3 Oct Nov Dec Q4 FY =>But is it possible to have a view like this Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Q1 Q2 Q3 Q4 FY Regards, Sreeroop
-
Optimizing Models, blueprint Analysis
Hi all, I am beginning my journey as a model builder in a company where one of the first task is to try to optimize the current Anaplan Models, I've followed the instructions given here to try to reduce the cell count in a specific module: Context: * Formula repeated several times in different line items and modules. And…
-
Tech Talk with OEG: Performance triangle key takeaways from customers
The Anaplan Performance Triangle details the relationship between the number of users and the level of complexity in an Anaplan model to the performance of an Anaplan model, as explained by Mark Warren, Operational Excellence Group Platform Specialist in this article. The Performance Triangle considers: How many end-users…
-
OEG Best Practice: Blueprint analysis: Model analysis techniques using Excel
What? A model analysis technique using metadata from your Anaplan model imported in to Excel, utilizing purpose-built formulas to identify line items of interest Why? We do this so that we have some extra information with which to arm ourselves when trying to optimize a model. It lets us look at every line item, apply the…
-
Blueprint analysis and model optimisation
Lovely bit of solutionising to help our users perform their own optimisation and a great example of Anaplan and Excel being used together to great effect. Thanks to @MarkWarren for this and for sharing in our community! Check out the article here!
-
Import Data Module and List at the same time
Hi everyone, I have this concern of my current model, since the user will be the one to add/upload the data. I need a friendly dashboard for them to upload the file to a Data Module. But what will happen if there are new data even amongst the lists inside of that uploaded file? So I made this small test, where I create 2…