Data Integration

Excel Add-in v3.2 - Boolean values
Hi all, I am having an issue that seems to be a result of the new v3.2 add-in update. Previously, where boolean values were being pulled from the excel add-in, excel would automatically recognise them as general formatting and they would be activated and process the cell as a boolean. Now it seems the values are being…
Export Inquiry
Hi, Hi, I would like to ask if Anaplan has an option to export data in this format? The client requirement is that we can export data in this format so they can load it to another system. I have tried the export definition txt file and it is not the same. Appreciate the assistance Regards,
importing data about time
Hi. When I import data and map. I have to unify the time format(like below) or not?(there are Y-M-D and D-M-Y)
Anaplan Connect 1.4.2 JDBC export: Could not connect to the database
I'm trying to use the new JDBC export in Anaplan Connect 1.4.2, but I get the error "Could not connect to the database. Retrying in x seconds." I'm using a connection string identical to what I use for JDBC imports, so I know that's solid. Additionally, I am using integrated security, and I do have sqljdbc_auth.dll in the…
Informatica Cloud: using Hosted Agent with Anaplan connector
Informatica connectors typically give you the choice between 2 types of runtime options: - one or more secured agent(s) that run(s) on a managed server - a hosted agent managed by Informatica that lives in the cloud The feedback I got from Anaplan was that the Informatica Anaplan connector is only compatible with the…
Insert item to dimension via Excel Add in
Good afternoon all, Iv'e just downloaded the Excel Add in V3.2 . I have managed to create a tab based on the view on my module. The module has my numbered list 'expense' as dimension + several line items. The objective of using the Excel Add in would be to enable the user to manage their expense as well as adding new ones.…
importing duplicate data into list
Hi. I want to import duplicate data into list like below. When I imported, data which is second same data was rejected. How can I do this? projectA (parent)----employee1、employee2 (child) projectB----employee1、employee3
FIND MULTIPLE DELIMITERS
I am trying to take a 3 part Unique ID with delimiters and separate it at the delimiters. I can achieve this for the first 2, but not the last part. ex: 123-0542-236541 LEFT(NAME(ITEM(LIST)), Delimiter in Item Name - 1) = 123 RIGHT(NAME(ITEM(LIST)), Delimiter in Item Name) = 0542 Delimiter in Item Name = FIND("-", Item…
Case Study 299 HR planning costs
So for the HR Planning Costs dashboard there is a module where you can input social security, pay raise % and pay raise date and that module affects the details of each employee module. Is there a way where the social security, pay raise % and pay raise date module does not affect every employee, whereas I can choose which…
Import file with several sheets
Hi, I have a module where I have a number of line items and two lists as dimension. One as rows and one as page selector. I want to build a function to export all data from that module, edit it in excel and then import the same file again, and hence get the values updated in Anaplan. Now to the issue: When the file is…
Import to list with default value
Hi, I have an excel file that needs to be imported into Anaplan and update a list. However, I want all the new list-items to be part of a subset, which I want to set at the same time as I import the list. I do not however have any column in my import file to use for setting the subset (that is, a column that says TRUE to…
Add Search Field
Add a search field when setting up an import source from another Anaplan model. Currently, we have to scroll to look for the desired list, module, or saved view.
conditions in anaplan connect batch file
Hi Team, I am facing following issue regarding Anaplan Connect.How to give the condition in batch script? I am trying to import model to model, parallel with I want to change the version for destination model while performing import action For that I want to apply the condition. I have attach screenshot
File Import Error: No Value Loader exists for this type: NONE
Hi Everyone, I am facing a issue which is: My source is: .csv file Target is: Module (Importing into 8 line items) Line Items: Format Lift% Number Volume Status List formatted Activity Type List formatted Activity Cost Number Display Type Text Display Cost Number $/unit Number Select Scenario Boolean The file format &…
Automatic Mapping - Not Working
The names are not getting mapped automatically, is there an order issue or is there anything else?
Hierarchical structures from a customer provided list
we all understand the traditional way of building a hierarchy normally following a top down approach. We sit with a challenge requiring that the hierarchy needed to build up from the bottom up using a lowest level reference code. As per the attached picture. Each lowest level will have a specific code identifying where it…
Importing boolean from Informatica for List subset
I am trying to populate a subset using an import triggered through Informatica. Here is how the import is set up in Anaplan ("SS PortCo in Hierarchy" is the list subset): Screenshot 1 Now from Informatica standpoint, every record captured by the query needs to be added to the subset so I am using a hard coded expression…
Cannot Install Anaplan Excel Add-In - Misleading Error Message Displayed
Hello, * We are struggling to download the Microsoft Excel Add In - when trying to do so we get the following message:* The Anaplan Excel Add-in requires Microsoft Excel 2016 or 2013 or 2010 (32-bit of 64-bit) to be installed. * This is misleading - the documentation states that Office 365 is supported…
How to convert Date to 445 calendar week
Hi All, The requirement from the client is that they will upload the sales history for an SKU by date into Anaplan. Hence there will be 3 columns SKU, Date, Quantity. The model calendar is set as 445 calendar and the end of fiscal year is last Sunday. The problem is I want to convert this flat upload so that I can…
Building a Data Hub
Hi Anaplan Team I have built a data hub to store all my data in that model and later transfer the same to my main model through anaplan connect. I am facing an issue: Lot of time is taken to load just 1 file of 200 MB in txt format, approx 20 min is taken to load such files and I have multiple files of same size & format…
Hierarchy change
Hi All, Wanted to ask for a best solution of this question if possible. I have a process hierarchy which consists of 3 levels, and I need to extend it by adding 2 more levels between levels 1 and 2 (so whatever is on Level 3 now should go to level 5, and whatever is on Level 2 will be transferred to Level 4). What is the…
Anaplan Connect- export file with different versions
Hi, I'm trying to create an Anaplan connect to export an expense forecast file monthly, but don't know how to write an export script so that every time I run the bat file, it can export the latest version forecast. For example, in Jul, we did a Q3 fcst. I created an export action, the script is: set Operation=-export "the…
Error on Importing a list item
Hi Experts, Could you give me a clarification for this error? There is no detailed explanation for this. What does this error stands for?
Trying to map data to a line item from a list
Hi, I'm creating an upload into a list. I've then created a module that looks back and returns the values from the list. I need to be able to map certain factories to certain line items. So if my factory is 1 then i need the line item to be returns from another module with a certain heading. The reason I can't use a…
More than one value for non-numeric cell
Hello everyone, I am having some trouble with the model i am currently trying to build, i am trying to import, into a module i created, a file containing a table (in an CSV format of course) with two columns : The reference and the description of those references, so i created two line items (reference, and model…
Create a PDF/PPT Template in New UX to allow customers to create dashboards for exports
Let users create specific dashboards for PPT presentations or PDFs. Doesn't need to be a new board/worksheet, just a specific report that generates and export
Import User List into the model in Deployed Status
Being an Anaplan admin, I would to be able to upload User List into the model in Deployed Status following general approach of imports from files (with ability to upload .csv file). Currently, the only way to do it is to check the import in the system as "Production Data", re-upload source file directly in production model…
Anaplan List Import Error - "Property-based hierarchy import has disallowed duplicate properties..."
Hi there, I have spent a significant amount of time now attempting to get a simple import to work between 2 existing lists for the 299 case study. I keep receiving the error "Property-based hierarchy import has disallowed duplicate properties for given key in target data - cannot proceed". I have attached below an image of…
Limitation Lineitem subset source module
Hi Anaplanner, does lineitem subset have limitation for source module ? thanks
Exporting data from modules Excluding header items
Thank you for your help. I would like to remove the header when exporting data from the module. Can you tell me if you would like to set the header item not to be output?

Data Integration

Discussion List