Data Integration

Restrict Users who can Run Action
Hi, I want to restrict users who can run import Action. There is Role function in Anaplan, and it can restrict users. But I think the master management of Role function is too difficult, because Role function has another Modules and Lists roles. It is set None as default. So I should set modules and Lists Roles. I want to…
Trying to filter by a Yearvalue with a nested Lookup to pull list parent
I have a module that we export data from using two system type modules that allow a user to filter their export by version and by year (time) using boolean selection boxes (checkboxes). I want to add the ability to filter by a third category, Division. The way the module is currently filtering the data in the export action…
Historic Volumes data
Hi Can anyone reply to the below I am also facing same issue with time scale the Hint says NOTE: The Historic Volumes data includes the ACTUAL sales volume of product SKU from FY19. The Supply Chain model's Model Calendar begins in 2020 and does not include any previous years. If you run the Import Process as-is, you will…
Date Format Issue when exporting from Anaplan to BigQuery with CloudWorks
Anaplan is using an unique date format “1 Jan 22” and “Jan 22” as opposed to “2022-01-01” and “2022-01”, which are common in data science. Therefore, when exporting data from Anaplan to BigQuery through CloudWorks, the date column needs to be formatted as string, because BigQuery can’t read “1 Jan 22” as a date. There are…
Maxmise compatibility for exports containing dates and periods
Anaplan is using a unique date format “1 Jan 22” and “Jan 22” as opposed to “2022-01-01” and “2022-01”, which are more common in data science. When Anaplan data containing dates and periods (e.g. the daily traffic per shop) is exported to another system (in this example I use Google BigQuery with the CloudWorks Connector),…
Importing Data issue
Hi, After importing data, it says 'Success!' However, I can not see any data in my module. Please check the attached screenshots and guide me! Mark
Process Failure with CloudWorks
Hi, I am trying to automate a model to model import with cloudworks, the process fails and I am observing some strange behaviour 1. The same process runs for dev model but fails for prod model. Both models are in sync. While running the process manually, it completes successfully in both models. 2. My process has 4 actions…
export data (create export action) with data separator as pipe delimited
Hi Experts, I got a requirement to export data as .csv with data separator as pipe (|) delimited. Please help me how to create an export action in Anaplan as data separator as pipe delimited. Thanks in advance. Regards, Anil
Clarity with Anaplan API
Hi, We are trying to make a custom API call for running an Import in Anaplan using a connector that calls the custom API. When we try to look at the URL used for the API call , it starts as ''https://api.anaplan.com/2/0/workspaces/' -> I could conclude that 2/0 here means version 2.0, but this keep running into…
[HELP] The most efficient way to create a numbered list and import parameters
Good afternoon, I have the following question. From a stagging module I have to create a numbered list. In the stagging module I have several parameters of the target list that should be imported to a system module. What would be more efficient? a) A single view that includes code, display name and parent of the target…
Conditional Boolean: True if an item in Source Module belongs to an intersection in another module
Hi Community! I would like to create a boolean that is TRUE when an item with List format in the source module A currently has an "active intersection" in another module B. So for example, I have a list of Accounts. These accounts have a correspondent Activity related to it (specified in the module B) . I also have a…
Will the Action work fine after renaming the list involved?
Has anyone faced this issues? Scenario: I have a list named "List A" and Source module "X" and "Y". Process followed: 1. I created an action "AC01" to import data from "X" to "Y" in Dev model. 2. Synced this action to test model. 3. If I run "AC01", it works fine. 4. Later remaned "List A" to "List B" in Dev model and…
7.2.3 Activity: Import Data into Employee Details Module
I could not do the mapping correctly. I can not see all the required columns. Could you please help me to understand what I did wrong? Thank you!
Ability to attach an export to email notification and send it to non-Anaplan users
Hi there, It would be good to have an option to send a notification to non-Anaplan users and add an export file to the email notification. So, this will give a flexibility to the end user to inform non-Anaplan user while staying in Anaplan. Thanks, Humay Kh.
Action/Process Run History
There currently isn’t a way to find out when an action or a process was last run. There is also not a way to see when the last time that a file was uploaded. We would like to Anaplan to capture the last time each one of these actions, processes, or data uploads occurred.
Looking for an "action log"
Hello, I want to ask, Is there an "action log" within Anaplan? Similar to History, but which tracks actions. It's important to be able to track when an action ran and its results. For example with import jobs, we need to know when & who they ran, if they failed, error messages, entities added, updated, etc. Thank you
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
How to Dimension ID and Item ID ?
Hi Team , I'm trying to get Subsidiary module data in a CSV using below API. How to get Dimension ID and Item ID API Used : curl -X GET 'https://api.anaplan.com/2/0/models/{modelId}/views/{viewId}/data?pages=dimensionId:itemId&format=v1&exportType={TABULAR_SINGLE_COLUMN}&moduleId={moduleId}' \ -H 'Authorization:…
L1MB 8.5.2 Import Data into Price Book Module
I'm importing data in activity 8.5.2 in Level 1 Model Building, but the results shows different numbers than expected. My models shows: It should be: It seems like my data import doesn't recognice the right decimals of the numbers that were imported. Anyone having the same issue? How to solve this? The steps I followed…
"Error" message using Import to clear user input date data
Hello, Community In a daily replenishment planning model I've recently deployed for a customer, everyday, the planners may need to manually override below line items (format in brackets): ADS Values (number) ADS % Changes (%number) Cancel Order? (boolean) Manual Order Input (number) Override Delivery Date (date) Hence, I…
When builders update action triggered from CloudWorks, don't require CloudWorks rebuild
Input from customer implementation team which uses CloudWorks to trigger Anaplan actions. "When we want to edit or change an Anaplan action that is embedded in a CloudWorks process, we risk breaking the process and requiring a rebuild. Our processes are large by necessity. We frequently update actions/process in the…
11.3.4 Add formulas to profit & loss report module
Hi Community ! I keep getting an error on this last formula ... How can i fix this ?
Ability to connect Data outside of Anaplan
We have a Data Warehouse that we use as a central source for our corporate data. We want to allow PlanIQ to leverage this and facilitate a full integration of our ecosystem’s data with Anaplan.
Copy from one list member to another
I have an Input module by List:A,B,C,D The user wants to make the input for member A and copy them to all the other list members B,C and D so they don't have to make the i/ps multiple times. How can I do this ? If I have an import action then can I map 1 to many for the List?
How to automate the mapping of the Import data to the current version?Current Version is Dynamic.
Hi Everyone I have a module dimensioned by 2 lists, where one of the lists is Versions #. The versions # list is not the default one that is present in Anaplan, but it is created by us according to our requirements. The end user will select the current version from the list of items available in the Versions # list. Now I…
Part 8: Import data into REV02 Volume Inputs modulePage
Hello Group, I got lost in trying to import Volume+inputs.csv into my Rev02 Module. In the attached screenshot what should map into "REV02 Volume Inputs Line Items (Volume)". Thank you very much in advance. Jayan
Make all API's available across tenants.
Currently most API calls only work within the default tenant. As a developer this limits the ability to work with other projects. For all api calls add /customerid/xxxxx-xx-xx-x-x/ to the path to reference another tenant. If tenant id is not supplied then default to the users default tenant. example: When listing…
500 Internal Server Error occurs with requests made with API V2.
To export data from the View, a request is made with an API call to download all pages. The View has a lot of data, so the number of pages will be about 100~3000. I am using Azure pipeline to download one page at a time, but when I finished downloading about 120 pages in 50 minutes, I got a 500 HTTP Internal Server Error.…
Batch Emails with Content in an Attachment
Hi Community, My team and I are looking for any ideas on meeting the following use-case: A client would like to have as part of their Workforce Planning functionality, the ability to have Anaplan send out automated emails to individual employees detailing that employee's compensation details (yearly raise/salary/bonus…

Data Integration

Discussion List