Modeling

KTLO activities and innovations within Anaplan
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to enhance the platform performance and drive more impact to our client. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
Beginning Inventory is not fetching the data properly
please see the attached modules to match the formula i adopt
Hide/Move Model Map Button!
I think all model builders will know the frustration of trying to open the settings menu and misclicking the model map! It will often take minutes to load on large models, with no option to cancel the selection - in some instances it even crashes the browser! Please give us the opportunity to hide or move the button to…
Option to disable the model map
Description of the enhancement required: Please provide an option to disable the model map. An example of the enhancement: In the Settings tab, there would be a section for User Preferences, which would allow me to turn off the Model Map. How would it help the business process: I never use the Model Map, but it gets in the…
Move/Ability to disable model map
With the gear icon being so small and so close to the model map, it isn't uncommon to accidentally click on the model map. When this happens in some of our larger models it can lock up our model for a good amount of time while it loads. Having the icon in a different spot, or having the ability to disable the icon (as our…
Assign Action - Disable unassign
Assign Action dialog window allows end users to assign new elements, but also to remove already assigned elements. In some scenarios it is not desired, as modelers are no in control here (we cannot put any validation if an element can be removed / unassigned). The idea is to add a configuration option (Boolean) to allow…
Usage of Lookup on Users
As we all know, We are not able to use Users formatted line item in Lookup to get particular user data. Can we have option to do the lookup on user formatted line item? It will help us creating consolidated dashboards on what-if scenarios by user dimensions.
Filtering time intervals on the UX
Hi I'm trying to figure out how one filters time intervals on the New UX. Doesn't appear where one can select months in lieu of weeks or quarters for that matter. I may have to do that at the model level. Thing is how does one? Is the solution to create a Time by Weeks module in the model and have that linked to the module…
Indication in blue print if a Line Item is used as DCA
There should be a column in blue print view of a module like "Referenced By" highlighting modules where a line item is used as a DCA
New features for Bundling Actions.
Are there any new features recently released that can be helpful in streamlining various actions into a process other than the usual way a model builder does it?
Line Breaker-Anaplan
Hey guys, Trying to figure this, I am triggering a mail from the end user, the body of the mail picks up inputs from the end user which comes from text formatted line item, MY ISSUE IS when the user enters in the text field something like this: - " 1- Hi 2 - Hello 3 - Hey " I want the mail to pick it up exactly the same…
NPV and Amortisation
Hi Guys I am running into a problem using the NPV calculation and a subsequent amortization calculation. Please see attached: I used the NPV formula to calculate the NPV of a 12 month variable cash flows. This is equal to the opening balance of a liability. 213,473) When i develop an amortization schedule including…
Percent Growth Formula Logic
Hello, everyone, I'm trying to put together the formula to display the appropriate Unit Increase by & Total Unit Value outputs in the table above. The logic should go thus: The 2% growth for FY23 should use the 100 unit value from FY22 as its base. The formula would go thus: (2% of 100) The 5% growth for FY24 should use…
Daisy Chaining versus Avoiding Duplicate Formulas?
Hi All, I have a question about daisy chaining versus not repeating a formula. From what I understand, the engine will calculate the below module faster if I didn't reference Division and Deal Size in the Selected line item. Line itemSelectedDivisionDeal SizeFormula(ISBLANK(Division) OR FilterSelections.Division =…
Stuck on L1 Training 7.2.1
For some reason, I cannot get the import right. I'm finding the import settings not very clear. I've attached some images of what I am trying to do, but also included from the course what it is supposed to look like. Any help would be appreciated!
Level 2 Sprint 3
I'm not getting any errors at the time of export but can't see any data. Please help
Run multiple 'Delete Actions' at once
There should be an option to run multiple delete actions at once under the Actions tab. PROS: Time Save Faster execution (Extra space)
How to convert flat data into monthly - GL example
Confused on how to work with this flat data and derive monthly values from it. Appreciate the help! Each row is a unique combo of Account (GBAID), Ledger Type (GBLT) and Year (GBFY). The snippet attached is 4 entries for the same account and ledger type for 4 different years. GBAN01-12 are entries by month. For example,…
Delete items of list with no parents
Hello all, I'm trying to delete items of a list that are not linked to a parent. Therefore i cannot use "the delete from list using selection" action. Do you have any tips to achieve that ? The list is quite huge so it's difficult to do this clean-up manually. Thanks for your help, Maxime
Calculated Codes using Attributes - Best Practices
We are working on a project to migrate from an Employee Hierarchy to a Position Hierarchy in Anaplan and are looking from some input from the community on Code Creation best practices. Since we do not have a good external source of data for position code, we've decided to create our own Position code within Anaplan. At…
Allow for more control around duplicating, adjusting, and managing Exports
Imagine you need to update an export with a new column, but you want to retain the previous export for another group. In order to create this new use case, you now have to create an entire new export OR you have to inform the other team that you are adding in additional columns (even if you are allowed). Once you do fix…
Level 2 Completion
I have completed and passed all the 4 exams of Level 2 and have submitted the model history as well to be graded. Request to please let me know what are next steps i need to do to get the certification and have the Anaplan Certified Model Builder certificate Regard Shashank Gupta
Anaplan Model Opening Error
I am getting above error while opening the Anaplan Model. Request to please guide me on how to resolve the issue. Regards Shashank Gupta
Access to Anaplan Workspace
I am a student. Need access to Anaplan workspace to complete Model building courses.
3.3.7 Activity: Add DCA to Inventory Ordering
Hi Anaplan Moderators, Can someone help me out! to check if my formula and the results is right or wrong. Thank you The pics below is the results and the formula:
Add formula to a Has Data? Line item
Hello, I am new to Anaplan platform. Now I am working on Level 2 model building training. Here I have an issue to write a formula to line item. I don't have any kind of data in SYS13 Account Filter Module. I have data in DAT03 Historic Volumes Module. In DAT03 Module I have only one line item Volumes and I don't have any…
Drill Down
Hi, I have a formula applied to a line item which is not giving out the correct result, and if I drill down the formula, the pop-up screen is not considering he other modules for calculation which are there in the formula. Can you help where is the lag in the formula. Have attached a screenshot for reference. Thanks.
Improving Forecast Accuracy
Improving forecast accuracy often features the business value expected from a system implementation like Anaplan for demand planning. In reality, forecast accuracy is not a business value—but it contributes to business value in terms of better service levels and economic inventory levels. Often, customers want to improve…
Anaplan UX Pages Error
Hi, I have developed an app with several pages in it. Total 60 users are having access to this App and all are with same access. And i can see one user is getting an error when he opened a page in the app. Error message says: "We could not connect to the model"., Please find attached screenshot of error message. I could…
IMPORT failing - Not sure WHY?
Hi All, I am unsure why the Import is failing whilst import into dimensioned / non-dimensioned module.. Import snippet: 1st & 3rd columns are List Item Property Whilst Import it is failing due to duplicate values: The final output in module is the consolidated values of all number types.. Screenprint from BluePrint (not…

Modeling

Discussion List