Data Integration

Show 'referenced by' also for saved views
We use frequently saved views to import data from a source module into a list or other modules. A great challenge is to understand where these saved views are used, it is particularly challenging when you import data across models. The only current way is to go through the import sources of each model or use the business…
Windows cmd shell script for dynamically generating JDBC.Properties file (A.C. 1.4)
Use Case: Batch import automation scripts using a SQL query in Anaplan Connect (AC) 1.4 require a companion .properties file that contains a lot of information about the query (connect string, login credentials, SQL statement, parameters). As a best practice, you should avoid hardcoding usernames and passwords in plaintext…
Add 'Use Current date' as model action
The 'Data Write' action functionality in Anaplan App (UX) is great and provides the ability to 'Use current date'. This means that by pressing an action button on the page, a module with a date format will be updated with today's date. Seamless and simple! Below I have 2 simple use case examples for this: 1. Workflow -…
Importing into a numbered list and module
Hi Anaplanners, I have a query, I have a numbered list KKT with display name property and I have made a KKT DET module dimesioned with KKT and has line items code and name. These line items use formula code(item(KKT)) and KKT.display name. To create actions I used a file to load KKT list and then same file to load KKT DET…
Web Form Integration with Anaplan
How to push data from web form (.Net C#) into Anaplan. Can we use single user credentials (Anaplan user) to generate authentication token at web form which can be used by many users logged in into web form to perform API Calls. how we can export data back from Anaplan to web form. how to use Anaplan API Certificate to…
Mulesoft Anaplan connector not able to read keystore from path specified when deployed in Cloudhub
HI Team, We are connecting to Anaplan using 3.1.0 Anaplan Mulesoft connector by Certificate auth connection. We acquired required certificates, JKS and all steps are done. Anaplan Mulesoft connector asking to provide JKS file path, we were able to configure it successfully and able to get data in local machine. But when we…
Facing issue in Parent Child allocation
Hi Community , Need Help from the topic " Lists" . While importing data for Parent Child bifurcation or allocation facing the following issues : ( Not getting the correct profile ) : The screen shots attached for 'Product ' & ' Employee ' Lists. Please help Thank you
Data type mismatch: format other than LIST or DATE being referenced as a relation
Not sure what the issue is! Please help.
AM365 and Google Sheets Add-in SSO login redirecting to Anaplan Home
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue If you have a live session on Anaplan on another tab, when attempting to authenticate via SSO, you will be navigated to Anaplan Home on the popup window instead of it redirecting and…
Level 2 Conclusion: Importing Shipping Export INV05 into OTH 01 Non Employee Expense
Hello Friends, I am getting error as attached herewith in the above process. Could you please help. Thank you in advance
Anaplan model data source
Hi Anaplanners, I am working on an existing model and have some queries: 1. Some lists and modules get data from informatica cloud, how can I know what all modules or lists get data from informatica cloud, also I cannot find this under Actions or Imports right? 2. To load a list from informatica cloud, what all…
Interaction with Rest API for 100+ users
Hi All, I working on a web form developed in .Net C# which interact with Anaplam Imports and Exports. On Webform users will input data and on submit of webform data will push to Anaplan so how can i do achive this functionality , as of now i am checking with REST API provided by Anaplan. I need clarity if multiple…
2.3.9 Activity: Historic Volumes to Baseline Forecast -Action Contains the wrong information
When attempting to Run Process 9. Imort Data from Hub- I consistently hit this error. Import into DAT03 Historic Volumes module unsuccessful: Ensure the column headers in the import file map to the correct dimensions in your module, then run the import again. I searched this community before posting this question and saw…
Automate pdf Export
Hi, The new UX looks great and I know it has the ability to export a dashboard in pdf format. Is there a way to automate this process? I want to schedule some reports to be exported as pdf files to a cloud location or send as attachments to an email distro list. Thanks for your help.
L1MB 4.6.8 Activity: Import Data into E1 Departments List
Hi All, Newbie here. Have a confusion on the below activity. Below is what suggested in the training module. Grid view should look like this When I import the Department for the above grid view - I get the warning but the data gets loaded as per the document. When I try to correct the import via these steps Correct Mapping…
Add a “Notify User” parameter to the SCIM API call that adds users to Anaplan
Allow the API to switch the notification email off before adding new users to a workspace. The notification email includes an incorrect link asking users to register an account, even though we use SSO and they do not need to register. This was flagged by our project sponsors who want to prioritize ways to avoid having this…
Display year based on range of numbers
Hello, I have a module that contains a bunch of servers, and for each server there is an asset tag. The asset tags are in sequential order. I was wondering if it was possible to display the year for each server based on a range of the asset tags. For example, for a given sever, I would like it to display FY17 if its asset…
Syncronize card template context selectors for Microsoft 365 extension
Summary (See suggestion* for detail) - Improve user experience with user driven context selection for cards in template library, rather than going into the backend and updating each saved card for the required context. Context - The release of the extension - Anaplan for Microsoft 365 allows users to import from cards in…
Insufficient permissions for Amazon S3 - Cloudworks
I was wondering if anyone had any insight on the following error when attempting to run an integration with Cloudworks?
Exporting Layout Help
Hi friends, I'm looking for a way to export data to match a client's mockup. My export module is set up with all necessary dimensions but I can't figure out a way to have my line items (Area, Account, Budget Code, etc.) to the left of my time in months - layout only needed upon export. Appreciate the responses
1.3.6.1 Code and Items?
Hello Everyone, Instructions for 1.3.6.1 go as follow: 1.3.6.1 Create Build Region Saved View Create a saved view for importing: * Module Name: SYS05 Region Details * Saved View Name: Build Region * Include: Code and items Make sure to select SHOW for the Code line item and save the view. This will ensure that as new line…
Can I add drop down list (with data from a list) to cells that are loaded with data?
Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to data if the loaded data is incorrect. I'm having trouble including both a drop down list and prepopulated data in the same…
Prevent Import
Hi, I have a scheduled import into a history module with a snapshot of data, every Friday at 2:00am. This all works. However, sometimes we need to take the snapshot manually earlier in the week, and if this has happened i dont' want to allow an import on Friday. As the import is using anaplan connect and runs every Friday…
Activity: Import Data into FP&A Model
Hi Team, I'm unable to understand the import below shown is my mapping.
Import Final Demand Forecast into DAT02 Module
I'm unable to understand why errors are coming though i think mapping is fine plz help
Enable Power BI Anaplan Connector with SSO
The majority of our customers have an SSO only policy. This means Power BI can not be used by them for additional analysis of Anaplan Data. As a Power BI end user with SSO enabled I want to be able to use the Power BI Anaplan Connector so that I can do additional analysis in Power BI.
Issue with changing source model
Hello, I am currently following the Level 2 - Model Building Sprint 2. I had to change the source model to the Data Hub created during Sprint 1. Unfortunately, the name of the source didn't change when I clicked on "Edit Mapping" but just added the details in "Mapped to". When I followed the next steps to populate data…
Export Actions with timestamps without workspace admin rights
Hi Team, We are running integrated processes using Anaplan API and batch files, with a Service User account setup in Anaplan (non SSO account). What I'm trying to do is to Export from Anaplan an Action List with timestamps into SQL data base. I've made a connection that works, but it requires the User account to have a…
Import data to read quantities per dimension instead of actual data
Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location.…
cURL fetching an export from API intermittently failing with 500 Internal Server Error
Hi All, We are trying to GET the exports from API but it is intermittently failing. At times when it is successful the response header will have content type returned as "Content-Type: application/octet-stream" and when it fails response header contains "Content-Type: application/json;charset=UTF-8" FYR see below when it…

Data Integration

Discussion List