Data Integration

Urgent help requested
Hi Friends, If my file is no longer available in the server. Then after importing the file and manually running the action. Will it read the file from the server instantly or in the job run time.
Anaplan Mulesoft Connector Refresh Token Issue
Hi Team, We are using Anaplan Mulesoft latest Connector for our client and With certificate authentication or basic authentication, Anaplan connector is failing while getting Refresh token after every 30 min. This behavior is happening randomly. So when 30 min completed and we send a request it is failing because of…
Import file to module
HI team, I am trying to import csv file to a module, it is worked and record updated in respective module. But when the same action trying to update using new set of records in source csv file via manage import data source "file not exist error " getting. i have delete the action and import again it is working in dev…
decimal places more than 15 do not total right:
Dear Team, I would like to seek for your enlightenment on this area. I tried to copied several times an amount (percentage in real number format) with a decimal places of 19-20. it copied correctly in anaplan and i selected the number format of significal number to 15 places. However, it does not total correctly. it would…
Anaplan Essentials for Customers - "The Essentials of Model Building" model missing
I am at the last section of Anaplan Essentials for Customers training. As per the training instructions, I need to download The Essentials of Model Building model and create my own copy to start with this section. Whereas, this model is not available in the list of models. Could anyone help with this. My Workspace is CIMD…
Level 1 Model Building #E2 Employees import
Hello, I can't get the Employee list import to work. I've tried all thinkable combinations of settings when importing the employee list to the #E2 Employees numbered list, se enclosed import page and error report. Can someone help me out? /John, Anaplan beginner.
Anaplan Connect: SQL Server JDBC Connection (No suitable driver found...)
For the love of free internet points and karma, I am sharing my struggles with Anaplan Connect setting up a JDBC connection with SQL Server. Purpose: The below has been documented to assist with setting up a JDBC connection to a SQL Server database, the version of JDBC driver used will be dependant on the database version…
Lesson 8.5.3 Volumes Data Import Rev02 New
Hi - I am having trouble importing for module 8.5.3. I have uploaded data and chosen the format as shown in other members questions for this module. Steps I followed: 1. Updated CSV file update to show first header is row 2 and data in row 3. 2. Chose correct parameters and chosen "Fixed Line Item" for Rev02 3. Went to the…
Ability to test the Docusign Integration without sending out an Envelope
DocuSign currently charges a rate for sending out envelopes, and clients would save money if we allowed them to test the integration without having them send out an envelope. If you are working on a large document, you may be testing a number of envelopes to test. This can cost the client quite a bit just to do testing. My…
Loading Transactional Data into Data Hub
Hi 1. Why do we create a concatenated list to load transactional load into data hub? Instead we can create individual lists as dimensions and load data. 2. Why do we create hierarchy lists as flat lists in Data Hub? Thanks Ibrahim
Mapplet In Informatica
Introduction A mapplet is a reusable data object representing a set of transformations and its logics to transform data among the tablets. For example, Let's assume there are n number of tables. Our requirement is to select the dimension keys associated to each table. We now create a mapplet with a series of Lookup…
Date format during CSV import
Hi All, I am trying to import the below CSV file to module, but unable to get the correct time mapping detail, any help will be appreciated . CSV File :- Mapping Column view :- Time Dimension mapping view :- The problem is I am not getting the month neither under "Pattern and Separators" nor Fixed Position patterns. I…
BI Connector - importing all dimensiosn
We are working on setting up a BI connection to Anaplan. I have saved a view for export and filtered on only select locations, months, etc. However, when we import this into BI it seems to override my filters and brings in ALL locations, ALL months, etc. Is anyone else having this issue or know how to ensure only those…
Front end and Back end
Hello All, just wanted to ask about the experience regarding the module design phase like we usually adopt, first we all have look on the UX experience, then the functions like calculation etc and at last about list, modules etc .. If somebody has a different view please share, as in my organization things do get changed…
Import of Saved View
Hi All, I have created the module SYS12 SKU Data and Saved view as "Build SKU" and "Import SKU Details". but while importing the Build SKU saved view in new list P3 SKU I am not able to find the saved view for selection , below is the screenshot for the same. Let me know if in case I am missing any thing ?
level 2 Run Process 9 Import Data from the Hub.
Hi while running the process 9 in level 2 under the 9.1 historic volumes, few of my data is getting ignored. please help to figure it out. attaching the screenshot of the same.
level2 sprint2 : import DATA03 into historic volume
Hi in the attached screenshot my import is getting completed but it's getting ignored. please guide for the same
level2 sprint 2 - Run Process 9 Import Data from the Hub.
Hi all i know we need to change the timescale for DATA03 can anyone guide into how to do this please.
List Subset
Hi All, I have created the list subset as below , but I am unable to select the desired line item of a referred module in List Subset :- List subset :- Referred Module :- Thanks Vivek
Need anaplanners
Hi, I have a couple of open position for Anaplanners with finance background. If any of you are interesting please email me @zulychg@gmail.com (location can be in LA, Portland, Las Vegas and Vancouver) Thanks Zuly
DAT02 PY Revenue to CY module Level 3 Sprint1
Hi Team, Have followed steps in training module but not getting exact value which is there in screenshot. Stuck in between .. pls suggest or provide hint where I'm doing wrong. Attaching screenshots Getting All products values from DAT01 PY Revenue in all individual products of DAT02 PY Revenue to CY. Please suggest
How To get the Level 1 MB Certificate
Hi All, Can you please share the link or path to download the certificate, as I have completed the level 1 certification course. I have checked my learning, but couldn't find any certification or any survey link etc .. Thanks Vivek
Lookup Mapping
Hi All, i am facing the issue in referring the data using the lookup function, I have described the issue in the attachment, if any body can help me with this it would be great. Thanks Vivek
Importing from a module into Users
I am trying to import from a module into users. There is one field in the module for a particular user that we are trying to bring in multiple values in the list selected. We are using the "text" format to enter the two different values in that list because we can't select multiple values in a list when it is in the "list"…
Issue: Combine 2 columns
Hello all, I am fairly new to Anaplan and I would need help with one task. I have 2 columns and I would need to create additional 3rd column, where the first 2 are combined. The combination should work as follows: look for a string in one column, if you find the string, assign the string, if its blank assign the value from…
Time settings change
Dear Friends, If I update time settings (Month & Year) in Dev and then using ALM sync with Test & Prod. Will it get updated in Test & Prod?
How Can I Automatically Identify and Delete Childless Hierarchy Items?
Hello, I have a constantly shifting hierarchy in place which consists of 8 levels, level 1 (top) through level 8 (bottom). Within this hierarchy it's necessary to delete members of L7 when they have no L8 members which roll up to them. This scenario plays out regularly as L8 members are often realigned to roll up under…
Import in a list. Fileds mapping - need empty mapping selector in a drop down
Hello I've noticed one thing which is not native for many beginner anaplanners. While we set-up import to the numbered list and we should not have any mapping in the name field (as we choose to use a code as a default way to identify items). But quite often it is pre-populated and in a drop-down there is no option for a…
Vidéo - Les différentes méthodes d'intégration de vos données dans Anaplan
Bonjour, Anaplan en tant que plateforme permet de rassembler vos données issues de sources hétérogènes. Cette vidéo est une introduction (non exhaustive), des méthodes possibles pour intégrer vos données dans Anaplan : * Intégration manuelle via un board, * Anaplan Connect, * Rest API, * ETL, * Cloudworks.…
Size of module and models using APIs
Hi All, I need a way to automate capturing the cell size of the modules and overall size of my models. Right now, for modules, I have to capture it one by one in the model itself, but that is not feasible as an administrator considering we have several models and thousands of modules. Is there a way, using APIs or…

Data Integration

Discussion List