Data Integration

Improving the quality of management reports when exported to Excel
The quality of the font on management accounts deteriorates when exported to Excel. It's OK when zoomed in, however just looking at on an A4 page it gets fuzzy. It may be that the resolution is too high?
7.2.3 name and country error
Can someone help with these errors. I have tried several times to fix. I must overlooking something.
Associating a list to a hierarchy
Hi, I created a Cost Centers list with values (1, 2, 3, 4, etc.) and a hierarchy of Business Unit lists (Business Unit 1, Business Unit 2, Business Unit 3). I'm looking for a way to associate each group of cost centers from the Cost Centers list to the Business Unit hierarchy. The hierarchy Business Units 1-3 values…
Export file into email
Hi, I have built a supplier forecast module and created an export into excel with added data from the list used in the module. I would like if I could make this export be divided so each supplier receive an email with their items and forecast Is this possible in any way? Since we have a lot of suppliers we dont want create…
L1 Volume Inputs Module
Hi Everybody , I got stuck while importing/mapping the data into Level 1 - Lesson 8 - REV02 Volume Inputs , I have attached the snap shots of each tab , Please advise the solution . Thank You
Error when importing from 2 other models, one works, the other doesn't
Hi I am importing data to a module from 2 other models. One works perfectly whereas the other import comes back with an error message 'The column headers in the file you are attempting to import do not match the import definition'. The source modules have the same structure apart from there is a numbered list in the source…
L2 1.3.3.2 import error
Hi, Need help on importing country flat list on l2 sprint one .as a flat list we need not to assign any [parent but withot assigning i am unable to import. what will be the correct mapping
Anaplan Connect
Can somebody help me this error. Unable to figure out where is the mistake. Thanks Amrutha
Import Transaction Data to Data Hub Module with Numbered List
Hi, I have created a numbered list module with no item yet (Refer to image 1) When I import the transaction file into the module (image 2), what can I do to auto create item in numbered list (#1, #2, #3, #4)? Thanks
copy between versions - current year to next year
Is there an easier or faster way to copy data from FY21 Forecast version to FY22 plan version without copying it module by module? Also, I need to keep the current FY21 plan intact. so the result on plan version should be FY21 plan + copy of FY22 Forecast. This is a model level change. Lag function doesn't work on version…
CloudWorks—This is how we use it, Part 4: Using CloudWorks APIs with AWS Lambda
In Part 3, we described the procedure for using CloudWorks APIs. But the main question would be, how can we use them? Indeed, we can find that having a dedicated screen in Anaplan itself is already a major step forward. And it surely addresses most of the future needs. Nevertheless, in our strive to open our platform as…
SYS06 Data Import
I'm trying to import data into the SYVS06 module and for some reason there is error with the size list item import. Please help.
L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module
I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.
NUX Customize Load File message
Hi All, in NUX when Users need to load the file, they can see following message: It always says 'select the CSV file'. This is really confusing, because in this case Users are obliged to load Unicode Text file. Although, they always see CSV here. We are not able to edit or customize this message. Using classic dashboard,…
Interface from Vena to Anaplan
Hi I wanted to ask whether Anaplan can import data directly from Vena models or does a bespoke interface need to be developed to move data between Vena and Anaplan. Thanks Kevin
view to view import failing
Hello friends, need your help in nailing down the problem which i am unable to point. * Module test has 2 views..1a and 2b * Module has following dimensions i.e. Model TIME, 2 lists & 2 line items * What I am doing is inputting the view 1a data into 2b view, receiving the below error. Not sure which data is getting…
L2 S2 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX
Hi All, For 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX Module: DEM03 Demand Forecast Saved View Name: Global Assumptions Grid UX * Add a filter to this module to display Months only. * Use Months as the columns and line items as rows. * Display only Baseline Forecast and Initial Demand Forecast line…
How to undo the mapping
Is there an efficient way or do you have a suggested way to undo the mapping? The only way I am doing it is deleting them, but it is becoming more work when there is a long list. Thank you
Setting to ignore elements when imported into a time dimension.
Hello everyone! I constantly face the problem that I described in this topic. The problem is that if, when loading data, you have time in the columns, and the rows have several non-embedded columns (reference for the user, outgoing measurement (and the mapping is done according to an additional LI: code), then at the start…
Anaplan Connect Import Error - Unmatched Delimiter Character Due to Double Quote and Underscore
Dear Community, I observed two causes for the error 1) double quote 2) underscore. My questions are: 1. It seems I do need to use delimiter for my load. Is there a way to clean the data before the load without putting restriction at the user data entry point? 2. why would underscore cause this error Below is a post from…
How to integrate Azure data factory and Anaplan
How can we use Azure data factory REST API Connector to ingest data from Anaplan to Azure blob Storage? Is there any direct solution or links to this?
Importing data into SYS08
How to map Employees data into SYS08 because I am getting error, I am attaching pictures, only current salary n commission % are mapped.
You are not authorised to move item to parent: <X>
The users are having NON Workspace admin access, so when you are trying to run the process, then are facing "You are not authorised to move item to parent: <X>". Any suggestion to resolve this?
Anaplan Connector for Informatica Cloud – Part 3: Imports and Exports
* Informatica Anaplan Connector Standard Practices * Model to Model Imports * Executing a process with multiple import actions * Solution 1 * Solution 2 * API Based Metadata Usage * Scenario * Export Actions in a Process * Exporting Users LIST * Capture ERROR DUMPs * Error Dumps & Processes For a refresher on the…
Anaplan Connector for Informatica Cloud – Part 2: Design Guidelines
If you need a refresher on the Connector, read our Part 1 - Start Here article. What is covered in this article? Standard practices on building integrations using Anaplan Connector for Informatica Cloud (Hyperconnect). What is NOT covered in this article? This article does not cover training on building, executing, and…
.txt file Vs .csv Load
Hi All, Is there any Limitation of number of rows in .txt Load Vs .csv file data Load in Anaplan. I can see the difference in count of record loaded in .txt Vs .csv Delimiter set in .txt file is '|'. Same file when I load to a flat List in Anaplan the record Loaded in 1969 and when I load in .csv format the record loaded…
L2 Sprint 1 1.3.7.4 Create s G3 Location: Distribution Center? List Subset
Hi All, I created this subset. Should I add this as subset for G3 location list Please advise Thanks, Balarama Krishna
Level 1 Importing data into list
* I am in Level 1, where as an 4.8.2 Activity I have to import data from Employees.csv into * E2 Employees# numbered list. But while importing it is showing Invalid parent. Please help. I am attaching picture
Emoji-Text
Guys, I am using Emoji Icons (text-general) formatted to be displayed for my various reports. I have however encountered couple of scenarios where there are inconsistencies. In my board report the pdf export correctly captures the Emoji Icon as is. However while exporting to PDF using Management Report (new Reporting…
Cloudworks - add a "run as" option
As an integration admin, i need to be able to optionnally choose under which user id a process or integration would run with cloudworks. This is necessary as for instance we want an integration admin to set up scheduled process using a system account with a determined access rights perimeter with the help of dca.…

Data Integration

Discussion List