-
Hierarchy and Demand planning(like MRP)
Hi folks, I was wondering if you might be able to help point me in the right direction as I seem to have hit a wall. I am building a model which appears to have a linear hierarchy SKU-> Product -> product Family and this is working as expected. However in part of the model I need to work out component requirements in which…
-
Allow OFFSET calculation in version formula
Description: Allow OFFSET to be used on summary line item formatted as Formula. Impact/Benefit: I am trying to calculate a percentage change from prior year or prior quarter at the summary level. For example, year-over-year % changes using a formula at the aggregated level: Total Growth in Net Sales / OFFSET(Net Sales, -1,…
-
Certified Master Anaplanner David Elston Shares His Anaplan Tips for Success
Master Anaplanners are Connected Planning pioneers, building industry best practices and shaping the way Anaplanners everywhere utilize Connected Planning solutions every day. They understand the possible and are passionate about helping set the direction of the platform. This month, we talked to Master Anaplanner and…
-
OFFSET on LIST ITEM
When entering the formulae below it works,however if i change the -1 in the OFFSET formulae to point to a lineitem to pass the no of periods to offset it is formatted as a number anaplan gives an error , the AutopopulateActivity line item is fomatted as a list item. IF ISNOTBLANK(Select Job Code) THEN Select Job Code ELSE…
-
Retrieve Numbered list' Display Name
Hi, All I am struggling with retrieving a display name of a numbered list in a Property. My understanding is that Name(Product) will retrieve #1, #2,,, in my case. Could you give me some pointers ? Thanks in advance. Greg
-
Change the Organisation of a List
Hey I have to delete a List but cannot due to an error that says 'The model's Organisation hierarchy cannot be deleted'. The 'Is Organisation' property is checked by default for this List but I no longer require this particular list. How can I update this option? Thanks
-
Dashboard Page Selector
Hi Community, I've tried to post the same query yesterday, but it seems it didn't go through. I'm gonna have another try. I'm working on creating a Variance Dashboard at Cost Center / GL level. Having those two dimensions alone would make a relative big module, but I have added couple more which is causing me a lot of…
-
Anaplan Formulae - Repeating sequence of numbers across Timescale
Im creating a Rostering model in which I need to do the following: 1. In a module contain all employee information i.e.. start dates, shift pattern category, etc 2. Module containg a shift pattern profile i.e. for shift pattern A = 2 days on 2 days off, Shift Pattern b = 5 days on 2 days off 3. Module with timescale(day)…
-
Model Building Level 2 - Where Is The FP&A Model?
I have finished the sprints and I am going through the conclusion of Model Building 2. I have created the Shipping Export module, and now it wants me to log into the FP&A model to import the data. The problem is, unless I missed it, I was never given a link to the FP&A model. Here are the instructions:
-
Display Hierarchy Codes against parent nodes in line item
When creating a module with a hierarchy dimension, if the code is used as a line item, the code will display as blank for higher level nodes in the hierarchy. This is not the case in the list screen for example and is very disappointing for business users used to other tools who do not like the workaround of including the…
-
Odd Division Output
Would someone explain why Anaplan is giving me a number 5x larger than the number I am dividing when my calculation takes the first number (4,221.43) and divides it by 0? I would assume that it would be 0 or a NaN. Not something as large as the last number.
-
Breakback function by selected Line Item
Hi Team, It will be great to have an option to select the Line Item which will be taken as a source to calculate phasing for Breakback function. At the moment split is done based on the items, in which I input amount. Unfortunately in some business cases it's required to use another metric for phasing. This can be useful…
-
Error In Formula - how to understand Circular Reference
Hi, Please see details on the attachment. My apologies for not posting it on the message box I document my inquiries on my pc for future references. Regards,
-
Disabling line items from being used without wiping previous data associated with the line item.
Hi all, Wanted to ask for a best solution of this question if possible. I am trying to stop a line item being available for selection during a forecasting exercise but I am aware of the fact that if I delete the line item, all data associated with the line item will be wiped. I would like to 'disable' this line item from…
-
Current User and Current Time functions
For change control there is a need to add the current user and current time to a transaction log. Currently it seems that neither are available as functions although David Smith did comment 9 months ago regarding a current user function "This is something we are actively looking at; to provide a "system" generated list of…
-
deleting an Item in a list import
Hi All, I was trying to import a list from another but came to know that when i add an item in source list it gets reflected but if i delete an item in source list it does not gets reflected in target list. is there any way to implement that part?
-
Message before session times out
Hello Anaplanners! Please add a message box BEFORE session times out. "The session will time out in XX sec. Press any key to continue your session". Clicking it will continue session. It is very often when you make some work outside Anaplan, but Anaplan is open on second screen. And in some moment you get message that…
-
How to get the value in Summary level
Hi, I have two modules: 1. Module01 -> To collect comments from user as a text which published in dashboard: List NamesLine ItemAAText 01AA01Text 02AA02Text 03AA03Text 04BBText 05BB01Text 06BB02Text 07 2. Module02 -> To summary and export the content as CSV. List ParentList ChildLine Item AA Text 01 AA01Text 02 AA02Text…
-
What if variance in Rolling Forecast
Why is the variance hard coded for just April and May so as to get the variance in the Rolling Forecast Solution in AppHub?
-
Intraday Best Practices
My client is interested in forecasting their headcount requirements using Erlang-C intraday, with 30 minute increments. I was wondering if anyone could recommend some good instructions/posts on best practices. My going-in strategy was to create a daily module and use an intraday list with 48 list items (one for each half…
-
percentages of a line
Hi: Apologies for the simple question but we are new at this!!! I need to work out how to work out the % of a item in a line. Using an excel equation it will be sometime like - a2/sum(a2:a5) I am sure it is something very straight forward but having no joy so far!! Many thanks for the help in advance!!
-
Deletion of numbered list consequences handling
I have created a module where i have some list formatted line items and some number formatted line items (all as columns) along with a Numbered list with display name as 1,2,3,4,.....(manually given by us) to create a blank view for the end user to enter records in each row(for reference; see the below attachment). The end…
-
New UX - How is version control of apps done?
Hi Is there a way we can version apps on New UX? And can we create DEV, TEST and PROD copies of New UX apps like we can do for models? Thanks Sarbajit Re: New UX Questions
-
Phased an income over period
Hi I need to phased income over time over period (example below)... any suggestion how I can do that please? Income per month line is where I want to get to!! Thanks in advance Income100200150 JanFebMarAprMayJunJul1204030 2 204030 3 204030 4 204030 5 204030Income per month20609090907030
-
Convert Date with Week Format to Last day of month with a Date Format
Hi, My model's Model Calendar - Calendar Type is set to 'Weeks: General'. I have a module with a column of dates and the Format is set to Week. In another column with Format set to Date, I'd like to write a formula that will take the date from above, lets say it's 9/2/2019, and output as the last day of the month in date…
-
Mass Delete / update of user assignments in selective access.
Hello Anaplanners, For one of our customers we have a requirement to dynamically update the selective access permissions to users. As I understand we can only import into Anaplan Users. I tried importing blank data into Users tab for list permissions but it still retains previous data. Further we cannot create a delete…
-
Dimension Mismatch
Hi, Please see attachment for details. Regards,
-
Only summarise at lower levels of hierarchy
Hi all, I have a model with the three lists; Cities_L3 which rolls-up to Countries_L2 which rolls-up to Markets_L1. In module I am calculating amounts at the city level using FX rates which are different depending on the parent Country. Is there a way I could summarise the cities to show a sub-total at Country level, but…
-
Ability to modify Role Access on Modules / Lists / Actions on a deployed model without ALM
I'd like the option to be able to change a module's role access in our live production model, which uses ALM to sync changes from our development model. This would be the equivalent of selecting production data on a list. This option would help because I wouldn't have to push ALL changes (including those still in…
-
Good Data Leads to Good Decisions
We all know that Anaplan is allowing business users to make fact-based decisions quicker and faster than ever before, but we consistently hear from customers that their data quality is not up to par. “Garbage in, garbage out” or “dirty data” are phrases you’ve probably heard. I hate to be so blunt, but data will never be…