Data Integration

Headers in export files
When Exporting files from Anaplan I would like the possibility to remove the list name from the header when adding properties properties in the export file. Today I can only choose Include or exclude Row Label headers. I would like to have the possibility to exclude the name of the list in the header. From above export I…
4.8.2
I've been having an issue with locating my error in the model for the Parent Error I keep getting everything is mapped out correctly and I've literally lost 2 days trying to figure this out it's not because of lack of effort. But now I fear I won't have my lessons done in time to stay on pace to finish. I really need some…
Excel Add-In not working with latest version of Excel
Our users are unable to use the Excel Add-In with the latest version of Excel. After logging in, all options are grayed out. Is anyone else experiencing this issue? This is also using the latest version of the add-in:
Retrieve more than 1000000 cells using anaplan API
Hi Everybody, I am trying to automate some task by retrieving data from Anaplan using the Anaplan API. Seems like the maximum of cells we can retrieve using the API is 1000000 cells. Since I have a lot of models that have more than 1000000 cells, I am wondering if there is a way to get the data by chunk or any other way.…
Level 3 Sprint 1 2.2 importing Baseline Financial Forecast Data
Hi all, I know that there is a ground rule saying that level 3 model building should be and only be done personally, but I thought asking some help on import error could probably slip through this rule. I'm getting some error when importing the CSV file < Baseline Financial Forecast.CSV> provided by the course, error…
Translation of time list for views and exports
Recently I've been working on an implementation of Anaplan to a non-english speaking customer (portuguese in my case). As part of that journey I was very pleased with the fact that in the data imports Anaplan can translate time from different excel languages into the standard time list - in other words months in Excel…
Deprecation of Excel Add-in Series 3
Hi, Is there a deprecation date for Series 3 of Excel Add-in? Thanks, Alvin
[Start Here] SCIM - The Basics
Are you using Central Identity Management (CIM) and want to connect Anaplan directly to your Identity Management System (IDMS)? Are you facing challenges with a Security audit? Would you like to add Anaplan to your corporate User Provisioning process? If any of the above questions describe even a part of your Anaplan…
Data Integration
Suppose any clients wants our view to automate integration .Which platform is good to start like mulesoft,dell bhoomi ,informatica or any ETL tools or REST API. Please suggest some pre-requisites or some basic question/information which we can ask to the clients.
Current Day
Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would like the logic behind the formula to be something like this: IF the date (from the column) is prior to the date (current day)…
L2 Conclusion Import Currency Error
I am trying to import Currency List but somehow it doesn't work.I am stuck at this activity. I am also attaching the screenshots of Error. Don't know whether its a mapping issue or something. Also I tried mapping via Name or Code but still it doesn't work.
Default Export Excel Format
Hi, I am keen to have the default export to excel option changed to the xlsx version rather than the 1997-2003 xls format. While I know you can change this when exporting it would make sense to have the newer version as the default to allow for quicker exporting. Surely 99% of users would prefer it in this format ? I…
Level 2 Conclusion Issue on Importing data DEM04 to DAT02
Hi Anaplan Community, I am facing an importing problem. Although I think I'm doing everything as it should, I get an error message every time. I have attached all the pictures and it can be seen that I must be doing something wrong with time mapping. But I couldn`t make it. I really appriciate your help. Thanks in advance.…
Excel Add-in v4.x
Hi, Prior to v4, the was an update.exe file that automatically asks whether you want to upgrade to a new version. Can I confirm that this is no longer in v4 series as the upgrade is via the Anaplan ribbon? Thanks, Alvin
Level 2 Sprint1 1.3.10.3 Import Data into G3 Location List
The expected result is : But the result I got is as below : Can anyone please help me why my result is not as expected exactly? Do I need to delete the rows I have highlighted to get as expected result?
Import and export data treasure hunt
We're restructuring the Import and export data section of Anapedia, and we'd like to find out if our new structure is intuitive. Try our imports and exports treasure hunt and see what you can find! The exercise finishes today, but if you have a spare 5 to 10 minutes, why not have a go?
Level 2: Conclusion Create Inventory Ordering Saved View and Export
For creating the export and saved view for Inventory Ordering, my beginning inventory is different from the data given by Anaplan to check. This is due to the data imported while attempting my Sprint 3 exam to update Submit Purchase Order Request? So shall I delete the data imported to match it to the exported data? Kindly…
Level 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module
Hello there, I came across one error when I deal with activity 2.3.9.1 Import data into DAT03 Historic Volumes module at level 2 ( refer to Process failed error.PNG). I have made sure that Actions -> Import Data Sources is correct and updated ( refer to Export.PNG). I have also verified the Source Model ( Source…
Hiding or removing the line item (on the 1st line) of an export from a module
I am performing an export from a module and the user of my export wants to have the extract so that the line item name is not appearing at the top. The line item is sitting on the "pages" dimension on the "pivot" view. In the layout tab, I have it set to: Grid Current Page Omit Summary Items Omit Empty Rows However in the…
Anaplan Connect - Could not load the privateKey for authentication.
Hi all, I'm trying to connect to Anaplan through Anaplan Connect tool using a Sectigo Certificate. I'm able to connect using an hard coded credentials (user:pass) but when trying to connect via Certificate I'm facing the error below. Note: I have received an "user.crt" file from Sectigo on which I ran the following openssl…
Cloudworks export date format timestamp
I would like to have the possibility to define the date format for exports to cloud storages. When you currently export files through Cloudworks you have the choice to tick/untick the overwrite file option. If overwrite is unticked Anaplan adds a timestamp in a worse machine reading format (e.g. <action…
Power BI Connector - Tenant Admin by default
Dear Anaplan community, I need to create some reports using Power BI Connector but it displays only Workspaces on my Tenant by default. Do you know if I can access my other Tenants' workspaces? Thanks in advance, Romain COLIN
how to split a line item in one module into multiple line items in another module
hi Need a help. I am very new (few months) to Anaplan. I got a simple requirement, have to create a new Export module(REP01) from OUT01 module ND Each row in OUT01 will form two rows in REP01. How could I achieve this. Please help. Thanks Module: OUT01 Module: REP01 Regards Balu
level 1 exam activity 4
@Misbah Hi, Can you help me on this? I have imported data correctly and formulas also not giving error but I cannot see data in EMP02 module under bonus, car cost, medical costs and phone costs. Hoping to get response at earliest.
Excel add-in Russian Localisation
As an end user I would like the Excel add-in to support and be localised in Russian.
Level 1 - 7.2.3 - Issue in mapping a numbered list
Hi, I am trying to map the E2 Employees# using source of code as it is a numbered list. However, still it is not displaying the employee names.
Import List from List
In all the model building exercises, we are importing list items from module, rather than importing list items directly from the hierarchy lists. Any particular reason for that ?
Snowflake Connect Null Pointer Error
Hi, I have setup JDBC properties file, and a batch file to run Anaplan connect. However i get Null Pointer errors, which are quite useless as they do not tell you where the issue is. Please can anyone point me the right way? My jdbc snowflake properties file is as follows jdbc❄️//…
2.3.9.1 Import data into DAT03 Historic Volumes module - 9.3 Import Shipping Metrics
I am having issues with 9.3 Import Shipping Metrics. I'm not seeing why I keep getting this error. Please see attached.
Cloudworks configure job to run as another account <Service account>
It would be nice to configure Cloudworks integration to run as "user/account" <Service account> instead of using the current account when you create/configure an integration.

Data Integration

Discussion List