-
Switchover, use it or build your own?
Hi All - In the context of an FP&A use case, we're trying to evaluate whether to use switchover or just build a system module to dictate where the forecast begins and the actuals end. Would love to hear about pros and cons of both approaches. Here's what I have so far: Pros of using native switchover: 1) Ability to use…
-
Getting an error for a user who is not a workspace adm
A process updates a numbered list from a saved view (Module.Saved view) -> (Updates List name, parent, code and few properties) When workspace admins run this process, it completes successfully with errors only for duplicates When a user is not an admin runs the process however, the following errors appear: * You are not…
-
P&L Variance List
Hi, Question please. What is the best practice if I need both the columns and rows as a line item because I need to calculate the variances and the difference to maintain the clients preference on the presentation. Below is an example. thank you.
-
Set Period as Column in a Module
Hi! I have to create 2 reports, one with year only as column and another one with quarterly as column. I do have the data module with month as column, but that's not the result that I want. Previously I just show the data module and hide every months then show Q/Y only but I don't think that's a good practice, since if…
-
Ability to include a Line Item in a Line Item Subset via an import process
Currently, the only way to include a Line Item in a Line Item Subset is to manually go into the Line Item Subset and check the Boolean to add it. What I'm proposing is the ability to import into a Line Item Subset's "include Booleans" so that one can include/exclude Line Items from a Line Item Subset based on a Boolean…
-
Demand Forecasting
Dear Community, I am trying to build a system with 2 regional sales manager and one sales head. Regional sales managers should be able to submit their projected numbers and sales head should be able to see, who has submitted and what have they submitted in the Anaplan. Do we have any courses around this in the community or…
-
DATA02 import issues
I am struggling to import data over to the DATA02 module. I believe I have the right options selected. I am just not sure why its not populating all the data.
-
NEW UX: Drilldown to be formatted & have the ability to be expanded
The current drilldown functionality in the New UX is not compatible for complex formulas. It would be a great improvement if the formulas can be formatted (like in the classic) with bolded text for functions, and indentations for IF/THEN/ELSE. It would also be ideal if the drilldown window can be expanded to cater for…
-
Time Range < 1Y
Hello, would be great to have Time Ranges functionality linked to the Current Period & for less than 1Y, e.g. moving two-Q range linked to the current period of the model. This for sure will optimize AN models in terms of speed & workspace size. Best regards Kristina
-
Day Period
When using Weeks as a Calendar Type in Anaplan Time, there is no easy way to aggregate from days to months. We would be able to use TIMESUM function, but you cannot used simple Dates to indicate start and end of the month as function parameters -> it needs to be Period type. Unfortunately line items with Period type can…
-
Level 1 Model Building - Lesson 8.6.4
Hi Community I have included the formula as requested into the formula line of Revenue however it's giving me the attached ERROR MESSAGE which I can't seem to rectify. Any assistance regarding this would be greatly appreciated. regards
-
Level 3 Model Building (Importing Module data into List from Data Hub)
Hi, I'm having problems importing data from my Level 3 Model Building Data Hub into the other Level 3 Model's List. I need to Import that from my Module SYS14 Create Account> Product into the List A2 Account>Product. I created the LI's in the Module in the List as Properties, but I'm having trouble pulling in the data from…
-
New function to calculate 'Inception to Date'
It appears that there is no out-of-the-box function to sum all values up to the current period to return the 'inception to date' value. A new function could be very similar to MONTHTODATE and YEARTODATE but calculate from the start of the time range up to the current period (potentially with optional offset arguments).…
-
Sum all values in a time series up to the current date
Is there a way to use TIMESUM or MOVINGSUM to sum all values in a time series up to the current date? Essentially creating an 'inception to date' calculation. For example, if I have a monthly time series with the values 1,2,3,4,5 then I want my inception to date calculation to return 1,3,6,10,15. I can achieve this by…
-
Auto-populate list formated line item
Hi, It would be great to auto-populate line item if this line item is formated as a list and there is only one list item member. Currently, user has to select the list item, doesnt matter there is one or more list item. Thanks, Humay Kh.
-
Is it possible to show or hide the parent hierarchy?
Is it possible to hide B in the following hierarchy? My hope is to hide B and show A and C. <Sample> A(parent hierarchy) →B(parent hierarchy) →C(Child)
-
Select Function
Hi Community, I am trying to use select function with an list member, but it is not working at all. Is there anything that i need to enable as a part of setting? Thanks & Regards Badam
-
How to perform activities while starting as a beginner with no application on the system?
Could you please help how do I get to access the application hands on for practice and further to perform activities to answer the exam questions through my system LIVE. I'm a beginner trying to give L1 exam. I have completed entire course theory with certain practical activities yet to be practiced. Any help is highly…
-
Level 1 Importing Into Modules and Making Edits
I'm on Level Lessson 7 and there are multiple activities where I have to import data from csv file. Is there a way to make edits to mapping after data has been imported already or do you have to start from scratch? In general is there a way to undo mistakes in Anaplan? Tried ctrl z but it does not work.
-
4.8.2
I've been having an issue with locating my error in the model for the Parent Error I keep getting everything is mapped out correctly and I've literally lost 2 days trying to figure this out it's not because of lack of effort. But now I fear I won't have my lessons done in time to stay on pace to finish. I really need some…
-
Line Item Restriction
Hi Community, Can we restrict the user to enter only positive numbers in a line item? And if he enters anything apart from the it should also throw some text, displaying only positive numbers are allowed? Thanks a lot for your support 🙂
-
L2 Sprint 3 Distribution center capacity module
Hello Can someone please double check the formulas used for this module, its showing percentage for more than 100%. Is that normal? Please help me correct if there is any error in formula. Thank you!
-
ANAPLAN
what is the difference between OFFSET and POST ?
-
3.5.4.2 Create Distribution Center Capacity Module
Hi, I am getting the incorrect values even after putting the formula according to the purpose. please help if any mistake i have done in formulas. I getting the values greater than 100% in percentage full line item.
-
Format of mapping used for lookup doesn't match any dimension of the source
Hi all, I've looked through several of the queries/answers on this topic and still can't work out what I am doing wrong... I am trying to provide a summary of employee expenses by region and role in REP04; I am trying to use EMP02 as my source as this has employee expenses by employee and department. As there is no direct…
-
System Modules
Dear Community, @rob_marshallJaredDolich Why does most of the Anaplan Modules in the App Hub: Such as Long Range Planning is not using System module creation and directly jumping to data / input / calculation modules? It is going to impact the module sanctity right?, Your expert views would be highly appreciable. Thanks &…
-
Grid:_onSelection Change Error
Does anyone know why this error occurs? It is typically when I am building a formula then click on a different module.
-
How to use SUM and LOOKUP dynamically
I have Order module(Region, Order) Order(1,2...) comes from each Region. Order has Item and Amount. I want to aggregate item-amount by dynamic Region like this table. If Users chose the Europe, Item-Amount Table is aggregated by Europe. I tried SUM and LOOKUP but I couldn't. The point is I don't need Region List in…
-
Open multiple items from Search in NMX.
I am submitting this idea on behalf of Okta. When using the New Model Experience, we would like to be able to select multiple models from the Model Search panel. Right now, the process is that we use the Search, select the model, open it, and then have to open the search and re-type the search again to re-select a second…
-
Creating new line items for each year instead of using native time?
Hi All, I recently took over a few models that make use of a month list and separate line items for each year instead of Anaplan's native time functionality. I was told the models were built this way because end users didn't find the dashboards to be intuitive and this was a means to improve the user experience. Here's an…