Data Integration

Anaplan Connect - SFTP
Hello, Just a quick question, does Anaplan Connect support SFTP server or only FTP server? Thanks, Ana
Effective Line Items rename during Fiscal Year changes
Hello , For Every Fiscal year development, we used to copy the models and rename the line items in the modules / dashboards from FY21 to FY22 etc. Later it was discussed with the user and renamed CY, CY-1, CY-2 (CY = Current Year), but the users are getting confused with these CY terms. Have anyone tried a different format…
There has to be a better way. Any ideas?
Hello, While on a rebuilding project with a client, I am ready to delete some modules. Problem is the line items in those modules are used in Formulas and are connected to downstream modules. I know I can reference the specific references in the Blueprint view, and scrolling over to see the Referenced By column. However,…
Excel Add-in Multiple View
Is it possible to publish multiple modules to one workbook in excel using excel add-in? I have a client that needs a dashboard (containing views from multiple modules) to be exported to excel that needs a specific formatting for shareholder's reporting. As far as I can see there's only one connection to a module per tab.…
Import into List - duplicates in key
Hi I want to import a customer forecast into a module. The customer forecast is Key, Product, Location, Date, Qty My end module will have a key dimension which is the Product/Location and dimension time, with a value of qty. So part of the import process is to create the key List. If I import into the key list from the…
GUIDE: February 2021 Release | Time Stamp on Actions
Community, Just a quick heads up. Every time you run an action you will now see the timestamp on the action tab. Awesome! Here's an example of a manual action being run. I tested it on automated actions too and it works great. Thank you Anaplan - huge win!
Anaplan CloudWorks API and Azure Logic Apps
* Use case: event-based triggering * Building a Logic App * Technical flow * Special focus * Conclusion You’ve already had a flavor of using Logic Apps with Anaplan API in this article, thanks to my colleague Sean Culligan. In this post, we will do something slightly different by using Anaplan CloudWorks API with the…
Add API functionality to list the line items shown in a Saved View
I would like to see a new API call or an update to the existing view metadata call, that lists which line items are "shown" in a saved view. The only way to get this information now is to read the view and parse the header line. When using the API to build an integration, pulling the metadata of an object before pulling…
Anaplan Hyper Connect Error
Hello Team, When we use Hyper Connect for Anaplan integration, we are frequently getting following Error and unable to figure root cause for the same. [ERROR] Write Failed. Internal Error: Adapter Write Returned Exception: com.anaplan.adapter.anaplanv2.metadata.adapter.service.exception.AnaplanServiceException: IOException…
Import from a module to the same module
Hello, I'm coming to you because I have a problem with a customer that I have never encountered before. I am trying to import data from a saved view of a module to this same module. The saved view uses a filter that allows me to bring the data from an entity X to an entity Y that is selected at each import. The action…
How to import data in accordance to 3 different identifiers for a data set
Hi, I'm trying to load a data set into Anaplan that has three different identifiers for the data set. The three identifiers make sure the data set does not have duplicates. The three identifiers in the data set are contract_id, Process Entered Data, and date_applied. At first I created List for all theses identifiers and…
Display list items with non-zero values for sub-list creation
How would you go about creating a Module that looks in other Modules and finds every item in a list that has any non-zero values entered in a given 12 month period? The idea would be to create a table that shows, for a given group of lists, all combinations of those list items that have at least one non-zero value in the…
Time Range and Line item Period Allocation
HI All, I have a question since my mind has gone blank, I hope someone can help. In my current model, i have imported data for a series of journeys which start on a weekly basis for each transport number, within the journey there are a series of stops for loading and then discharging stock. Pages: Time Range Rows: Journey…
Wdata Server File
Hi All, Does anyone know how we locate the Anaplan Server file to create a wdata chain to Anaplan? Thanks!
Error when importing a list where parent name = child name
Hi, I'm facing the error "New property combination found but name or code already exists" when importing a list where the parent name is equal to the child name, but with different codes. I've attached an example using a hypothetical Region->Country-> Location sharing the same names within all levels and the error…
Activity 6 Level 1
Hello All! I can't seem to do this for the life of me. I'm not good at creating formulas at all, and have no idea where to start in this particular anaplan venture. But when I try the following, i receive this:
Exam Module 4 - Help
Its 4 hours into this exam....very frustrated. Why are my target items greyed out, and how come I don't have a "role" to map the role to??? I'm not a developer....this exam truly is frustrating
importing into numbered list
I really don't understand why my E2 Employee# numbered list is displaying the wrong code. My source file (excel) when i download from the lesson is also not downloading the right. i have the code in 1,5,8, but it should be in 001,005,008. please can someone help. this is affecting my result every time i reference to this…
SYS08 - Import EXAM Activity 4
What am I doing wrong Anaplanners? lol why is Department greyed out?
Upgrading to Excel 4.4 and/or PowerPoint 1.8 and migrating to SS SAML
Just a note to any of you using the Office extensions for Excel and PowerPoint. If you are using any versions earlier than Excel 4.4 or PowerPoint 1.8 you should have received an email from our Ops team detailing the process for upgrading. This is to allow migration of your platform to be able to use SS SAML going forward.…
Exam Activity Builder 5
HI ALL - what is wrong with my code??????? trying to change to EMP03 etc etc...i've enclosed a shot of my SYS08 file too
10.2.4 importing activity
These mappings don't seem to want to work for me, in turn all my import is ignored. Any suggestions?
import a column with alphanumeric into number formatted property
Hi , can you assist me in following , so i am loading a file with a column into a number formatted list property , in the csv file along with numbers some entries have text only while some entries have text along with number(as shown) , when i load this file in model , so all text lines are ignored , but somehow anaplan is…
Import from one version to another version using import
I need to import data from one version to another version - Forecast to calc version (Manual Version). This module has 4 pages - Total hierarchy, year, wave, version Total hierarchy - Total > 1st level > 2 nd level > program Version is fixed version - always to calc version Program - i want to map single program each time…
Accept Cookies Confirmation popup & Course content not getting loaded
Hi All, when even I login to the Learning.anaplan.com I see the below confirmation window pops up on every refresh inspite of providing the Acceptance confirmation. Wondering if this something local to me or anyone else facing this issue as well? In addition the course content is not getting loaded - appreciate any inputs.…
Extracting data from Anaplan with Qlik Sense
So you finally did it – you joined the Anaplan Community. So many possibilities just opened up in front of you when it comes to connected planning and finance, but what about analyzing and visualizing your data? Well, no need to worry about that because Qlik has that part covered. In today's article, we'll be talking…
Basic Auth integration failed
Hi team, as we know anaplan password need change every 1,2, or 3 month. but when i impelement integration anaplan with workato using basic authentication, and every time i get error 401, i need to change my password a couple time in 1 month. why this case it happen?, and how to fixed? Regard, Panji
MB Level 1 Lesson 11.3.4 Getting the Wrong Output
I am having an issue where only 1 cell does not match how my model is supposed to look like. It seems like "Utilities" (and subsequent line items that use utilities as part of its formula) is the only line item that is generating incorrect data. The first picture is of MY module, the second picture is what the module is…
Help with Lesson 8.5.3- Import Data into Volume Inputs Module
Please help. I've attached screenshots and don't know why I keep getting the time error message. Thanks.

Data Integration

Discussion List