Need practical solutions quickly? You've come to the right place.
Connections are the heartbeat of Community, aligning members around common themes. Here you’ll find questions and solutions that bring real-life experiences to the forefront to benefit the entire ecosystem. Join the conversations — happening now!
Discuss APIs, Data Integrations, Extensions and more.
Topics like PlanIQ and Predictive Insights.
Discover how to build efficient models that deliver the best results.
Learn how to keep your data and users secure.
UX features and end user collaboration.
Tell us how we're doing.
What is the maximum number of rows and columns a CSV file can be imported into the module when viewed as an Excel file?
I may not be clear because I'm using a translation tool to convert Japanese to English. I'm in a lot of trouble and need your help. The problematic area: level 2 sprint 2.3.9.2 When I try to execute Process 9. Import Data from the Hub according to the instructions, I get an error as shown in the third image. Please tell me…
Hi All, Can anyone please help me with this issue, I was working on Profit and loss module in Level-1 Model building course. The results i am getting after adding the formulae are different from the screenshot shown in course. Can anyone help me with this. I have spent quite some time trying to solve but yeah no use. This…
Hi Anaplan Community, Good Day! Can you help me solving the user filter saved view on module. My goal is to have an import process where the user will use and the only data that will transfer is their account entry. I will be using the native user as line item on this report: I created an additional module to use as a…
I want to understand on how I can get access to new fluence/Anaplan disclosure management Is it part of the license? Also can multiple users work on a single report at the same time using this tool?
Hi everyone i have encounter today as an admin in Anaplan. one of the user has no access in one of our workspace. this is the users access under Users-Internal-Workspace. but upon checking in Access Control - Assignments, FP&A is not selected.
Hello, I am working on a project that requires conditional formatting for a graph, such as orange for bottom 10 products and blue for the top 10 selling products. Is it possible in Anaplan or is there any workaround for this? Please see the attached picture for a sample graph I want to create. Thanks
Can you set up a bulk copy between models? I have two models. One is a stand alone Financial Forecast with numbers adjusted in various modules and saved views. The version in that model is named the working forecast. The other model is our main Financial Forecast and I have created a version specifically for the data to be…
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until…
Hello, I keep seeing the following error message: Invalid formula: 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DEM02 Volume Growth Rates by Week'.Growth %, -52, 0) ELSE 0 For function OFFSET, all line item arguments that vary by time…
When importing/exporting data using Anaplan Connect 3.0, if the file is 100MB or larger, it will be split into chunks according to the chunk size setting. When this happens, if the file contains multibyte characters such as Japanese, the characters will become garbled. Does anyone know how to solve this problem? Or will…
Hi, We came across org charts (Hierarchy Charts) which are a great functionality. However, we want the client to be able to do scenario planning on the hierarchy and by Month. E.g. John could report to Smith in Jan, but in Feb , he report to Molly. Since Org Charts cannot refresh dynamically unless you incorporate time…
Hi Team, I have received a project that requires experience with PowerShell scripting. How does it work with Anaplan Connect? I have experience with CloudWorks, but I would appreciate any resources or insights on using PowerShell scripts with Anaplan. If anyone from the group can share guidance or useful links, it would be…
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
When I use the following as formula of a line item in order to assign the value of another module line item to it: 'CAL01 KISO Prelim Summary - v3'.Direct Fixed Cost or MONTHVALUE('CAL01 KISO Prelim Summary - v3'.Direct Fixed Cost) It gave me a value equal to 52 times of that month's Direct Fixed Cost value. Is it…
Hello community, I am going through something with Lookup formula as below. I have a module (say module1) dimensionalised by Account list with Account code column. I also have a List (say list1) with account code, employee code and names. In the module 1, I have created line items for employee code and name. For which I am…
Originally we had A1 Expense Group, A2 Expense Category, and A3 Expense Account. We added A3 Subcategory and changed the naming of A3 Expense Account to A4 Expense Account. We have been unable to change the Parent of A4 Expense Account to be A3 Expense Subcategory. Attempting to change this gives the error "Level Mismatch…
I need to build a Slope and intercept formula where my X values are dates. Like in the screenshot. Since in Anaplan (the normal build) way we calculate by using the formula as mentioned. How to convert dates into number format or otherwise how can we achieve the same Example :
Hello everyone, on my activity, the totals for the other expenses are not populated as the same with the should be result in the activity. Here are some screenshots. This is my model: This is the should be: Any solutions to this? Thank you
Hi All, Just another simple one this time. I need to capture the code of the L0 Hospital subsidiary. I tried code(item('L0 Hospital Subsidairy')) formula in a text formatted line item i keep getting an error. i need to put the L0 code on the hospital code column to match the L3 department. the hospital code column is text…
I have my .csv file are all Feb data But after I imported to my module, the Feb data are correct, Mar are zero, but all other months before should be zero. They are not: May I know if I have forgotten to do some settings ? Thank you.
It looks like you're new here. Sign in or register to get started.
