Modeling

model Building 1 Mapping Question
Hi, I have a question for the Model 1 Building Module REV02. The mapping is incorrect for the Volumes and I'm not sure why. Please advice. Screen Shot attached. Thank you
Large Ragged Hierarchy in Anaplan
Hello, Can some one help me on the best practices to follow on large Ragged hierarchy in Anaplan. i know that top down allocation will not happen properly in ragged hierarchy, Apart from these is there any constraints related to maintain the large ragged hierarchy in Anaplan. Thanks In advance!!
MAILTO - CC users with selective access
Hi All, I'm trying to add all users with selective access to in CC of an email to be send via "MAILTO". But can't seem to get it working. Did anybody already try something similar? Thanks,
How can i simplify this formula
Hi, I would like to know how I can simplify this formula... (Cash Collected Forecast - Other Forecast) * IF 'S01 Time Filter'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET('Y03 Securitization'.Ending RTR Balance, -3, 0) ELSE PREVIOUS('Y03 Securitization'.Ending RTR Balance) ELSE 0 / IF 'S01 Time Filter'.Weekdays? THEN…
My data in my Model is not being added correctly
Hi, Anaplan is not adding my data down my columns correctly. What is causing this? I have a pic of 2 columns from my Module. the formula is adding Line Items "Opening Balance (01):To #1917" The total of my Closing Balance (01) for 1/2/2019 should be $6,156,256 not $821,052. Thank you
Dependent dropdown - Based on line items
HI Team, Just realized that the dependent dropdown will work only based on the property that the list has. As we are following the best practice not to create properties in a list, can we make the dependent dropdown based on line items. Agree/Disagree or Any comments? Regards, Kavin.
6.8.2
Hi! I am still stuck on 6.8.2 the formula for SYS02 I keep trying to redo it but I still cannot get it right. Does anyone have any suggestions?
Name an action on set up
I would like the ability to, when setting up an action initially, give that action a name that would be used in the Actions section of the model settings library and indicate if it is recurring or single use. Then by running that action it would either be kept with the name given - recurring - or be cleared from the…
Level 2 - 3.3.3.2 - Dimension problem for Import data from Data Hub model to S&C model
Hi all, I am working on this task from Level 2: I have the following DAT04 module in the Data Hub model which was successfully imported from csv file called Weekly Safety Stock.csv (attached here): The same module in the S&C model is this: And I can't import the data from DAT04 from the Data Hub model to this one. It looks…
Level 2 Model Builder Training- DAT01 Sprint 1
I'm having difficulties loading the beginning inventory positions data into DAT01. My SKU fields map correctly, however the data is just not pulling through as I would expect. What am I doing wrong here?
Reference a value from a module but only from selected part of its list
Hi, I have a budget that is dimensioned by the complete charter of accounts, so both sales and costs. I'm in another module now where I want to reference the Budget module to get the SUM value of all its costs. If I take the budget line item straight in it will give me the total of both sales+costs, so I basically only…
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…

Modeling

Discussion List