Data Integration

Current page filters and sorts are applied to all pages of multi-page exports
This item has been identified as an outstanding known issue. Issue Setting a current page filter or sort and then exporting this data to file, will apply the current page filter/sort to all pages of the data. Workaround Remove all filters/sorts, export the data, and apply the filters/sorts in Excel --- Internal Reference:…
Can We Import /Export Files from Windows with SSO Credentials ?
Dear Experts , Could you please Assist me with my query , Actually i have received SSO for Anaplan System Access . Can I import/Export the Files from Windows? or do i Need Basic or CA authentication as a prerequisites. Also i am not having Model Builder / Workspace Administrator role. I would really appreciate for your…
Action Button to Trigger Outbound Requests (GET, POST etc.)
It would be great to have a button on new ux available that could be configured to send an outbound request to an external endpoint (GET, POST etc.), for now even an empty request could be helpful, but bonus points for allowing a configurable payload within Anaplan. This would allow us to seamlessly execute external parts…
Map attributes to time
I have a source file including 12 columns with the period of the current year. This file needs to be periodically updated into the Anaplan model. The file contains headers such as 1, 2, 3, etc. and I have to map these to the time dimension for the months based on the year the file is uploaded. Can anyone help me with this?
Work with Microsoft to make an Anaplan - PowerBI connector
It would be great to have a Anaplan connector in PowerBI (same idea as Excel and PowerPoint connectors), to have a live interfacing of data.
Exporting the Files by API using Python
Hi, I have around 16 exports to be automated through the python scripts. And I have defined the separate list of files with the file id and file names. Also I have defined separate list of export actions along with the ID and Export names and passing it to a function which will download the file. All the exports has the…
Looking for an alternative registration page
Hello, Lavish here, I am working on a problem which includes different suppliers/vendors to become users in our workspace. Now some suppliers/vendors are already registered with us so they can access the model. But for new suppliers/vendors we have to collect their information and then we have to set them as users in our…
Apptio - Anaplan
Have any partners or customers encountered an Apptio - Anaplan integration? At its core, Apptio is an IT budget/spend management tool that seems to do a decent job managing the complexities of a large IT landscape, but integrating that (rather than ripping and replacing) with Anaplan could have some pretty awesome…
Send and Refresh Error After Upgrade to 3.4
After I upgraded my excel plug in to 3.4, I can no longer write back to a module. I can Refresh fine, but if I attempt to Send and Refresh, I receive a note saying "there was an error detecting changes." Has anyone else experienced this? If so, please assist.
Having trouble mapping a flat file
Hi, I'm having trouble mapping this flat file into my Module. It will not let me manually map my data when I choose that option. Please advise. Pics are attached. Thank you
Last Non-Zero Occurrence
There is a requirement where in module 1(Pic 1), there are some transactions and users wants the Last Non-Zero occurrence in Module 2. How we can get the Last Non-Zero data in module 2(Pic 2)? Highlighted are the numbers that we want in module 2. Module 1 Module 2
Level 2 - Sprint 2 Import into DAT03 Historic Volumes using actions
The instruction states to 'run the 9. Import Data from Hub process to pull data from the Data Hub model into the DAT03 Historic Volumes module in the Supply Chain model.' I ran into this problem while trying to run all actions in process 9. I checked my Data Hub and nothing seems to be wrong with DAT03.Export view.…
A peek into the headcount planning process at Anaplan
Anaplan itself is certainly not unique in its challenges to get our finance, human resources, and sales teams on the same page of what our headcount is and what our headcount is forecasted to be in order to hit our revenue targets, and we've struggled in the past to understand where requisitions were in the cycle and how…
DCA working differently for similar scenarios
Hi, We have implemented DCA and applied the Read/Write access drivers in other Modules , post which it has actions to be executed. Once the processes are run, DCA works differently in 2 scenarios as mentioned below: 1. The data for the process "creation of staging list" executes but does not update the data (Step C :…
Home Page
Can anyone explain why if I try to log out from the Anaplan home page (by clicking on my initials then "Log Out") it just takes me back in and the only way I can exit is to click on the web page cross?
User guide for pre-built app
Do we have any user guide for the pre-built app available in app hub. Demand Planning, Supply Planning, etc.?
anaplan access
Hello, I am doing the training into Anaplan Community but I cannot access into www.anaplan.com to navigate with models to finish my traing It seems I should have a professionnal email, that I do not have Please, could someone help me and tell how can I get this access with a personal email , many thanks in advance Regards
API to access list of Process Steps
I'm currently using the Anaplan Integration API to upload files and run processes containing imports. This all works great. Currently if I want to run a process I need to be careful to upload all files associated with any imports it runs beforehand. What I'd like to do is to query the process I want to run and discover…
Live Time Tracking
Hello, Lavish here, I am working on a problem which includes different vendors to fill information and book a time slot to make a delivery. I am looking for a way to see if we can see the time at which a vendor is booking a slot. For eg. If a vendor is filling the form and booking a slot for 22nd Jan, 3 PM-4PM on 20th Jan…
Re: Issue while importing data using one of the mapping options 'Ask each time the import is run'
Hi, I am trying to import data from one module to another. And in one of the mapping, I gave the option as 'Ask each time import is run'. The issue I am facing is it is not mapping to one particular record, instead, it is loading all the records into one record. mapping Importing from this module Importing into this module
Api allow standard application contents type
As a data integrator working on industrializing data flows into anaplan from multiple application, i need to be able to consume standard data formats like json files. This is necessary to be able to call an api which will send me response typically in json format (standard restful for api) and consume the response with…
Pre - Requisites for Anaplan connect Installation on windows Server
Dear Team , I am New to Anaplan , I want to Install the Anaplan Connect at Windows Server Side. So i just wanted to know the Installation process and pre Requisites for the installation. I would highly appreciate the great favor. Warm Regards Shailender 7702196644
Level 1 - Lesson 7.2.1
Hello everyone! Lesson: 7.2.1 Activity: Importing Data into the correct Columns Issue: I have this error shown in the screenshots below. I tried to change switch around the sources but to me, this was the best solution. I also need to go back to my general list and delete out the product code data. I need to redo my import…
Decimal points dropping off amounts when uploading data file
I am uploading a .csv file with amounts that have dollars and cents. Whether the columns in my module are set to use decimal places or not, it is not recognizing the cents. 1633.34 shows up like 163334 when no decimal places are formatted and 163334.00 when I use 2 decimal places. Is there a way to see the amounts in the…
Actions in new UX
Hi Friends, I have actions and process created in old dashboard. I want to bring that in the new UX. I am trying to assign cards with Process but it is not getting saved. Any suggestions, will be of real help.
Number of users in a workspace
What is the limit on number of users in a workspace?
Q & A
Will Q&A sessions always be on Fridays at noon or will this vary throughout the week?
Allow tabs to be scrolled
Basically what the subject implies. Would be great to scroll between tabs in the UI using the scroll wheel (similar to google sheets).
VBA code to execute Excel Add-in toolbar commands
Hi, I am a new Anaplan user and am looking at using the Excel Add-in 3.0 to retrieve data into my excel-based reports. My preference is to automate report formatting and retrieves from Anaplan using VBA. Does anyone know if there are published Anaplan VBA commands like exist for Essbase? Thanks!
When missing code / unique identifier in transactual data (general ledger) for list dimension
Hi, What is the best way of treating a general ledger, in other words a big data transaction file, that is required to be in the data hub and is missing a unique identifier for each row, i.e. something to be used as a code for the list that will act as the dimension for the DATA module? I could create my own code in the…

Data Integration

Discussion List