-
Import error (parent item has a child item that is in a different list)
Hi all, I'm getting the following error in one of my import: Import into Hub_0_Product_Group Marketing L8 # list failed: Parent item has a child item that is in a different list: You can only add a child to a parent item, if any existing children of that parent item belong to the same list. Do you have any tip/advice to…
-
7.2.3 Activity: Import Data into Employee Details Module error
Hi team, Missing out some step data while mapping, data was updated successfully attached screenshot (12error), however data is being uploaded with ignored values. Do I have to make any change in the module section? @noelle_murphy
-
Allow filtering of tabular multi column exports from transactional api
When defining tabular multi column (TABULAR_MULTI_COLUMN) exports from the UI, you're allowed to specify a boolean line item to filter the results. This functionality is not built out within the transactional API. The API documentation alludes to this option being the case, but it is not supported. Without this filter you…
-
Mapping timescale during import and ignoring some columns
Hi I would like to know how do I ignore several columns from the source CSV file while importing data , where the first columns contains list and apart from several columns I want to ignore, Column headers are mapped to time. Attaching screen shots for your reference. In the source file attached , the first column simply…
-
Problem of inporting a List from Model to an other
Hello Anaplan Community, I want to import the same list from a model 1 to model B but I have this message that pops up every time. Can you tell me the reason behind this ? Thanks in advance !
-
Text format validation
I would like validation functionality for text formats in Anaplan. When entering names of products or items in Anaplan and importing them into external systems, import errors occur if the input contains strings that the external system cannot import. Having text input validation functionality in Anaplan would facilitate…
-
Clear an entire module
Scenario: If I am importing data into a module and a line item no longer exists in the source file, the Clear Before Import will not clear that line item as it will only clear line items that are coming in from the file. This can lead to numbers being off. Current workaround: Create a duplicate module that is filled with…
-
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
-
Import Scripts run successfully but target module did not update as expected
Hi, We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected. It seems like it is still importing the old csv file instead of the new one. Also, we…
-
Set one column of source data as "Not Applicable" for this import
Dear Anaplan Community I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module. Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type…
-
Is it possible to have an anaplan export automated having 2 dimensions in columns?
I am trying to create an automated export of a view that has time, as well as line items in columns. I have tried this via Cloudworks and Informatica but it is not working. When I am manually running an export in anaplan its working fine but not via integration.
-
Level 1 Exam - Model Building Activity 4 importing data into SYS08 Employee Details Module
Hi Team, I need your help on this data importing. I have downloaded the Employe Details by Role.txt file but, I see the data is not being mapped correctly into the SYS08 Employee details module. Downloaded CSV format : I have tried by converting CSV to txt format. Still the data is not being mapped properly while…
-
Issues with CloudWorks Integration
we have been facing issues with CloudWorks integrations from couple of days. Below are some of the observations: When a integration runs on CloudWorks on one of the model, the whole workspace gets stuck. Integrations are failing with no error logs. Getting notifications about the integrations failing but those actully…
-
Anaplan API 2.0 Python Library - [Updated March 2022]
* Getting Started * Gathering the Necessary Information * Authentication * Getting Anaplan Resource Information * Uploads * Executing Actions * Downloading a File * Get Available Workspaces and Models * Example Code After a significant amount of refactoring, I'm very pleased to announce the latest release of my Python…
-
Import Issues
Hi All, I'm currently facing two issues related to import. I have one module (split in three tables in UX) in which the user imports data. Here's the module: The import action works perfectly well for me but not for them. Apparently, the system is considering the comas as decimal separator while they consider it as…
-
Power BI Enhancements/Limitations
The following will be primarily based on my recent experiences with the Power BI Connector and Anaplan. Positives: 1. The Authentication has much improved and the use of SSO relieves a lot of data concerns when creating Power BI Reports. 2. Able to run multiple exports into the same model Negatives: In my experience and…
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
Current Page Filter of Export Action
My customer has 18 projects to manage with Anaplan. I created an export action with "all pages" settings for my customers' backup purposes. One excel sheet, one project. Because it's difficult to save all past data in Anaplan, they need an export button to download all necessary data. Even though each 18 project needs to…
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
How to retrieve the mapping information of import action ?
Hello everyone, I have a task to check in all my import files, which columns are used (that is to say, mapped to a Linitem in Anaplan), which are not. To do so, I need have mapping information for the import actions (all at least which columns are mapped), any idea to do this? Many thanks !
-
Anaplan error - Error parsing key for this row; invalid data: , , ,
Hi All, When I am importing a file to a list I am getting an error as "Error parsing key for this row; invalid data: , , ," even though there is data in all the columns. Its a transaction data set that I am trying to import into a list with list properties using a combination of columns as unique identifiers. It shows…
-
Source Object Name refresh in Import Data Sources tab of Actions (Model Settings)
The Source Object Name in the Import Data Sources tab of the Actions section in Model Settings is a very helpful piece of information when tracing source module views used in Actions. Model builders normally export this information to an Excel output and filter on the source object name to check which actions are dependant…
-
Too many cells for ISFIRSTOCCURRENCE calculation
I Import a C11 list to 2 spoke models from Hub. I use the same DataHub and Same Hub Saved view to import into this list. However the import into list is sucessful for one of the spoke model but not the other. The saved view and the import definition is the same for both the spoke model. For one the process is completed…
-
Unlocking High-Efficiency Data Uploads in Anaplan: A Multithreading Approach
In cloud-based business planning, the ability to swiftly and effectively upload large datasets is an important aspect of maintaining up-to-date planning. This post introduces the concept of multithreading to enhance data upload speeds to Anaplan significantly. This approach, however, is specifically tailored for data…
-
Anaplan Connect Export stops writing after 30 minutes.
Hi, I have set up export connection to a SQL database. I have 1 connection that takes longer than 30 min to be completed. I have scheduled this one to run overnight. Each time this export is run, it seems that it's timing out exactly after 30 minutes but without a logged timeout error message. See error log (I scheduled…
-
Adding items to numbered list using Create
I want to achieve this but getting a little bit of a problem: * End User can add an item in a number list by clicking a button. * He can choose Product Family from the drop down (Page Selector). * And after that whatever he wrote in Product Name gets imported to the list under the Product Family Selected. I tried using…
-
Conditional Parameter
Hello, I hope everyone is doing well. I have a query regarding Anaplan. I have several system modules where I have created unique IDs, each with a different length. In the user experience (UX) part, it's the UX user who chooses the name of the file to import. Then, the ID becomes the File Name + ID. For example, if the ID…
-
S4 HANA to Anaplan - Mulesoft Connector Limitations
Hi, reaching out to see if anyone has run into issues when pulling data from S4 HANA / ERPs into a data hub using the Mulesoft connector. The volume of data is initiating a model save in the middle of the execution (per Anaplan support) and that locks up the model. During this lock up, any batches attempting to load during…
-
Tableau to Anaplan integration
Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh
-
Ability to import line item format into blue print view
The ability to import line items format while importing blueprints would be really helpful. Currently, I've set up an automated process to import newly created line items from one module into another module on a daily basis. However, I am still required to check the module frequently for new line items imported in order…