Data Integration

Decimal points dropping off amounts when uploading data file
I am uploading a .csv file with amounts that have dollars and cents. Whether the columns in my module are set to use decimal places or not, it is not recognizing the cents. 1633.34 shows up like 163334 when no decimal places are formatted and 163334.00 when I use 2 decimal places. Is there a way to see the amounts in the…
Actions in new UX
Hi Friends, I have actions and process created in old dashboard. I want to bring that in the new UX. I am trying to assign cards with Process but it is not getting saved. Any suggestions, will be of real help.
Number of users in a workspace
What is the limit on number of users in a workspace?
Q & A
Will Q&A sessions always be on Fridays at noon or will this vary throughout the week?
Allow tabs to be scrolled
Basically what the subject implies. Would be great to scroll between tabs in the UI using the scroll wheel (similar to google sheets).
VBA code to execute Excel Add-in toolbar commands
Hi, I am a new Anaplan user and am looking at using the Excel Add-in 3.0 to retrieve data into my excel-based reports. My preference is to automate report formatting and retrieves from Anaplan using VBA. Does anyone know if there are published Anaplan VBA commands like exist for Essbase? Thanks!
When missing code / unique identifier in transactual data (general ledger) for list dimension
Hi, What is the best way of treating a general ledger, in other words a big data transaction file, that is required to be in the data hub and is missing a unique identifier for each row, i.e. something to be used as a code for the list that will act as the dimension for the DATA module? I could create my own code in the…
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

Data Integration

Discussion List