Data Integration

Selective slide exporting from Management Reports
It would be great to be able to select specific slides to export when export management reports to PDF. Currently the system automatically exports all slides and you can't deselect any if you don't want to include them in the report pack.
Integration with SMFT protocol URL.
Hi Ananplanners, Would like to know if any one of you have experience working on Anaplan -Web transfer(SMFT URL) integration.? If yes. Could you Pls. share the integration process ? Thanks in Advance. ~Abhi
Custom Module Views in Powerpoint Add-In
The Powerpoint add-in does not allow users to create custom module views. This is essential for user adoption of the add-in, especially when a referenced model utilizes ALM (Dev/Prod). In its current state, the Powerpoint add-in relies on saved views from a model. This is fine when the underlying model is in Standard mode,…
Level 2 Final E[am
Good afternoon Please help me figure it out: in the final exam of Level 2 on the Numbered List question, I can not answer correctly in any way, and I think that maybe it was a problem with the Internet, so the correct answer could not be counted by the system. To clarify: I am worried that due to a technical failure, the…
SCIM APIs: A Use Case to enhance your Central Identity Management (CIM) Process
Need a refresher on SCIM? Read our [Start Here] article! What is User Provisioning? Let's start with a reminder; User Provisioning is a process by which an individual is granted access to the Anaplan platform and assigned the model role that allows them to interact with the information that they are authorized to use. We…
Model Builder 3 Training 5.5.1 Data Hub Model
Hi All! I am working on Model Builder 3 and am on step 5.5.1 which says: "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data Hub module". In my starter model, there is already a SYS09 Employee Details module with all of the information…
Changing source file name
Hello Community! I´ve been working with Anaplan for several years now and whenever I´ve needed to change the import file for an import action I´ve just created the action again using the new file. This usually isn´t a problem so I haven´t given it a second thought but what if you had 15 actions that are included in several…
Moscow TimeZone for Cloudworks
As an Integration Admin, I need to schedule an action in Cloudworks for Moscow TimeZone (UTC +03:00) to run actions in the proper time.
Filtering by Users when Imporing
Hi, I want build a system several End Users can make the master data at the same time. The point is EndUsers do it at the same time. So I made a module which has Users as Applies To. And EndUsers have to import this module to List. But I could not filter by Users. So data which another User made was imported at the same…
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…

Data Integration

Discussion List