-
How to copy actual month data to forecast month?
I have following module, which is used for manual % input. The percent will be input in a special cases. My problem is that I want to determine do I want to utilize current month (actual percents) for forecast month. I would like to see the functionality as follow: * If user will “tap” UsedInForecast? to Boolean lineitem…
-
Copy same line item value to other/nexdt list item in same module
Hi, I have a module with 1 dimension, a list, and 2 line items: Line Item 1 (boolean) Line Item 2 (boolean) I want the Compare line item to populate the same value as Show has but to do so for the next list item in the list. Example: List: A, B, C. Then if the line item has Boolean TRUE for A, that should mean Line Item 2…
-
Extend Workspace size beyond 130 GB
Current 130 GB limit is not enough for organizations with huge data lists used as the module dimensions. Extending size will help to maintain real-time ability by not splitting solutions into different models/workspaces.
-
Level 1 Model Building
I'm not quite sure how to fix this
-
Level 1 Model Building
Hi! So I have completed the Level 1 MB training, I have moved onto the Assessment portion in order to be L1MB Certified. However, I have stumbled upon a build that I do not remember learning. I went back to every single Level within the Level1 MB and was not able to get any answers or direction upon which to build. I would…
-
Pre-calculation check for duplicate line items
I am sure the acute pain felt when locking-up the model for simply creating a duplicate line item is felt by many model builders. Please could we have a simple check (this already happens elsewhere in the model e.g. actions) that ensures there are no duplicate line items before the model is calculated/refreshed? It only…
-
Custom Blue Print View
A simple suggestion to help with the organisation and maintenance of models (and I assume a really simple suggestion to implement): Allow model builders to save blueprint views (in the same way it works for regular views) and even change the default model blueprint view for all modules so that we can change the order of…
-
Configurable Range for the Calendar Selector in NewUX
As a Model Builder I would like to be able to select the Calendar Range in my Input forms in New UX. I know that e.g. only Part Dates or Future Dates should be entered. I can check these with additional line items, however I would like to limit the calendar to only show the relevant dates in order to ease the selection of…
-
Find value from other line item and populate it backwards
Hi, Module: Dimension: Time (Months) Line item: Amount, Proforma (both Number format) The Amount line item is imported based on imported forecast. I then want the Proforma line item to populate the first found value from Amount for all cells in current FY. Ex. Amount is 100 from August to Dec 2020. FY starts in Jun 20, so…
-
Alternate Hierarchies - Use Cases
Hi All The topic of Alternate Hierarchies is very interesting for me, as we are exploring this topic as a future development for the product We are looking to build functionality that will allow multiple parents off a single child member and specify which hierarchies should be used in which part of the model This will…
-
Setting up a user filter on a composite list
I have a module that has country and accounts as dimensions. My accounts are part of a composite list that roll up to segments. I've created a user filter using another module to show only the countries and accounts specific to a user. My filter is working but seems to cut out the aggregated totals for the segments. When I…
-
ALLPERIODS Value function
We currently have time functions to return the MONTHVALUE, QUARTERVALUE, YEARVALUE etc... it would be helpful to add a final function which will return the Time.All Periods value, this would enable developers to avoid having to add summary methods to determine the all periods value. It may be there is a work-around but ran…
-
Image Link on share folder
Hello everybody, I would like to insert a picture on a page. For that I created a text link Line Item. This link is connected to a picture on our MS Teams share folder. Even though I do have the access to this Teams folder, the image on the Anaplan page will not be shown. Can somebody help me? Many thanks
-
Formatting Question
Hi, Is there a way to put in one Formula for Actuals and another Formula for Forcasting? I was thinking I might have to create two Line Items (one for Forecast and one for Actuals) and put those formulas into the separate line items? Is this thinking logic correct? Thank you
-
Allow to set a model default Time order
When our team views multiple time periods over the year/years, they usually want to see a Trend view (all months in order (Jan-Dec) then Quarters then year to allow the team to evaluate activity over time. It would be nice if there could be a few default options in the Time setting area so that we do not have to reorder…
-
Pulling in Data Question
Hi, I need advice on how I would pull in past data into my Model. I have a Excel file that is attached and have set up the layout of the Model in Anaplan and have put the Formulas in my Line Items. I just need to pull in this data and then create a Flat File that will be uploaded into Anaplan Daily. My question is with the…
-
Effective date of Employee in a Location
Hi, Looking for a solution to get the effective date for working on a location(Result(output Required)). Employee 1 1. Got hired on 15th March so output to be 15th March for the period March. 2. Moved to US location in May and stayed there for 3 months, for July period the result to be 31st May(period since working at that…
-
Anaplan stops during large imports and processes
Recently I came across and issue where Anaplan users won't be able to work if another user is importing a big file or running a process. it was reported by users that during those time Anaplan stops responding and the dialog box appears which says some user is making changes. Does anyone faced same challenge and what can…
-
Vote for your top function for Anaplan Live!
Hi, everyone! Join me on December 9 for Anaplan Live! In my session, I'll be discussing the 5 foundational functions in Anaplan. These are the most common functions and understanding them will allow you to start building and planning with Anaplan. I'd like to add a 6th surprise function that you would like to learn more…
-
Add Few More Features on Manage Models Screen
We have got more than 500 models in our training workspace which is 130 GB. It is quite difficult to keep a track of all those huge models when it comes to workspace cleansing and even more difficult to access someone's own model or accessing any model and making that as a favorite. Hence proposing an idea to 1. Have one…
-
Rank Formula Issue - Not Starting at 1
Hello, I am running into a strange issue with the rank formula. In the attached screenshot, you can see a line item with the formula: RANK(1, ASCENDING, SEQUENTIAL, CURRENT FLAG <> Previous Current Flag, Current Flag Mismatch) I have displayed all related line items. A screenshot of the filter on the view has been provided…
-
Level 1 MB Exam- Activity 5
Hi, I'm working through the L1 MB exam and cannot figure out activity 5. The question asks you to update the formulas for the bonus and benefits lines, using a combination of data from the new role data and module SYS08. When I update with this formula: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %…
-
Still ROUND issues with EXACT?
Hi, I was under the assumption that the EXACT rounding method had fixed the issues with floating decimals? My use case requires several rounded export modules out of one calculation module and thought it's good practise to use ROUND() only once in the calculation module and not in every export module. Yet, I just…
-
To pull or not to pull?: Loading Distribution List to SYS07 Location Details Module (Lvl 2 1.3.4.3)
Hi all, This is an exercise to create a data hub and, as a preparation, I have asked to load data in a flat list in a preset structure as per below: Please note that there is Distribution Center? field to it, which was already set when I uploaded this assigned model. Since it is there, I have uploaded the true/false…
-
Approval process
HI In my module I have Profit Center list(25 items) and revenue Line item .I have also created 1 Boolean line item for approval process. so for each profit center I need to check approval boolean. Instead of that can I check only one boolean so that all the profit centers should automatically checked. Is there any…
-
Version Formulae & Formula Scope
I need some assistance understanding the limitation of Version Formulae and how it interacts with Formula Scope. I have inherited a model build which has a comprehensive P&L module (down to GL level) split into its respective areas - revenue lines, cost lines, etc. Each respective area naturally points to a different part…
-
Getting data from one module to another
Hi, I have two modules with project data. The first module has a dimension of serial numbers (1,2,3,4). it is not a numbered list. One of the line items is defined as a list format of project numbers. this list is a numbered list. The second module has a Dimension of the project numbers (numbered list). I need to pull data…
-
Create Forecast based on date and occurence in Property Module
Hi, I have a Property module of Costs with following line items: * Amount (Number format) * Occurency (List-formatted with options One-off, Monthly, Quarterly, Yearly) * Cost Start (Month Period format) * Number of Months (Number format) I want to feed this information into a Calculation model that has Time as a dimension.…
-
Move employee from New Joiner list to Employee list
Hi, I have created an import process that takes any person from the New Joiner list that has a Start Date before CURRENTPERIODEND() over to the Employee list. This is all well, but then I would like to delete this very same person from the New Joiner list. How can I manage that? Best regards, Johan
-
Level 2- Sprint 3- INV01 Question
Could anyone help me with the questions below? 1. My Beginning Inventory is not showing correctly with the effect of ending inventory, it shows the same number, please see the attached screenshot. My formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning…