Data Integration

Building a Chat Bot - Part 1: using GCP
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Using Anaplan APIs on GCP * Authentication * Secret Manager * Create a Google Cloud Function * Examining the code * Best Practice: Information encryption * In summary What is covered in this article?…
Manage the CloudWorks Internal User's List Access via the Users List
When using CloudWorks, you must go into each individual list that has Selective Access and grant the CloudWorks Internal User the relevant permissions. It would be much easier to manage the Internal User's access if it appeared in the Users list. This would allow us to adjust its access in the same way we already adjust…
Exporting multiple modules using API takes too much time
Hello Community, I'm trying to export multiple modules (7 modules) using the API. but it takes up to 4 hours to do that. The size of the biggest module is about 600Mo. My questions are the following : Is there way to do a full export of the Anaplan modules (like creating a dump) ? Is there some possibilities to accelerate…
2.3.9.1 Import data into DAT03 Historic Volumes module issue
When I click run I get this error message. I checked to ensure that everything was still there on the import history and its there. Model object "'DAT03 Historic Volumes'.Export" could not be located
Excel Add-In Options for Export of Data
While the Excel Add-In has seen significant improvements in both functionality and performance in recent months, it would be useful if a user could have the option to treat the data more of an "Export" and less as a "Pivot" - I am trying to essentially accomplish the below - but through functionality I would expect from…
Importing data via model connection
Hi I have a request fromme and a customer:: * When importing data via Anaplan model, can a find diologue box be available to search for models/data (instead of using ctrl F) and can a preview of the data eg view be imported; be provided to show the data source prior to confirming the import?
Be able to execute an action as admin
It would be useful to define some action to be executed with "admin priviledges". For example to clear, with an action, some DCA dependent line items that are no longer writable.
2.3.10 activity
I need help, I’ve been on this section for a couple of days and can’t seem to figure out why my data is not populating. My formulas are correct but I’m not understanding.
1.3.4.2 Update SYS06 Country Details Module
I am having a hard tie with importing the data into this module. I keep getting an error message. I am mapping column 1 country code>country flat, and column headers>sys06 country details line items. Please advise as to what I am doing wrong.
import shows failure but data is updated - import with subsidiary line items
Hi Anaplan community, As part of preparing my model for next year's use, I have created clearing modules with line items formatted as "No Data" to import into my original module to clear that from any user input. One module which I need to clear has line items with subsidiary views, using a subset of the list which I use…
Task scheduler issue in Anaplan Connect.
Hi Community, I would like to ask something about the Anaplan Connect. So in our client model, we created a Anaplan connect to update the current date on the model. This is used for period locking. The date will be used to lock certain period so admin can control the date range of when the users can only enter values to…
Level 2 Sprint 1 - (1.3..4.3)
Hey everyone, I am having trouble completing this activity 1.3..4.3 (L2 sprint 1) I am not able to import successfully, below are the screenshots attached
Level 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module Error
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 When running the Import it state that the process is completed but show one error, Which is pertaining to the 9.1 Import Historic Volumes. (Invalid line item identifier: Weekly Safety Stock)…
1.5.3 Activity: Create Saved View for Export - DAT01 Beginning Inventory
Hello, I am having trouble importing the beginning inventory in DAT01. While it's showing that everything was mapped correctly, All of the fields are not populating with the inventory amounts. I repopulated my "s location flat distribution centers?" tab and the information is still not loading. Please advise.
Cloudworks failures
I have a process to load lists and modules in my datahub which uses the cloudworks azure connection. Everything was working correctly up until 18th October, then yesterday the process failed via the schedule and failed on manual runs from the cloudworks integrations screen. The Job fails with Process Validation Failed…
2.3.10 Activity: Create Demand Forecast
As per the below activity information provided, do we need to write the formulas for all the line items in the module or need to write the formula for only Growth Rate % line item? Can anyone provide clarity on this activity for me?
Using Saved Exports as Import Data Sources
I suggest implementing a feature where we can use Saved Export Definitions as Import Data Sources. Right now we can use a File or Connect to Anaplan Model - I would love to be able to select Saved Export Definitions in addition to current option of Lists, Modules and Saved Views. The natural place for this, in my opinion,…
AWS S3 Bucket Unique Identifiers
Is using the combination of properties function standard practice, when importing AWS data via Cloudworks or is getting a unique identifier added many times better? Currently the csv has no unique ID but I will push for one from my AWS admin if any examples can be mentioned. Its an AWS Detailed Billing Report with c14m…
Use setting grids as a model Import Dat Source
There are certain fields in the settings tables of a model that would be very useful to be able to easily import into a module for further calculation/model usability. The uses I have already encountered would be: * The 'user settings' table - this would allow filters and dynamic cell access more easily based on role, or…
DATA02 SKU: Invalid Parent Error Message
When importing the sku information, I am unable to locate the correct parent and it is throwing off my import for my model. Has anyone experienced this message? Also is there a guide on what chocolates, sours, etc there are? I have never seen the "Thats a Fine Howdy Do!" Product line
Errors while running new actions in a process
I keep getting a "size details" error when running new actions in the Load Products process. I must have removed some information by accident. The sizes are still showing in the flat list so Im unsure how to correct this error. Please advise. (see error attached)
1.4.3 Activity: Create System Module: Product not importing in the correct column
Hello! Im wondering if someone can help me with this matter. I am trying to import the SKU list in this model but the product are not importing in the correct column. (see screenshoots attached) Everything else appears to have imported correctly. Please assist.
Level 2-Sprint 2 Import Historic data Action
Hi, I'm working on sprint 2, my model has successfully run action 9.1. the issue is that it's ignoring most of the data. Can you tell me if this is ok or should I modify something on the action import source Also attached is my Import structure Best!
Activity Record of List Members
Currently there is no ability to see a detailed record of the list members created after running an import into a list - you can only see that X number of members have been created or updated. Additionally, there is no record of the DateTime that list members were created. Including a Created Date and Time (UTC) column and…
Sort Lists greater than 1 million items
Order Lists is extremely helpful (https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html) but we have a couple key lists that are over 1 million items, so Order Lists does not work for them. We are looking at around 11 million items for current year and prior year data. We have…
Actions tab -> Imports Tab -> Can we have the ability to export this data into an excel file?
Or can there be a way to combine the data on the Actions tabs with the Imports tabs to pull an entire listing of my Imports and Processes? I am constantly copying and pasting data from the Imports tab into an excel file so I can filter and find the necessary imports and where they come from. Especially after…
Required Account Flat csv,Depart ment csv,
Hi, i was preparing level2 to sprint1 ne but unable to find the account csv ,department csv etc.
Invalid Parent Error
I keep getting an invalid parent error and then manually having to select the parent after importing. I now have a list with 400 that have to be mapped to the parent manually. I'm not understanding why this is happening and how to fix it. For context I am duplicating a list from 1 model into another and have set up the new…
3.3.5.2 Inventory Ordering Module Formulas Shipping Method & shipping time weeks is not showing up
I am having trouble checking my formulas. My Shipping Method & shipping time weeks is not showing up and I think it is because in the SYS 08 SKU Details the distribution center is not showing up. It is showing up in the list but not in a line item? Why is that happening?
Action disable dialog box for Run and for Close if no other end user action is needed
Use Case: Today when an user hits the Action Button, the user always gets a dialog box, need to push Run and after the process ends, a dialog box is asking to hit the button Close. In this example no other action is required by the end user (no file selection, no item selection) and for the end user the steps Run and Close…

Data Integration

Discussion List