Data Integration

Exporting Worksheet as PDF
I am trying to export a PDF from a worksheet that contains images linked to Box. The images are visible as long as I am logged into Box but the exported PDF doesn't contain those images and gives a message "We can't find that image". This is something unexpected as it was working previously for the same image and now…
Level 1 , Activity 5
I have mapped everything right in level 1 activity 5 , but the medical cost for December 2020 is showing 36,800 and that is not the right answer.Can anyone please help me with , where I am making the mistake .I have attached my mapping here.
Building a Chat Bot - Part 2: using Slack App and Ngrok
In our part 1 (for AWS or for GCP), we set up the foundations to build our grand project: having a chatbot interacting with Anaplan. By getting a new token at will, we will then be able to authenticate to Anaplan as many times as we need. We are still far from our main goal though. So, let’s continue! In today’s series, we…
Import Data into DAT02 Shipping Metrics Module
Hello, Please need your help as not understanding how to import as 1.6.2.1 need help please
Bulk Copy Action - Details
Anaplan has released two major updates to its platform during 6th Nov 2021 release updates. 1. New Action for Bulk Copy 2. Optimizer Updates Here are some of the details around Bulk Copy that I observed. * This Action/Process will work only on Non Production Lists/Structural Lists * This Action/Process can only be run by…
Importing Data at multiple level
Hi, I am trying to build a model which contains 7 different levels of product from the region, country, .., brand, to SKU level. The problem is whenever a user adds an SKU for a perticular city it is also automatically added to every other city and occupies a lot of space. How do I solve the space issue and give users…
Process of Processes
Hi team, I would like the ability to run a "process of processes". Currently I have to maintain multiple processes that often have overlapping steps and it makes maintenance tedious and ripe for human error. Example: Process 1 - Refresh Cost Center Hierarchy Process 2 - Refresh GL Account Hierarchy Process 3 - Refresh…
Contracts missing after importing data
Hi all, hope you can help me. During my last data import to Anaplan, 2 contracts were not imported in. However during the import there's no error annoncement or log saying that these Anaplan has failed to import these 2 contracts. Only when users found out that their contracts are not visible on dashboard that I learnt…
How to Interact With Anaplan Application Lifecycle Management (ALM) APIs?
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Anaplan Setup * Postman Setup * ALM Process * Step 0: Create Revision * Step 1: Take Target Model Offline * Step 2: Retrieve last revision from Target Model * Step 3: Retrieve syncable revision tag…
October Latest Release!...and November Sneak Peek
Some fab new features including the highly anticipated Azure Blob integration in CloudWorks! Check out the full list here!
Can't get my export right
Hi community members, I have created a saved view in which I enable a filter to filter out any rows which have a CIP value (kLOC) = 0. The filter uses a boolean line item in the module itself, which defines if the value is different than 0. When I look at my saved view, it looks good. However, when I export the view, the…
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, while running this import -Run Process 9 Import Data from the Hub, i am getting the following error. can anyone please let me know where i am going wrong?
CloudWorks additional integrations for AWS
Currently CloudWorks can integrate to S3 buckets. Can we expand this to include FSx (https://aws.amazon.com/fsx/windows/) and EFS (https://aws.amazon.com/efs/)? this would provide much easier integrations into corporate file system. As more companies move to Cloud based IT infrastructure this would great increase ease of…
load all data from Prod Env to Cert Env
Hello, The users have completed a forecast cycle in the production application. We have developed a new dashboard in the Dev application and moved it to the UAT application for user validation. To validate the dashboard, users want ALL data(actual,user-entered forecast, and data loaded from 3 other sources) to be Synced…
Increase limit of row field when pivoting
It would be really helpful for myself and colleagues if more than just three items could be dragged into the row field whilst pivoting a module. This would also be really helpful for zero suppression on Anaplan exports as well as saving the need to manipulate Anaplan exports in Power Query (or similar data transformation…
Level 1 lesson 4
Can someone tell me what the correct mapping is for this? Level 1 Model 4 Import data into P2 products list
How to upload a file using Anaplan APIs? [Anaplan]
0I wish to upload a file using Anaplan APIs but as mentioned in the API docs here is that Note: To upload a file using the API that file must exist in Anaplan. If the file has not been previously uploaded, you must upload it initially using the Anaplan user interface. You can then carry out subsequent uploads of that file…
Sync Multiple Production Models at Once Using ALM API
With the release of the new ALM APIs recently, I thought it would be useful to see a real-life use-case of how they can be leveraged. Oftentimes customers will have a single development model tied to multiple production models and when changes need to be pushed, the model builder must go into each production model to do…
"While/Wend" or "Do Loop" Functionality in Anaplan
Within VBA, it is possible to create "Loop & Exit"/"While/Wend" or "Do Loop" functions. This allows formulae to continue running until an answer is produced. Within Anaplan, there are workarounds, but none are truly as flexible, and all have their limitations. Creating this functionality would close the gap on some of the…
Cloudworks with Azure - now generally available!
Please see here for the release notes!
Aggregating sales amount based on filter criteria
We have 3 modules where: 1. The Allocation module has Unique IDs(UID1), Time as a dimension and Attributes as Line items 2. The Sales Data has Unique IDs(UID2) as a dimension, Time, Attributes as Line items 3. Output Module which has UID1, UID2, Time as a dimension and Attributes as Line items We have to allocate the…
How can I change the hierarchy of list parent in module
Hi, I'm figuring if it is possible to change the hierarchy of list parent in module line item For example, I have the following list 'Test 2' with child 'A' with parent '1' and child 'B' & 'C' with parent '2', where the high level of list 'Test 2' is list 'Test 1' with two list item '1' & '2' I have put the following list…
Create an action using command line/shell script Instead of creating an action in anaplan.
The below feature is not yet to be included in the Anaplan Connect: Create an action using command line/shell script Instead of creating an action in anaplan.
Ability to search Excel Add-In page selectors
The Excel add-in currently does not allow users to search for list members within a page selector. This almost makes the add-in unusable for organizations with large lists. The solution would be to add a simple search option similar to the Anaplan dashboard/page interface, where users can click a drop-down page selector…
Dynamic names for exports
It would be nice if we could define dynamic parts in the export filenames. For example a timestamp and or information about the selection perimeter for example : define the name like VALIDATED_INVOICES_%ORG ITEM%_%YYYMMDDHHMMSS%.csv that produces a file named VALIDATED_INVOICES_FRANCE_20211005165155.csv when generated
Working with Processes and Actions
Hi Team, Placing these here as a bulk request: 1. Would like edit/view contents of Action when I find it in a Process. Today I have to abandon the process then go find it from the Actions list. 2. Search Actions when building a process: When building a Process we have to scroll up and down the list of Action (which may not…
Action Logs Not Capturing List Formatted Line Item Copy Across Changes
Hi Community, My query is more from a workflow management perspective. I will try to explain my case below : 1) I created 2 test modules both with same structure of dimension and list formatted line items. 2) The idea is that one module will act as a clearance module, i.e., will clear the line item values in the Target…
Experience with Cloudworks model to model integrations
Hi All I have noticed below with cloud works model to model integrations so far . Unsure if anyone else have noticed these as well * when setting up integrations page refresh is slow and hangs * when manually starting integrations i get message failed to start integrations randomly and after trying couple of time it works…
File format notification for uploads in new ux
We need to able to see the exact format(txt,csv) below the upload a file when we do file upload in new UX. Currently what ever the format of the file the action is created, it shows csv only. This creates the confusion for the user on which format the file as to be uploaded.
Data Import
In a dashboard, to update the forecast of particular FY, the user selects the FY and runs the process. But, instead of uploading file of selected FY, he uploaded another FY (say FY21 instead of FY22) file. When he ran the process, selected FY existing data wiped out in the target and no change in data of another FY. He…

Data Integration

Discussion List