-
Conditional Import
I have two columns, Column A and Column B. Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make the data of Column B not editable using write access driver. However when I run the action to populate column B new list…
-
Import data with a timescale "week"
Hi. I want to import data from a model to another model. Nothing extraordinary. My two models have a timescale “week”.The two modules are in “day”. All the records are rejected with the message:“Invalid date or timescale identifier”. Where is the problem ?
-
Model Map Export
I really appreciate the new Model Map feature. What is the best way to export my entire map to a printable format? My model is rather large and I can't get the view with details out in a usable format.
-
How do I clear out a module for items that are not in an import file
I need to clear out list items that are not in my import file but only for a selected version
-
Speed Up File Import
Is there any way to speed up the time it takes to upload a large file into Anaplan?
-
Exporting CSV from Anaplan, incorrect date displays in Excel
When exporting information into Excel by month it brings the dates through as text, ex “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for…
-
errorwithclearrequeststatuspoll exception?
Getting this while inputting in a value in a column.
-
Update code of a numbered list
Hello, I want to update the code of a numbered list. The user can input a name on the dashboard. Then I want to set up an import to, for example, import the code to the numbered list but it creates me a new item each time, since we cannot map by name in a numbered list. Any solutions to update code in a numbered list…
-
Error on Importing Codes for Line Items
Hi, I already have line items in my module but I forgot to include the codes when I first created those line items. Now, I would like to add their codes through import. However, when I try to import, this is the error: distinct names found for same code - check mapping and/or data. What could be the cause of error and the…
-
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…
-
Subject: Data Import - Replace Unmapped Data with Zero's
I'm importing the budget from a CSV file and 500 was previously entered as a test case in every account in Anaplan. is there a way for my CSV to replace each account, rather than add? For example, if i dont have an account listed, can zero replace the 500 or do i have to replace all the 500's manually?
-
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…
-
Fix ability to use zip files in Cloudworks and UX
While using import actions in UX and Cloudworks I discovered with the help of Anaplan support that zip files cannot be used except through the backend and old UX. We would like to have the possibility for Anaplan to use zip files in UX and Cloudworks as it is indicated in the Planuals best practices. This is required to…
-
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…
-
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…
-
Date Import not working
Hi All, Need some quick help I want to import a date from 1 module to another module using Import action, however I'm error as "Invalid date" Module 1 - 1 line item (date1) | date format> currentperiodstart() Module 2 - 1 line item (date 2) | date format Now, when I'm trying to import date from module 1 into module 2, I'm…
-
creating a new import
How do I create a new import? I have created the Import data source, but now I want to link it to an import. Thanks
-
Export via a Report from App by API or similar tools
Hello, As discussion with support team, I have an idea for the export functionality from Report in an App. Anaplan's native function can be utilized to export a different report (when we change a filter for example) in PDF. Dose there has the method as API to retrieve all the 3 reports from your servers? It is not related…
-
Export Action Error
Hi Team, Any update why an export action for might be giving error in export action? It says Export Successful and Export failed at the very same time with file not being downloaded. However, for others its working fine. Thanks in advance!
-
I am struggling with my mapping and import of E2 Employee List
Hello Model Builders! I need your help in Model Building. I have tried over 10 times to import data into E2 Employees# under Lesson 4.8.2. I have spoken to some colleagues on my team and the we were unable to resolve this issue. If anyone could assist please share a solution or trick to this. I noticed other colleagues had…
-
Clowdworks integration failed because of the server error
Your integration failed because of a server error. Check your integration setup and try again. Hi! I got this error when trying to schedule the import action from one model to another. I have full access role and WS admin role for both models. So what could be the problem? Thanks for your help in advance, Anastasia
-
Bulk Copy functionality available from Dashboards for non-model builders
As a Model Builder, I want to be able to create specific/dynamic Bulk copy processes so that end users can run them via dashboards. I'll know this is successful when I'm able to publish on dashboards specific bulk copy processes using the standards Anaplan out of the box functionality and without the need of creating…
-
getting Error while importing a large file which was successfully uploaded few days ago.
Hi Anaplanners, I am getting error while running a import action by uploading a large size file. The same file was successfully uploaded with the same action 3 weeks ago. I have tried all the ways:- tried after by clearing cache and cookies tried to make new import action with the same file. restarted my system and…
-
Show process Id into actions window
it's would be useful to display process Id into actions window (in a dedicated column)
-
Transactional APIs - Part 2: Use Cases
Introduction Following use cases will be presented in this section: How to retrieve id for a given dimension/list & list member from its name or code How to retrieve allocated & consumed space for a Workspace & Model Workspace Sizing Use case Model Memory Usage Use case How to retrieve permitted number of Items & Index…
-
Data in List Properties Clearing Mysteriously
Has anyone ever had mysterious issues with a very large set of Model to Model actions in one big process? We have issue where data is being cleared out of list properties and it's totally mysterious as to why (have double checked 100 things, all the imports, the data sources, the saved views etc. there is literally nothing…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file
When i am trying for 2.3.9.1 getting error as "Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file map to the correct dimensions in your module, then run the import again."
-
Remove 10 million item limit from the ISFIRSTOCCURRENCE function
Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.
-
L3 Sprint 2 building the list: G4 Territory > Account#
Hi Community, I started L3 wherein we have to build G4 Territory > Account# list in Sales Planning model I followed below steps as per training Firstly, loaded the Download: Territory Data.csv into Data Hub model into Territory Flat List system and built system module below is the image attached of both list and sys module…