Data Integration

Default Files - Export
Hi Team, I'm struggling to understand the concept of Default Files when Exporting. I have created a Saved Export Definition when Exporting from a Module & I am creating a Process to house this so that it can be published on a Dashboard for a User to use I have set the Default file to Private/Myself & when the User has…
Anaplan AWS Integrate Conflict
Hi! After we integrate Anaplan to AWS servers (https://community.anaplan.com/t5/Anaplan-Platform/How-to-integrate-Anaplan-to-AWS/m-p/63302) we starting to get analitics data conflicts. We grab data from Google Storadge which work with site(here link), grab with Python on AWS. Our bisness analitics have Flask microservice…
Excel Add In
Hi All, I am working on a model in which I have a combination list(A numbered list with various properties such as states, product, factories) applied to a module. When I am creating my excel sheet for that particular module using excel add in version 3.4 I am getting all the combinations of the list irrespective of the…
DAT03 Historic Volumes
I am unable to get the mapping correct. Can anyone assist?
Option to export Graphs with Title and/or Labels
When exporting a graph from the New UX, the title of the card is dropped as are the labels/selectors. This is the case whether it is exported via "print chart", or PNG/SVG/JPEG. Ideally, there would be an option to include/exclude this information on the export, but at minimum to automatically include this information on…
Export Action Mapping Basis
Sorry, couldn't find a official answer to this, and I've had different interpretations on how this worked over time, but just wanted a definitive answer: For export actions that you intend to repeat, what is the "official" way that the Export action is defined, relative to the module you are exporting from? We all know…
Excel Add-in: restrict end-user ability to create a new connection
* Description: As an author of the new Idea, I want to suggest the new level of security in Add-on(s). Where we can restrict the Non - WSA User not to create a new work book using the models that they may have access to. * Example of Enhancement: If the user is not a WSA for the particular model he should not have access…
Ability to filter module data for export via the API
Description: Be able to pass filter values to the export view through the REST API. This could be passed in the request body Example of enhancement: Let's say we have a view with data for all our hotels. We'd like to call the rest api to export data for specific hotel. Benefit/impact: We need to run exports through REST…
API usage on Users tab
Description of the enhancement required: 1. API : ability to delete users from a workspace via api. 2. API :ability to create users to a workspace via api. A story for why you want the enhancement: The process of searching for users, clicking their names, and clicking delete is very tedious.
Allow the option to not create an import as an action
The ability to select whether you want a manual data import saved as an action on the actions tab is requested. The reason being that during development and for sprint review purposes, sometimes test data or files with lists are uploaded to allow clients to visualize the end product. Every time an import is run, an action…
Quiz Time: Test Your Knowledge About the Extensions and Learn Whilst Having Fun!
This is the quiz we ran at the UK&I virtual user group in June. For customers who are part of the group, the recording of the session will soon be available. This was a fun session and the top 5 participants won some Anaplan swag 🎁 It couldn't be simpler: * Read the question and select your answer(s). * Click on the…
How to force unique constraints in a List
Hi Need a help. We are uploading the datafile into a General List. The code is supposed to be having unique values. But due to user error, we end up having duplicate values in the code column, causing issues in downstream process. Is there anyway, we can do a check for duplicates during data file upload? If not, can you…
Level 1 model building part 11: DATA 01 P&L actual & Budgeted
Hi team, while importing my CSV file of DATA 01 actual and budgeted, , mapping for the forecast is not available as shown in the attached picture. But then how come forecast is also throwing the same result as actuals, is it by default set to actual data?
Create List Item - Action
Hi Team, I'm trying to create a List item from a module through a standard Import action but the Import is using the Line Item name rather than the input data for the List Import. I feel like this is such a simple thing to do but I managed to mess it up somehow 😂 The process is: Create saved view with data from input. The…
Excel Add in
Hi All, I just wanted to understand few things about excel add-in feature in anaplan: 1. When I use pivot and filter to generate a view in excel using excel add in through anaplan and later the list which has been filtered in my excel ammends or changes in the module(e.g a new item has been added to the list or an existing…
Defining Anaplan Add-ins, Add-ons, and Extensions
We have simplified the terminology we use for Anaplan Add-ins and Add-ons. In order to provide complete clarity about these products, “extensions” now represents the product family for the individual Anaplan Add-ons and Add-ins. The blog below breaks down the new naming details and best practices. Individual product names…
Anaplan Connectors for Informatica Cloud
Hi Guys, I'm trying to use Informatica cloud to connect Anaplan using it's Informatica connectors But i'm not seeing these connectors in my Informatica cloud. I tried to download the trial version of it but I'm getting message, my Org already have access to these connectors. I have reached out to Informatica team and they…
Organize Actions after Model Building
After completing model building activities, we need to prepare the model for User Acceptance Testing, one of the requirements is "Review and organize the Actions to rename and add repeatable actions to a process and remove any single-use/one-time actions"... When I look at the actions, some imports were conducted multiple…
L1MB - Model Building - Importing data to Modules (Employee Details)
Dear APC, Can any one help me why I get to see mismatch in Employee names when the file used is same for creating the Employee List and Employee Details Module. I tried to delete the Employee list and re-created the new List and loaded employee names from csv file. Same csv file is used to load the Employee details - but…
L1 SYS08 Employee details data import target item greyed out
Hi, I'm trying to import data but the "department "is greyed out. Does anyone know why this might happen and how to fix it?
Importing into SYS08 system module
I am confused with the mapping part of the source to target as well. As is where to map Active? Employees = Code? ( Because it is numbered list) Dept Code = Department? Country Code = Country? Active? =? How to make sure data we are mapping is correct?
Add the ability to make external REST API calls from within Anaplan
We should be able to trigger external APIs from Anaplan models so that we can build integrations between Anaplan and other systems and allow the Anaplan users to trigger them when they know the data is ready.
Anaplan Excel Add-In 3.4, Show Changes
Hi Everyone, thanks for your time. Would like to ask if anyone knows if it would be possible to update multiple modules at once across different sheets with the show changes option in the excel add-in (similar to how refresh worksheet works). Currently I am able to only do it for each sheet, am asking to see if I missed…
Level mismatch on common dimension
i would like to get inventory DOI calculation from module-KPI DOI to module-Inventory ending report. Therefore, i inserted 1 line item call DOI into module-Inventory ending report then put formula as below. Then i get below error message. You can refer to attached document for 2 modules blueprint. Module inventory ending…
Rename List items
Dear Friends, I need some help from you. I want to update my list. My initial list items (12 list items), will be renamed and a new list will created with the (4 list items).
Urgent help assistance
Hi Friends, I am struck with a difficult situation. I have Module 1 and this is the Data Hub and the Date is stored in Text Format. Every quarter I need to pull the data and make it look like Module 2. Now my problem is as the Date is in Text Format, I was trying to find the current year. By converting Text to Number and…
Requesting a serious help
Hi Friends, I want to create an Action process. That will automatically import the current year data. Please assist me in this.
Time out issues with Anaplan Connect v1.4.4 console while importing LARGE files
New to Anaplan, loading large volumes of historical transactional data to support multiple models. We have a clean structure and the process "works" but virtually every import into the module has our session in the console timeout. It appears that the file has loaded successfully, but when the console times-out, I lose…
is there an API Endpoint for all listed import errors?
@jesse_wilson Is there an API endpoint for all import errors? For example, a user can get these types of errors when importing to a model: no items in a list, failed cells, and unmapped line items, etc. I've automated imports with a custom script. I've now purposefully introduced errors into my imports so they fail and…
Mapping numbered lists during module to module import
Hi all, Seems like this should be a straightforward one, but I can't figure it out.. I am trying to import data from one model into another model, using numbered lists. The Source module and Target module (which are in two separate models) both have a list called 'Towns' as a dimension. This list is a numbered list, but…

Data Integration

Discussion List