-
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…
-
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…
-
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?
-
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 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.
-
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…
-
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…
-
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…
-
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…
-
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.…
-
Jira Integration
How can we integrate Jira with Anaplan. Can anyone please help me out.
-
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…
-
Power Query - Get Data from Anaplan
I use Power Query within Excel to connect to online sources such as Salesforce. Is it possible to connect Power Query within Excel to Anaplan and how do I do this? I have seen an article about the Power BI connector but I cannot see a link to where I would download it from or whether I can use this with Power Query in…
-
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
-
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
-
On-demand event based triggers
Is there a recommended way to utilize "callbacks" or "webhooks" with Anaplan? I have a use case where Anaplan needs to update Salesforce in real-time via an event based trigger. Use case summary: End-user inputs data into a dashboard, then clicks a process button to "submit" the data to an export ready saved view. The…