Data Integration

File to Module Import Doubling Number
Hey Anaplan Community, I am having difficulty achieving the desired result with a file import to a list and then module. I wanted to see what workarounds have been used. Below is a simplified example of what the file structure looks like. File: Style Manufacturing Pieces 12345 2 12345 2 12346 3 12346 3 The information is…
Your help is needed! Excel and PowerPoint add-ins: best practices
Hi all, I am reaching out to the Community to get your input about best practices for the Excel and PowerPoint add-ins. Please share your tips and tricks to make the use of the add-ins as efficient as possible! The suggested themes are: * Governance of the add-in: upgrade process, version control, COE management of the…
Comparing two modules
Hi - Because of a unique use case, we had to create two modules with similar information except a couple of columns. I want to compare if the data is correct in the new model. Can you please suggest on how I can do this ? Sunl
Boolean Formula - Match line item with date to date on column i.e. item(time)
Hi, I am trying to write a boolean formula that will create the check mark where the formula finds a match between another line item containing a date and the calendar date on my columns, i.e. item(time). Attached are my current views and what I am trying to accomplish. Can someone please help me write this formula? I do…
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
Error while adding client certificate to anaplan
Hi, I am trying to add client certificate to Anaplan using Anaplan Administration->Security->Certificates. Received following error (screen shot attached) "No active user found with email address <abc@company.com> and tenant id <1214....>" Note: I downloaded SMIME certificate (issued by GlobalSign PersonalSign Partners CA…
Anaplan Connect Authentication Error
Hello, I'm trying to run a batch file for Export, but I am getting an authentication error. Please let me know how to fix this. Thank you, Veena My code: @echo off rem This example runs a Process that contains an Export actions set AnaplanUser=xx:password set WorkspaceId="xx" set ModelId="xx" set…
Level II Sprint III Model
Please suggest a Link from where I can download the FP&A Model.
History information seeking
Hi Friends, Any lights on how is ID values generated? It is sequential but why it starts with 200? I hope it's not year.
Create Technical Names for an Application
When you create an application it is often the case that you create a User Friendly name which is fine however when you then create any imports using this as a source the description will include this name and I always find myself having to edit the name by abbreviating the name of the application so for instance Data Hub…
Anaplan Excel Add-In 3.3 (Read/Write Query)
Hi all, I understand the ability to create a read/write connection with Anaplan was reintroduced in v3.3 of the Excel add-in. Where does this feature reside? I am using v3.3.44.0 and below is a screenshot of my toolbar; I have full access and workspace admin permissions, I also have write access enabled on the version and…
Limitations Of List Members Of General LIst.
How many list members can we insert in a list at a time.
KPI's Mapping from multiple lists
HI, In my datahub I have transaction list that I deconstruct into financial elements, profit centre, cost centre, gl account, order number in a mapping table. I have to report KPI's that are built up from multiple GL accounts and multiple Internal Orders, and I am wondering what approach to take to create a secondary KPI…
File Missing in Level 2 Sprint 3
Hi, Is there a .csv file for the Shipping Methods and Time taken for delivery? If not then it is not mentioned how should I populate it? Regards,
Add Filters for Data Import
I have Module A form where I want to import Data to Module B. I can't touch Module A, so I can't use Export function from Module A. As shown in the pictures, I want a filter Import of a particular country. I have worked on creating saved views and exporting but not sure whether same can be for Import as well. Any inputs…
Integration with ERP based on date uniqueness
Can Anaplan able to import data based on uniqueness of date? ( It's a numbered list) I'm trying to upload data with date as unique factor but not able to succeed at it. Please find attached screenshot where i try to upload quantity transaction data into anaplan based on customer, size, date uniqueness.
Add a new Data Hub
What are best practices when is needed to create a new Data Hub due to workspace space limitation to 130GB? I have already built the Data Hub which contains historic data and data validation processes. I still need to load further years. The only option I have, without deleting the data already loaded is to create a new…
Safety stock import filling missing
I find the safety stock import .csv file is not uploaded in the Sprint. The image I uploaded is an old one shared in the community. Can someone please share the file or assist how can I download it?
How to import data without manual mapping for Numbered list?
Hi, I want to upload data into a module that has a numbered list as a dimension, as a result of this I have to manually map list elements manually to excel file rows Any technique for automatic data mapping of numbered list elements to excel rows? PFA Screenshots of my mappings for more clarifications:- 1. Source or Excel…
Issue with value addition
Hi Community, Can someone help me understand, why am I not able to fill in any values for Volume Line Items even manually.
SFDC Integration
What are the available ways to integrate SFDC with anaplan, How i can enable data flowing between these two systems?
Informatica doesn't find Anaplan Model as source/target model
Hi all, I'm trying to connect Salesforce and Anaplan via Informatica. I've setting up Salesforce and Anaplan add-in in informatica and 'test loging' works for both. When I am trying to create a new synchronisation task for an update, Informatica recognizes Salesforce. However for Anaplan, it seems that Informatica can't…
Selective push of line items through ALM
Hello fellow Anaplaners, I was wondering if it would be possible to selectively push line items/modules while synching models through ALM? The idea is - I would like to setup a master model and then migrate only the required functionalities/calculations to two different target models. With this setup, I will have to design…
Lookup data from two line items with different format and "applies to" lists.
Hi, My current build has been full of surprises. Right now I need to lookup start dates for new employees, but, the module I am building and the model from where I need to take the data, both use different lists. As you can imagine the lookup does not work and I cannot just pull data directly over without a formula. Do any…
Anaplan sales planning with AI
Anaplan yesterday announced that now platform has capability of AI predictions for sales planning I am not able to find any documentation or anything on platform does anyone have idea where to find it?
HyperConnect Transformations
Hi, I'm trying to find examples of what kind of things can be done with Hyperconnect Transformations. I haven't been able to find anything on transformations.. TIA, Danny
import file amount rounding
hi anaplaner, i have problem about impor/upload file, when iam upload file number format, data in anaplan and excel file always different, ex: excel file 497.157.884.509 but in anaplan 497.157.000.000. how to fixing that problem?, and why is that? Thanks, Panji
Unable to Connect Using Basic Authentication : Says Invalid Credentials
This is my first time using Anaplan Connect My Batch File @echo off rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc set AnaplanUser="sripad.lokapure@abc.com" set…
Anaplan Connect model to model import process API Timeout
Having issues running the Model to Model import between work spaces. Has anyone encountered this issue... API request is timing out... Processes not found: Processes not found for Model ===================================================================== Anaplan Connect 1.4.2 OpenJDK 64-Bit Server VM (Oracle Corporation)/…
Use RESTful API to Export Data from All Modules (Without Export Actions)
Hello, Is it possible to export data from all modules (or selected modules; let's say there's 70 of them) without individually creating export actions for every single module? Thanks, Arthur

Data Integration

Discussion List