-
Reset a line item
Hello all, I do not find the corresponding course, but during training for MB certification, it was said that the best practice to reset values of a line item (numeric or boolean for example) was to create a line item with no data as format, and to import this line item into the first one. I would like to reset a user…
-
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
-
Data integration - Members are not added into numbered list during import with Cloudworks
Hi all, I need to import data from view and I have to import all records from differents views so I am using numbered list for the import. The process is working well when I launched the process with my user, all members are correctly added but not with Cloudworks 🤔 As you can guess, I want to schedule the update and I…
-
Connect Anaplan from Databricks
Hi Team, I need to copy my Delta Tables from Databricks to Anaplan. Can someone provide details/script on how can I achieve this task as there are not much open source details available to achieve this.
-
import file error
Hi Anaplan Community, Below is a screenshot of the error I receive every time when I try to run a process with and excel file upload. what is more concerning is, if the same file has been uploaded by different user then system works fine? Please let me know how to tackle this issue.
-
How to make a line item a Subsidiary view
Hi, I'm having trouble making this specific line item in a module into a subsidiary view, in picture attached. The line item i want to make a subsidiary view is Territory. Can i please get some help? Thanks! Amanda
-
Incorrect chunk counts using API
We are getting incorrect chunk counts using API https://api.anaplan.com/2/0/workspaces/{workspaceID}/models/{modelID}/files We are trying to export ~1GB file from Anaplan production model, which is ~100 chunks. But from last week, we are getting random chunk counts for all export processes across all models (incomplete…
-
Perform Data insertion in Anaplan Module and List through API
I have working on a integartion where i need to push data from a Asp.Net webform to Anaplan Model and List. To perform such action i am using Anaplan API's from the Anaplan suggested method of import: https://community.anaplan.com/t5/How-To/RESTful-API-How-To/ta-p/33579 While running api i am unable to update data , every…
-
Oauth 2.0
I’m trying to understand if I can use Oauth 2.0 as a way of allowing Anaplan users to provide access to their Anaplan tenants to a 3rd party application. Can I create a single Oauth client in my tenant, and have Anaplan users from other tenants go through the Authorization code grant flow? Or is an Oauth client only meant…
-
print chart
hi! When using a print chart, I would like to give it a title. Also, is there a reduction function or an axis selection function? Please tell me!
-
fill code automatically
I would like to be able to add members to a list but have the code fill in automatically. is this possible?
-
Import & Upload functions using BULK APIs.
Hi Team, I have couple of queries regarding Import & Upload functions using BULK APIs. For Import function to work - file should already exists in Anaplan. However, if I want to import fresh files then I need to upload the files first as per my understanding. Now in order to upload files, Anaplan says that the file must…
-
Anaplan Optimizer Demand
Why is Plant Demand not considered an Assumption in the Anaplan Optimizer? "Assumptions are line items with numeric format. They can be calculated or input. If they are calculated, you cannot use a variable as part of the formula." Since Demand would be numeric value, why would it not be an Assumption? You need to be able…
-
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…