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.
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…
why the numbers is not shown in margin % , unit price growth % and unit cost growth %? although all functions and format are right? thanks in advance
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.
Hi Anaplanners, I would like to know what are the different ways to fetch information about the integrations (versions, type of integration etc) that are present in my model? Are there any direct API calls using postman or I can find this information somewhere in the model itself? Regards
Subsidiary is the composite list here as an example, i want to filter my grids based on the selection at any levels. For E.g If i select RoW then i should be able to see all the data of Germany, Brazil, Australia etc.
Hi Team, I understood that we can use only Boolean drivers in DCA, why can't we use other data types? One reason is space, Boolean consumes less space than other data types. Thanks in advance.
Hi, I'm trying to update the data in Anaplan module line items directly from MS Access by converting into json format using Python transactional APIs. I'm keep getting the "Status code 400" , "Message - Post body is not a valid json". I have tried by printing the json format before sending the data into Anaplan and format…
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…
Hello Anaplanners. I have a module dimensioned by Month, but the Time Summary for my key line item is set to None to optimize space. However, I need to bring this data into another module that is dimensioned by Year. Since the time summary is disabled, the values don't automatically roll up to the yearly level. Would…
I have 2 modules set up, one with source data by line item that contains a 'Fund' code (CAL13) and then one with list mapping data by fund code (SYS34). I have set up a 3rd module and added in this formula 'CAL13 Consolidation by Fund'.Actual by Fund[SUM: 'SYS34 F4 Fund Details'.Account Mapping] They both have a level of…
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
Hello, Brain Trust! My organization uses Amazon Redshift data warehouse and some data we need for Anaplan will be stored there in the near future. The current assumption is that we will use Informatica to query, stage, and then import to Anaplan, BUT…. I really was hoping we could use ADO. In a prior life, I used Anaplan…
Can AnaplanXL (FluenceXL) reference an Excel cell's value to determine a list member needing to be referenced within a Custom Calculation? I need a Custom Calculation that dynamically calculates the difference between two versions, where one version is determined by an Excel cell's value. I cannot use fixed position…
Hi Anaplan Community, I'm currently using Cloudworks to integrate with Azure Blob Storage. In my setup, I see the option to enter a SAS token for authentication, but there is no field to enter a connection string. I have reviewed this Anapedia documentation, and it only references SAS tokens. Is there a way to use…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
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…
Hey, new here and starting out with the Model Builder I course. In Lesson 6 there is shown how to download the Formular and Function App. Unfortunateley this Video seeems outdated so i can't find this resource. Any trick here?
It looks like you're new here. Sign in or register to get started.