Data Integration

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…
Export Actions in a Process
It would be useful to be able to export the Actions contained in a Process. Currently the only way to extract them is to highlight them all copy and paste into Excel. Add a column numbering 1 to x and then sort on the action name to get rid of the "Remove" labels and then re-sort back on the key to get the Actions in the…
Adding actions in the process
Similar to adding modules/lists, there should be a way to add action into the process by selecting the action that are already present in the process and be able to add before/after the selected action. As the action will be added at the bottom on the process by default it is time taking process for moving action to the…
Level 1 Model building Lesson 4 Lists
So I am playing catch up and I cant figure out the correct mapping for the list. I am on 4.6.5 Activity Import Data into G3 Location List. It doesn't outline the file mapping and sources like it did in the previous activity so Im just wondering what the correct data is for that. I import the list but then I get stuck on…
hide values in cell based on bolean check
hello guys, i have this module dimensionned by a list. The list is made from differents families and the row axis is made of many lines item and whenever an element is added by the user it insert itself on top of the its parent(family). so the parent is the total line of his elements, what i want to do is to be able to…
Missing data in forecast version of REP03 module
Please help. I am Missing data in the forecast version of the REP03 module and cannot figure this out. I feel like I've checked everything three times, and don't know why the data isn't populating.
Import data into the P3 SKU list.
Good Morning Everyone, I'm trying to import data into the list P3 SKU . I couldn't find the view Build SKU in SYS12 SKU Details module though i have already created the Build SKU saved view, tried to log out to let anaplan synchronize but it doesn't help , I cannot proceed further . Any suggestions are most welcome .
Upvote here if you like the idea of Management Reporting Exporting to PPT!
See this article on Idea Exchange if you like the idea of being able to combine the power of Management Reporting in Anaplan with the output of MS PowerPoint - could be a fantastic addition to the offering.
Email alert/notification if any error in log
HI Team, I am looking for a shell script which can send an email alert/notification if there is any error in Anaplan connection/logs. Regards, Tushar Bachhav
How to avoid garbled characters when importing
Hi, I want to import csv file which has Shift-JIS encoding which is Unique code in Japan. I have a problem the text has "(株)", "No.". <Data source> No. <Anaplan> �� I think this text is windows's environment-dependent character. So I changed the import setting from Shift-JIS to windows-31, and I could solve it. Does…
Export data to Excel, later version
Hi all, I am wondering why, when exporting data from Anaplan into Excel, the file type is a Microsoft Excel 97-2003 worksheet? Why are we using such an old format? Is there an option available to export to a more recent Excel version? Excel 365? We currently loose functionality in this old type of Excel sheets. thank you!
line item subset filter
hi! How do I show or hide different line items in a filter using line item subsets? To do this, we want to use the ITEM function to retrieve items from the line item subset list. What can I do to help?
7.2.1 Activity: Import Data into Product Details Module
Hello Please help, i spent already an hour and half to make a view needed in the task - i still have the wrong view. What I have The view needed Please help to solve!!! Thank you! Anton

Data Integration

Discussion List