Data Integration

Enable Display Name Functionality on Non-Numbered Lists
Hi Anaplanners, I love the Display Name functionality on numbered lists. I sure could use this across all lists. Sometimes building lists off transaction IDs makes sense but by the time the data gets to the end user flipping to the description would be nice. Thanks!
Anaplan Excel Add-in
Hi all, Following a member's recommandation, i'm posting 3 main ideas. I have recently discovered Excel Add-in existence and here are the 3 major points in my mind : First, I think it could be nice to be able to give only permission to retrieve saved views in order to prevent them to see technical items (not relevant as…
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
Anaplan API: Basic Authentication failed!
Hi, I am trying the Anaplan API connector tutorial and I keep getting an Authentication failed error. I have seen a similar question asked but might is particularly strange. Below is my script. When I include my password in the script I get the failure error. Anaplan API: Basic Authentication failed! (Feign: status 401…
Tell us your thoughts on ALM via a short survey!
Customers and Partners, Please take this short survey, which should take you less than 10 minutes to complete, to tell us your thoughts about ALM. Thank you, User Experience Research Team
Export Button based export filters Error
Hi, I manage a model that has export filters at the bottom of the dashboards. There are multiple dashboards. They are the same export filters; Version, year, and department. There is also an export button to export based on the export filter selections. The export buttons were working a few days ago and today we are…
Trigger API from Anaplan (native solution)
I would like to be able to trigger the API from Anaplan (e.g. button on a dashboard). This will enable sending data to another Anaplan model or to a different system event based by an end-user, rather then scheduling it outside Anaplan. Eventually it will enable much better integrations with 3th party solutions (advanced…
Running an Action to Export with a Mapping from Informatica
Hi, I'm trying to execute an Action to export data with the use of a Mapping in Informatica. I've executed many exports with mappings in the past, but for some reason with this action, I'm only receiving the headers. There are no rows of data. The strange thing is that when I run this action directly in Anaplan I get the…
Informatica - Export to Flat File
Hello, I have built a Mapping Task in Informatica to run an Anaplan action that yields a flat file export to a specific target. The process works well. The only question I have is that when selecting target formatting options, Anaplan suggests that you select Double Quotes as a text qualifier. The problem then is that all…
Noob question
Hi Guys, I am trying to map the price by SKU from another module but unable to. Not sure where i did wrong. Pls help!
Excel Add-in Saved Views / Formulas and Filters
Hello all, I have recently discovered Excel Add-in existence. I had a lot of questions but current trainings (or at least the ones i watched) do not provide answers. First, I would like end-users to have only permission to retrieve saved views in order to prevent them to see technical items (not relevant as end-user). Is…
Facing Problem for 8.5.3 Activity: Import Data into Volume Inputs Module
Hi @noelle_murphy & Team, I'm facing an issue with "8.5.3 Activity: Import Data into Volume Inputs Module" while importing the File. Can anyone please help me in this?
Error Message when loading into a List
Hi, Could you please explain what this error message implies? I believe that it is saying that it rejected the duplicated in that column of data that I loaded into the List, is this correct? Thank you
Community perspective: Using Anaplan APIs with R
R offers different ways to consume the REST APIs. This article aims to provide a foundation to use Anaplan APIs with R. This article assumes you have installed R or RStudio IDE. To work with APIs in R, we need to install and load R packages. These packages contain functions that facilitate HTTP requests, manipulate and…
anaplan sprint 2 1.3.10.1 - country import help
Import was successful However, something is off and can anybody help me what I did wrong? My G2 Country List has the code and parent assigned correctly Here is the check your work from anaplan course
Import special characters
Hi When I am importing "ñ"(alphabet with special character) into text formatted line item through csv file, it is taking as "Ã±". But I need "ñ". Could anyone please help me on this. Regards Shirisha.
Level 10-2-5 Boolean not showing the check box
Hello, can anyone help me with this please? I do not know why Boolean doesnt show the check box after importing data (please see a screenshot) I have been struggling with this for a long time. Any help will be greatly appreciated!
Updating hierarchy lists from user selection
Hi, lets say I have this hierarchy: A1, A2, A3, A4, A5, A6, some users need to change A4 from a module, this change need to update the list A4 and obviously this will impact A5-A6 lists. So I was thinking in creating a action that imports from this module into the list A4 but the point is that only the items changed by the…
Building Tableau Export for modules
Hi Team, I have module "ABC" where it has some 4 dimensions and 5 line items where each line item has a subsidiary view. I want to make a Tableau export with the above-mentioned module. Kindly help me with the procedure. Regards, Venkatesh
Unable to export view to Excel
Hi All, I am currently unable to export a view from an app page to Excel. When I select this option the screen goes blank and nothing happens. This feels like a bug but could there be a setting needs to be updated to enable this as I am able to export to a csv.
11.3.4- Values Not Matched
In this lesson, my values don't match those of the example. Everything was fine until I put in the formulas. When mapping, everything matched perfectly. May someone assist with finding the issue? The formulas are in correctly.
Store Start Date and Time (UTC) for Actions/Process Indefinitely
Reviewing past models or model history (archived) for even our current live models the Start Date and Time (UTC) for Actions/Processes is not populated for anything that's been run more than ~1 month ago. This feels like a gap in how this field should function. Proposal: The Start Date and Time (UTC) for Actions/Processes…
Inserting multiple list elements using an action
Hello, I was wondering if you could help me with a problem I am having. I have a numbered list A where the user would like to insert some elements without using the 'Insert' option, but instead by an action. Before, the user inserts the desired number of elements of the list A from 1 to 1000, as it is a numbered list,…
Error in DAT03 Historic Volume from Data Hub
All data is not getting captured , please help why data is getting ignored.
Time Ranges vs Model Calendar
Hello, I had a technical question around Time Ranges. Let's say my Model Calendar is set to FY21 Jan-Dec, I have 2 past years and 2 future years. I have some planning and assumptions modules that are only relevant for me for the Planning period. So I develop time ranges to save sparsity and reduce cell count in my model.…
NO Values is coming in DEM03
Need help for getting data to be updated
Level 1 Exam Time
Hello! I am getting close to taking the Level 1 Exam and was curious to know if there will be a time limit for this first exam? I just want to make sure I can plan my day for taking this test. Also, are there any lessons or resources that you would suggest I review again prior to taking this exam? Thank you!
Excel Add-in for Mac
Some of our clients use Mac computers and it would be great if you could develop excel add-in for Mac OS too!
Delete list items based on a line item value selection and then clear the line item value
This seems an easy solve and I thought I'd done this on a previous project, but still having trouble. What I want to do is delete items from our Transaction module based on a Period selected in a Data Management module and then run another import to clear the selection made in the DM module. The Transaction module in the…
delimiter options for exporting files from Anaplan
I love the two way integration that Cloudworks brings but there is a need for more delimiter options when exporting from Anaplan back to Data Lake. Example changing the delimiter from "," to "|". More export file options is needed.

Data Integration

Discussion List