Modeling

Within Excel Add-In having an ability to customise elements on the fly
I'd love to this feature become available is an ability to create individual dimensionality intersections, similar to that of TM1 or Jedox. This is where the various element intersection points can be typed into the excel sheet and so long as that sheet is connected to Anaplan, will pull the data into Excel. This is also…
Dropdown-formatted line item with default as one of the list items and restrict turning as Blank
Hello Everyone, Is there anyway we can make alteration in Dropdown-formatted that having a list item as default and blocking user from making that as Blank? User can able to add new list item in that module where i am using that dropdown-formatted line item If not i will add that default list item manually TIA
Level 2 Conclusion DEM04 Demand Export
@Misbah Could you tell me what I am doing wrong in this formula. Demand = 'DEM03 Demand Forecast'.Final Forecast[LOOKUP: 'SYS08 SKU Details'.Product]
How to prevent edits to a version
I have set the edit from/to fields to 'None' However, for data inputs where there the time scale is set to Not Applicable, users are still able to edit the data inputs. Is there any way to prevent this?
Errors while running process.
Hi, I'm getting below error while running for all process in the model which were running correctly till last week, each process involves imports from multiple models(1 -5), what can be reason for this error? what is workaround? error -> Error Message : "localMessageText": "Import connector: Failed to retrieve data from…
2022 IDC EPBF Market Scape Key Takeaways - Anaplan leads the way
Anaplan is a recognised leader in the first-ever MarketScape for Worldwide Enterprise Planning, Budgeting & Forecasting (EPB&F) Applications by IDC. As with the Gartner FPS MQ, Anaplan is a clear frontrunner. Anaplan was instrumental in moving the market from EPM to this new EPBF category that highlights and rewards…
L1 Model Building Activity 6
How would I go about adding Department and Role to SYS08? I don't believe that was a part of the exercises which I followed step by step. This is what I have for my SYS08: I have Department and Country...
How to convert Month to year (Ex: Apr 22-Mar 23 to FY 22as year)
Hi Everyone, Is there any method that we can convert month to year, as i have scenario like timescale was APR 22 to Mar 23 as text formatted line item and we need to get a time period format as year and value would be as FY 22. Any Advice. Thanks
How to merge two models into one?
Hello Team, Would like to check on the following : There is Product standalone report exists in two models. I would like to merge into one model for space optimization. what are the steps to be followed? An leads or advise on how to proceed this? Thanks in advance.
Enhancement Request for the ability to copy text (w/ line breaks) from one source cell to one target
Summary: Currently, customer is facing the issue that the lines are divided into multiple cells. Can we fix the behavior the line breaks in the source cell are interpreted as cell breaks when pasting? I expect line breaks should be line breaks not cell breaks. Description: ・Customer Requirement Customer has lots of cells…
Two approaches to ragged hierarchy
Author: Taichi Amaya, Certified Master Anaplanner, and Financial Planning and Analysis Specialist at Pasona Group, Inc. In Anaplan, we consider it a significant feature that lists are hierarchical. Hierarchical structure allows for smooth and meaningful connections from the parts to the whole and gives flexibility to the…
[Updated] Level 2 Sprint 2 DAT03 Historic Volume
Hello Experts, On DAT03 Historic Volumes my volume line item don't match with the values for FY20 but does match with Offset volumes for Fy20. I used the following formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0. also in DEM03 demand forecast pulls only FY20 data not FY21,…
L2 - Sprint 2 - Activity 2.4.7.1 Create Demand Forecast Grid UX saved view
Hi, Can somebody please help me with this formula?
Dynamic Cell Access
Hi, The dynamic Cell Access - learning app doesn't show in my Workspace although I have download it three times. Please guide me. Thanks, Mark
How to use “LOOKUP” with summary elements
In the following article, I would like to discuss a common case of model building: the LOOKUP function doesn’t work with summary elements of hierarchical lists. Among other things, this forces model builders to use SELECT and not configure Production Data for some lists. I want to present to you an alternative approach.…
Level 1 model Building Activity 5
Hi @JaredDolich i Have stack with how to update the formulas for my Line Items in my Module EMP02 Employee Expenses. This is the formula i am using IF Employed? THEN Salary * 'EMP03 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 i have read other…
3.3.5.4 Update INV01 to Allow Override of Order Amount
One of the Product Supply Manager user stories for this sprint included the ability to override suggested order quantities. Update the INV01 module with additional line items to provide this functionality. In the INV01 Inventory Ordering module, add the following line items: Line Item Format Purpose Override Suggested…
OEG Best Practice: The model design process
The process of designing a model will help you: * Understand the customer’s problem more completely * Bring to light any incorrect assumptions you may have made, allowing for correction before building begins * Provide the big picture view for building This process includes the following steps: * Understand the…
How to keep Data in a Version "Locked" when Source Data Changes
Hello, I have an interesting challenge I am trying to solve. Background: * We have 4 Forecast versions. * Version Forecast (3+9) means that the forecast has 3 months of Actuals and 9 months of forecasted data. * Actuals data is loaded from a source system. The Challenge: How can we ensure that all data in the Forecast…
Module Content Panel - Header separators instead of empty modules
As an architect, I would like to have the ability to add bolded headers directly within the modules contents panel to separate a model's modules. Currently this is accomplished via empty modules with delimiter based titles. For example an empty "------ Systems ------" module created above all SYS modules. Having the…
DYK S2 - WEEK 10 (RANK)
Learn how to use RANK in different ways. Watch this video to know more https://youtu.be/q_c-pmw6u78 Thanks, Misbah Miz Logix
DYK S2 - WEEK 9 (Multiple UX Features)
Watch this video to know about three latest UX features. https://youtu.be/_7j6vQ2GG_A Thanks, Misbah Miz Logix
DYK S2 - WEEK 8 (Auto Complete)
Auto Complete - Watch this video to learn how Auto Complete helps you write the formula in the most efficient manner. https://www.youtube.com/watch?v=JiX0jko1uuw&t=143s Thanks, Misbah Miz Logix
DYK S2 - WEEK 7 (Naming Convention)
Naming Convention within models - watch this video to know more https://www.youtube.com/watch?v=o2d9zcwMILw&t=527s Thanks, Misbah Miz Logix
DYK S2 - WEEK 6 (Dimension Ordering)
Dimension Ordering. Learn how to order dimensions in the modules, watch this video to know more https://www.youtube.com/watch?v=Zz7zz_g_7gU Thanks, Misbah Miz Logix
3.4.4 Activity: Create Stock Exceptions Review UX Page
Is this right?
Multiple information columns prior to Time Periods columns
Hi, Asking for some general advice on how best to manage this. We have several schedules in Excel which show mutliple information columns prior to the Time Period Columns. Eg. Project Name | Project Type | Product | Start Date | End Date | Jan 22 | Feb 22 | Mar 22 | Apr 22| etc..... There are several tables like this that…
Filer Q and Year, to Calculate line items
Hi All, My issue is that I'm using a graph to show the P&L, but my 3-year trendline is spiking, when set to Q and Years. So I have P&L line items calculations and they are connected to different module views, so I created time filters modules to calculate the Periodic, Yearly, and Quarters. So, if I change in the line…
Anaplan count function
Hello Anaplan Community, I am stuck in counting the items in a line item. I have a line item called 'Status' and it is List formatted. Now I want to count the number of Particular items in the line items. Like 'Completed' occurs four times, so it should count completed as 4.Like wise 'In Progress' occurred four times, so…
Stress Testing on Anaplan ICAAP/ICARA
Hey Everyone, I'm just wondering if anyone has tried to use Anaplan for stress testing? How did you go about it and was it advantageous to use Anaplan over something more flexible like excel? If it was advantageous how so? Thank you, Padraig

Modeling

Discussion List