-
Anaplan Connect Integration
Hi Experts, Anaplan Connect scripts to connect to the internet via web proxy server? Could you please share your thoughts on the above question raised from one of our customer? Thank you in advance. Best regards, Anil
-
cloudworks process runs but no data transfers
I am using Cloudworks for the first time purely for scheduling transfer of data. I have a process that simply imports data from a module to a list within the same Model. I set the Cloudworks process up and it successfully runs (green tick) However it does not actually import any data. If I run the process (action) directly…
-
How to execute data load process in parallel from one hub to different spoke models
How to execute data load process in parallel from one hub to different spoke models
-
Updating Salesforce with Anaplan data in real-time
Has anyone seen an environment where Anaplan updates Salesforce in near real-time? If you have, what tool(s) are you using to run the inter-system integrations? What is the export frequency set at between the systems? We have a use case where an end-user inputs data into Anaplan, then clicks a process button to "submit"…
-
Help! I'm looking into a performance problem!
At present, there are two workspaces, workA and workB. A process needs to be added to the Action of the first workA to import the data of moduleB in workB into the List of workA. When the amount of data is large, Whether the workB moduleB cannot be opened and edited when the action is executed.
-
why integer number being transferred into decimal number after importing
Hello All I have faced an issue that some integer numbers being transferred into decimal numbers after importing. The situation is I imported some code from a saved view of a module from A Model to the code cells of the list of B Model. For example, the code 179546 in a saved view of a module from A Model will be 179546.0…
-
Problem with decimal separator when importing
Hello! I have a very small issue when importing a .csv file into my model. I have designated 'comma' as my decimal separator, but Anaplan changes it to a point for certain data entries after doing the import, despite only having the comma as the decimal separator in the import preview . I am adding a couple of screenshots…
-
Saved View Import Have some code self attached to it
Hi, When I am trying to import a save view from the different models in a different workspace, the save view names are getting added with a hashtag code and the import is also not working, the Error is failed to locate the Save view , Anyone have faced a similar problem?
-
Collaboration using Microsoft Teams
Hi, One of our client is looking for an Anaplan implementation for production planning and scheduling and they prefer to have collaboration with MS Teams. Since the direct integration option is not available any workaround to have collaboration via MS Teams? Thanks, Nisha.S
-
How to reference a Dashboard via API query
Hello, we'd like to show from a CRM Salesforce page an Anaplan Dashboard (e.g. containing the actuals of Sales Rep incentives achievements). How to reference a specific dashboard via API in order to show only that dashboard in the Salesforce page? Has the Dashboard in Anaplan a specific ID or URL? Thanks Giuseppe
-
Importing Data into a list from module returns blanks
I tried to import data into a numbered list from a module and except for the parent and code columns in the list all the other data updated with blanks. I have attached the screenshot of the mapping used during import.
-
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…
-
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…
-
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…
-
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…
-
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.
-
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…
-
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
-
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…
-
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…
-
Jira Integration
How can we integrate Jira with Anaplan. Can anyone please help me out.
-
Date Formatted Line Item || Default Mapping during import
Hi, I have a date formatted line item in one of my modules where we are importing the data from a file upload. I want to understand that what is the default format anaplan would require 'Date' column in the file if I do not select a custom mapping? Regards, Aakash Sachdeva
-
Google Sheets Add-On
Is anyone else having issues with refreshing data in Google Sheets via the add-on recently? The load keeps freezing or telling me there are various errors.
-
Create filter based on line item
Hello All, I have a requirement where we can create filter based on line item so that we can export them. There are five line items for example - Payroll tax, salary, overtime, incentive, and bonus. The user should be able to check (using the new UX) which of the line items they want to export. Based on the checks, we…
