-
Date of version start
Hi, please help I've got versions with switchover: 1.Actual 2.Budget-mar 19 switchover 3.Forecast-June 19 switchover I need to have 2 line items showing: 1. Budget start date 2. Budget end date
-
Does Anaplan allow different formula for each levels within the same list?
For example, my entity list has 4 levels as follows: Country->Zone->Region->Area->Branch and it is a production list. In this case, how can I use the different formula for each levels? I understand that we can have a different formula for each level by having a separate modules for each level or by having separate line…
-
preference to the conditions in Optimizer
Hello Anaplanners, Working on optimizer and want to know if we can give preference to the conditions or constraints i.e. First Preference to skill followed by availability and then to Rates? Regards, Chamanpreet
-
Anaplan Community Search Function - not working?
Hi all, It seems as the the Anaplan community search function (Search bar at the top of the page) is not working - is anyone aware of this? Best, Callum
-
Delta record view from a file load
Hi All, I have a request to load a file to a master list and module, but prior to run this load I want to see what are the delta changes coming in the new file. So, I thought to park the new file in a temporary list and module and then compare it with master list and module to view the kind of changes I,e New node added,…
-
How to comapre Data from different Module and has Different Diemension
Hi, I have a module A with List A, and Module B with List B. Both the Lists are almost similar. But they are 2 different List. I have line Item PARENT_NODE in both Modules. I have new Line Item compare_Parent, were I need to compare and the result as "similar" or "different". In ModuleB I have written below formula but its…
-
Dependent Dropdowns + Selective Access (hierarchy)
Hi all, I am trying to create dependent drop-downs (picklists) for a Region/Sub-Region/Country hierarchy on an input dashboard, with selective access applied. Ideally, users should only be able to select Regions to which they have access, then Sub-Regions within the specified Region to which they have access, then…
-
What's the workaround to sort nested dimensions?
All, I'd like to find a workaround to be able to sort nested dimentions. (as currently it's not natively possible). I know that I can sort manually the list however as we have new members created everyday, I'm looking for an automation. I cannot either delete and reload this list everyday as I have some data at that level…
-
Working Days between dates
I'm looking to try and find away to calulate working days between two dates in a module; I know this has been addressed in a previous post, but it's from 2014 and I can't seem to access the supporting docs. that really show me what I need. I'm a new model builder so any assitance would be appriciated, and apologies if this…
-
How do i create a filter that used three dimenions ?
I need to create a filter that pans across three dimensions. I've tried using a boolean box, applying that to the lists I need to select. I think I'm going about it wrong. Essentially what I need to be able to do is - if I select a product, I want only to be able to see the components that are within that product. I also…
-
Process Builder - Access to Process Builder not showing
Hi Community, I am trying to build a business process using the Process Builder. I followed the early steps from the Workflow User Guide and am now set up as a "Process Owner" Problem though, the "Process Builder" isnt showing in the list of available choices in the application menu Anyone got this issue and how did you…
-
Deletion of orphans in list with selective access by non WSA user
How can the non WSA users delete the orphan records from the list where selective access is enabled? For exmaple if there is Production list and selective access enabled, there are orphans created as part of update in hierachy items. The non WSA users cannot delete the orphans due to selective access. Is there any way…
-
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…
-
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:
-
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.
-
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,
-
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…
-
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!!
-
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…
-
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…