Data Integration

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.
Cloudworks Integration not able to see API files
Hi Team, Our client has decided to use webMethods for their Anaplan integration. When webMethods sends a file through the an Anaplan integration user, the file is set to private and we do not have the ability to change the file to admin or everyone through the API or on the integration user on Actions - Import Data…
Retrieve Line Item Formula from Anaplan with Python VS Code
Community, I have been able to connect Python/VS Code to my Anaplan model. The information I am trying to retrieve is the formulas in each line item. This will help make it more readable. Does anyone have a python code example to get this data from an Anaplan model?
Level 3 Distribution Center Parameters
Here is my DATA HUB modelDistribution center parameters: Here is my target in the supply chain model Here is my import window mapping: My time mapping seems to be correct: Looks like no issue with p3 SKU, and here is my line items: But my import still fails: I tried doing the manual mapping, that seems not helpful too. I…
data import
how to import data from one module to another module when dimensions are not match.
Process not running correctly
Hi, currently have a process that is supposed to take data from one module and put it into another. But currently the process is not working. Screen shots of error are below. Thank you
Populating Numbered List from a Module with 4 or more dimensions:
Use Case: I am trying to create a Numbered List from a module with 4 dimensions typically SKU, Tier, Product and Level & few Line items. For modules dimensioned by 3 lists it is straightforward to create a View as the source of the Import with the 3 lists as Column items and the Line Items as Row items. Unfortunately this…
L2 conclusion INV05 export - import is wrong
Hello. Please help me for settings of exports. I've changed many variants, but it still wrong. The pivot Filter - Months Only Summarize - none I try to export grid or table, but it gives mistake for import. Please, help me for solve.
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, If I run the process "Import Data from Hub" in the Supply Chain Model , I get the notification below. Anyone who can help to solve this error?
Power point Add-In VS. Management Reporting
Hi Everyone! I have a question in regards to Power point Add-In VS. Management Reporting? For example If people would like to switch from PP to Management Reporting, are they going to have any struggles in regards to functionality etc. Does Power Point is fully replaceable right now? What one of it has that another…
Selective slide exporting from Management Reports
It would be great to be able to select specific slides to export when export management reports to PDF. Currently the system automatically exports all slides and you can't deselect any if you don't want to include them in the report pack.
Integration with SMFT protocol URL.
Hi Ananplanners, Would like to know if any one of you have experience working on Anaplan -Web transfer(SMFT URL) integration.? If yes. Could you Pls. share the integration process ? Thanks in Advance. ~Abhi
Custom Module Views in Powerpoint Add-In
The Powerpoint add-in does not allow users to create custom module views. This is essential for user adoption of the add-in, especially when a referenced model utilizes ALM (Dev/Prod). In its current state, the Powerpoint add-in relies on saved views from a model. This is fine when the underlying model is in Standard mode,…
Level 2 Final E[am
Good afternoon Please help me figure it out: in the final exam of Level 2 on the Numbered List question, I can not answer correctly in any way, and I think that maybe it was a problem with the Internet, so the correct answer could not be counted by the system. To clarify: I am worried that due to a technical failure, the…
SCIM APIs: A Use Case to enhance your Central Identity Management (CIM) Process
Need a refresher on SCIM? Read our [Start Here] article! What is User Provisioning? Let's start with a reminder; User Provisioning is a process by which an individual is granted access to the Anaplan platform and assigned the model role that allows them to interact with the information that they are authorized to use. We…
Model Builder 3 Training 5.5.1 Data Hub Model
Hi All! I am working on Model Builder 3 and am on step 5.5.1 which says: "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data Hub module". In my starter model, there is already a SYS09 Employee Details module with all of the information…
Changing source file name
Hello Community! I´ve been working with Anaplan for several years now and whenever I´ve needed to change the import file for an import action I´ve just created the action again using the new file. This usually isn´t a problem so I haven´t given it a second thought but what if you had 15 actions that are included in several…
Moscow TimeZone for Cloudworks
As an Integration Admin, I need to schedule an action in Cloudworks for Moscow TimeZone (UTC +03:00) to run actions in the proper time.
Filtering by Users when Imporing
Hi, I want build a system several End Users can make the master data at the same time. The point is EndUsers do it at the same time. So I made a module which has Users as Applies To. And EndUsers have to import this module to List. But I could not filter by Users. So data which another User made was imported at the same…

Data Integration

Discussion List