-
import file amount rounding
hi anaplaner, i have problem about impor/upload file, when iam upload file number format, data in anaplan and excel file always different, ex: excel file 497.157.884.509 but in anaplan 497.157.000.000. how to fixing that problem?, and why is that? Thanks, Panji
-
Unable to Connect Using Basic Authentication : Says Invalid Credentials
This is my first time using Anaplan Connect My Batch File @echo off rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc set AnaplanUser="sripad.lokapure@abc.com" set…
-
Anaplan Connect model to model import process API Timeout
Having issues running the Model to Model import between work spaces. Has anyone encountered this issue... API request is timing out... Processes not found: Processes not found for Model ===================================================================== Anaplan Connect 1.4.2 OpenJDK 64-Bit Server VM (Oracle Corporation)/…
-
Use RESTful API to Export Data from All Modules (Without Export Actions)
Hello, Is it possible to export data from all modules (or selected modules; let's say there's 70 of them) without individually creating export actions for every single module? Thanks, Arthur
-
Anaplan connect 1.4 Shell Script
Hi Leaders, I have got encountered with the below error as I try to do Anaplan connect version upgrade 1.3 to 1.4. Not able to figure out the error. Script: # This script executes a data load import to the model set JAVA_HOME="/****/jdk1.8.0_191/bin/java" set CertPath="/******/OpenSSL-Win64/bin/certificate.pem" set…
-
Importing into a list based on a specific value of the parent
Hi, I'm trying to add functionality to a model where G3 items in a list are deleted and replaced with other items in that same list. The model has the following Hierarchy: In the G3 list, each Resource is either a resource in the current scenario or in the future scenario, this is achieved by the 'Type' property: On a…
-
Error when importing a csv file into a module
I am facing an issue with exporting and importing a csv file. So I have a file that I am exporting with data for 12 months (Dates are formatted as Y-M, (i.e. 19-Jul) in the exported csv file). Then when I try and import the same file using custom mapping (Y-M) for Time, I get a failure dump and an error which reads: Import…
-
Importing a list data by end user
Hi, Just want to know, can end-user able to upload data into the Anaplan list? or only workspace admin can do it? Anyway, he can upload changing user access? Import Action can solve this issue but anything other than that? Thanks & Regards Sai Bharadwaj
-
Excel Add In Filtering for Base Members Only
Hi All, Has anyone come across the ability to filter only for base members against a hierarchy in the Anaplan excel plugin instead of having to manually deselect all the parents them each time? The alternative is that I can think of is creating a saved view that only shows base members of the list, however the downside…
-
Excel Addin 3.3 - Filter on Line Item
Tried the new Addin, great improvements vs. 3.0 but still the same constraint of 1M cells. With that, I think we really need to have a Line Item filtering function to be able to control # of lines to download. Will this function be added? Thanks.
-
Length of Text value
Hi Anaplanners I have a question about the length of Text values.I tried to import a text data(500bytes) to a text format and failed.I was wondering if I had exceeded the length limit. Is there anyone can tell me the maximum length for Text values.Thanks!
-
Anaplan Connect 1.4.2 Shell Script
Hi, I was encountered with the below error code as I execute shell script. Shell Script : # This script executes a data load import to the model set JAVA_HOME="/****/jdk1.8.0_191/bin/java" set CertPath="/******/OpenSSL-Win64/bin/certificate.pem" set PrivateKey="/******/OpenSSL-Win64/bin/private2.key" set…
-
Tracking historical data in a live model without making the model huge
Hi Community, I've built a model where end users input information and it calculates outputs. This tool will be completed by end users on a adhoc basis, some will use it weekly or monthly, while others will it once in a while. One of the outputs, shown below, is based on live information in the model: As we want to keep a…
-
Territory Allocation Urgent
-
Import current month data
I already have previous month data. Now I want to import only current month data. Please assist.
-
Number are being imported as thousand instead of decimals
Hi! My numbers are being imported as thousand instead of a decimal number. But in my blueprint, the number is set up to have a decimal delimiter as dot, and thousand delimiter as comma. and those are the values that should be entered. Does anyone know what is happening? thanks.
-
Export selected list members
I need to export only few list member details. Can someone suggest which will the possible way to do so?
-
Selective List Export
Can you please tell me is it possible to export particular two List Members and corresponding Line Items?
-
How to add filters to data export?
Hi Experts! We need to export only a small set of data from Anaplan modules (Ex: Export only ACTUAL data for 2017.05 for LINE ITEM 'REVENUE'). Please suggest if this is possible using standard functionality.
-
About the imported display method
Import to dashboard using anaplan connect. I want to display only items that have been imported and entered Is there a way to automatically display only items that have been imported and entered? Can you filter automatically? I'm worried about setting the line item formula or setting the filter. I would be happy if you…
-
Clearing/ updating old records while uploading data into Anaplan without knowing what to clear?
Hi All, I have an issue which needs to be addressed for a client. I do have a solution however would like to reach out to amazing community and get a different viewpoint on this if possible . Problem statement : we need to clear an item from a module however there is no simple way to identify the item to clear Below is a…
-
High Charts or D3 Charts in Anaplan Dashboards or Anaplan Pages?
High Charts or D3 Charts in Anaplan Dashboards? Is it possible to embed or incorporate a charting library like High Charts or D3 Charts in Anaplan Dashboards especially after the introduction of new User Interface which runs on top of the latest and greatest in HTML5? I am not sure about its validity or feasibility from an…
-
Optimiser
Hi Problem Statement: we are trying to minimise the fuel requirement to provide a given amount of energy. As all the input datas are in month wise for all the fuel except the demand in which month wise aggregated demand of all fuel has been taken. Error: We will be able to run the process sucessfully. But we are not…
-
Anaplan Excel Add-in
In our Org, we have not yet authorized the use of Anaplan Excel-AddIn so far, even though some users use it. In the past we had experienced some issues such as the model being locked during export of data by users while using the AddIn. Now that there is a new version of Excel AddIn, i am reaching out to folks to get some…
-
Automating Import from csv file
Hello experts, We are looking at scheduled import to Anaplan through custom integration and I have a question around that. Context: There will be a csv file provided on a server periodically and the import needs to be automated. 1. I read that it it is only once I manually import a file to Anaplan, that there can be an…
-
Is there a way to lock a period when doing imports?
I have done dynamic cell access to lock periods in a module. This is working fine when doing direct input to anaplan. But when using import function, even if access is only ready only data is still loaded in Anaplan.
-
Continuously polling an operational model using Rest API
Hi Guys I have been requested by a client to continuously poll Anaplan Operational Model ( every 1 min) to EXPORT data from a module . Module is relatively small so about 20 rows and 2 cols . Right of the bat this doesn't sound like a great idea to me due to potential lock up of the model etc. therefore i wrote a Python…
-
Scripts and Java and MS Access
Hi, I have an overnight script that imports data from an MS Access query into a list, this worked fine with the old certs and the 1-3-3-3 environment. Now I have had to update my scripts and use 1.4.2 and there seems to be a problem with the url. Old script -jdbcurl "jdbc:odbc:EPOS" -jdbcquery "SELECT * FROM qry_EPOSLive"…
-
User Information
Hello, I am trying to create a model that pulls all the user information (Model roles, First Names etc) from each model in our system. This is really useful for Auditing purposes. Is there any way to import from the user lists in model settings to this model, or alternatively to create a dummy module in each model which…
-
Continuously polling and downloading data(every minute) from operational model
Hi All , I have a requirement to continually poll(every 1 min) and export data from an operational Anaplan model . I expressed my concerns about locking / slowing down model therefore to test it out i wrote a script which runs every min and downloads data from an operational model . Data to be downloaded is relatively…