Modeling

Setting Today's Date via Informatica Cloud Services Integration
We've seen many requests to replicate Excel's TODAY() function within Anaplan. While Anaplan may or may not eventually build this functionality into the platform, we have implemented a workaround using our Informatica Cloud Services (ICS) integration that might be useful for other Anaplan users utilizing automated…
Error : Target server failed to respond
Hi, I'm trying to load the data from database(it is not our local db connecting to customer db) into my Model, after few tables were loaded into Anaplan then there is an error generating. Below is the error msg. "IO: com.anaplan.client.transport.AnaplanAPITransportException: Communication failure (Anaplan API:…
Interface to forecasting and optimization capabilities
The ability to do demand forecasting, regression analysis, and optimization are all key value adds that can deliver increased business value to the applications being developed in Anaplan. While it's possible to revert to math first principles to support some level of each of these, it would elevate the business value if…
How do I calculate months between Start Date and End Date?
How do I calculate months between Start Date and End Date?
How to Calculate Months Difference between Two Dates
Does anyone know how to calculate the number of months between two dates? Calculating the days is easy per my formula in the image below.
Bespoke Anaplan timescale
Hi, Is there a way to set up the fiscal year in our models differently to any of the options given? For example, our FY2018 runs for 13 4-week periods from 15th July 2017 (so does not start or end on either the last day or a day nearest the end of a calendar month) with no 5-week periods. Thanks for your help. Joe
Multiple heirarchy
Hi We have multiple business units forecasting at product levels. Product heirarchy is pretty standard however forecasting is performed at different level for eg business unit 1 product level 1 -> product level 2 -> product level 3 = forecasting is performed here . Actuals will be loaded at product 3 level Business unit 2…
Change Model End of Fiscal Year Setting while preserving all data in order to align week 53
Due to a new controling entity, in our main budget model, we need to change our 'End of Fiscal Year' setting from 'last Sat in Jan' to 'Sat nearest end of Jan. Our current set-up gave us a week 53 in January 2016, but our new controlling entity requires us to align our financial calendar and budget a week 53 in January…
Amortization of Deferred Commissions
What's the best way to build a model to track and forecast the amoritization of deferred commissions? We know the amortization periods, deferred commssions on the balance sheet, and want to track the amortization over time in Anaplan.
SUM Mapping for Top-Level Items
If a list of items are assigned to a top-level item in another list, the items are not counted when the SUM function is used. For example, there is a module with a list of events and a line item called "Assignment", which is a list format connecting to a list named "People". Some events are assigned to "All People", which…
Default version when source for not-versioned module
Hi, I noticed that when a target module of a formula does not have versions but source module does, a Forecast version (the one marked as current) is always picked up by the formula by default (merged with Actual), no matter how many further versions exist in the model. Is it a default behaviour that I can rely on? I know…
Bulk model copy
HI Team, I need to move multiple archived models from one workspace to another. Is there a way where I can move multiple models simultenously to the new destination workspace or should it be done manually one model at a time? Regards, Prateek
End User Changing Line Items
Hi, I am seeing an issue where my end users can double click on a line item or list item and edit it. Even in modules where they only have read access. Is there another way to format these where they cannot be edited? Mark
Multiple selection in page selector
Hi, We would like to do multiple selection in page selector. For example, can list items of A, B and C be selected simultaneously in the attached screenshot? If possible, could you tell me how to do this? Thanks and regards, Maki Yasuda
Multiple List Items Selection - manual
Hi everyone, A new video tutorial on how to select several list items in a dashbaord to see a combined result is available here. Hope this will be helpful, Egor.
Calculations using Dates
I need help developing a formula that looks at the start and end dates for an agreement (eg. rent, where rent amount per month is fixed). The agreement can straddle months or years. I would like to show rent mont by month on a timescale, however, be able to prorate the rental amount in the initial month and the final month…
Compounding Monthly Growth
Relatively new user and am struggling to build a ramping growth model based on monthly expansion. Am using the lag function in this context: Avg Deal Size = LAG(Avg Deal Size, -1, AEC Salesperson Assumptions.Starting Deal Size) * (1 + Deal Size Growth) My Deal Size Growth is positive and my overall Avg Deal Size is…
Data Types Conversion - manual
Hi everyone, A new video tutorial on how to convert most used data types is available here. Hope this will be helpful, Egor.
Import users from DEV model to PRD (Deployed) model
Experts! We implemented ALM and imported DEV model to create PRD model. Please suggest what is the best way to import users and their access from DEV model to deployed PRD model?
boolean related line item s
I am not sure how to explain this. We have a module with several factors (line items) we ask our end user to project forward for a year on a monthly basis (i.e. twelve periods). However quite often they will forecast the same factor for the whole year. We would like the abilitiy for the user therefore to enter in their…
Delete items from lists using actions - manual
Hi everyone, A new video tutorial on how to delete items from lists using actions is available here. Hope this will be helpful, Egor.
linitem options (Start of section, Brought forward)
Help me please with use cases for linetem options: Start of section, Brought forward In Anapedia it's said they are rarely used and I couldn't get enough from explanation think if they present in blueprint it will be helpfull to understand where could I use them
How to filter line items
Hi, We have hierarchy type lists of Market Unit and Country Group (Market Unit is parent.) and Country Group list is specified as a dimension of a module. In the module, the line item 'B' is applied to Market Unit.('Applies to' of the line item 'A' is left default.) In such a situation, if user selects one of the Country…
How to put formula in one list item and keep blank in the other
Hi Given that we set a list which has two items of A and B as a dimension of a module, we would like to put formula in a list item A. On the other hand, we want to keep blank in a list item B so that end users can input data. How can we implement this? Regards, Maki Yasuda
Formula for blank value in lookup function
Hi I am using the below formula for one of my line item in my module 'Demand'. I am doing a look up in another module 'Open Qty by Bucket ID' by Bucket ID and SKU to populate the open qty value in the 'Demand' module. Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] The issue I see here is,if there is…
Access to 102: Intro to Model Building?
Dear Team, Since Yesterday I have been attending to Anaplan Training more precisely 102 : Introduction to Model Building but today Morning when I logged on first I have not seen yet the courses Menu on my session . Could you please help me access to the courses ? Could you please explain me the models source on my today…
Selective Access to Lists for Roles (as well as Users)?
Is Selective Access for Roles (as well as Users) technically possible / practicable to implement? While Selective Access for Users is of course useful, my experience tells me that it would be even more useful for Roles, particularly for a numerous user base. If the answer is no, then is there any workaround to meet the…
How to delete a Model
Hi All, Can any one please let me know how to delete a model which is created or installed through Anaplan app hub..? Thanking you in Advance Regards Sashidhar
Tableau 10.2 to make advanced analytics easier for enterprises
Tableau 10.2 adds advanced mapping capabilities that claims to make data analytics easier and more scalable for enterprises. Intro: Data visualization company, Tableau software, has announced the overall availability of its new version, Tableau 10.2. The organization states that the release includes advanced mapping…
Can you change a numbered list back to a non-numbered list?
I have just ticked the box for numbered list and now when I untick it, the unique id column does not disappear?

Modeling

Discussion List