-
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…
-
[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
-
Data Hub to Spoke Model Performance Question
We are building a budgeting and reporting model based on transactions incorporating our chart of accounts. We have built a Data Hub to house the lowest level transactions. Currently we budget using 6 categories with several layers of hierarchy totaling a count of 6,475 items. Summarizing monthly transactions we are looking…
-
Level 2 Sprint 1 1.3.10.4
Can anyone explain why I'm not getting the view as displayed in the instruction? There is no check in my view? Thanks,
-
How to add boolean as true above intersection of same month
Hi Everyone, I have a module with 2 dimension & 1 Line item. Dimension 1 - Anaplan Month time (In columns) Dimension 2 - Time List ( In Rows : Similar to Anaplan time month) Line item name - Boolean up true. In Time List , I have 5 months: Jan 22 Feb 22 Mar 22 Apr 22 May 22 Now , please see the attached Image. The way you…