-
Error when importing .csv data
Dear all, When importing price information (.csv file), it appears in Anaplan as a multiple of 1000. e.g: a unit price of 42.99 in my csv file is imported in anaplan as 4,299.00 As anyone ever experienced the same issue? Best
-
Consolidated Module (with list output type to combine)
Hi, I have 3 modules, all sharing the same dimensions (period, transaction# and employee list). The first 2 modules contains line item "metric" both with output type list (same list), I need to see all the data in all line items of module 1 and module 2 - it should be consolidated in module 3. In module 3, it has the same…
-
How to relate items to list
Hi experts I have problem in importing data. The picture is sample of failure. I want to relate specific employee under regions. How to do this in 1 step? thanks in advance. tsuyoshi
-
Error when importing to a module with new line items
Hi, We have some intermittent issues with import actions that give up the following error (in pic) The target module had a new line item introduced which was on a subset of the same list as the entire module. The module was based on Subset 1 (applies to). The new line item was based on Subset 2 (applies to). Subset 1 and…
-
End-user file import from a dashboard
Hi all, Just wanted to confirm if end users can use the data/import function via the little drop down arrow next to the module name on a dashboard? I am currently getting an error message and I am not sure what i need to "switch on" or assign for the end user to be able to run an import. I know that often an import button…
-
Connect to SQL server
Good day I have an SQL server as source of my data. What are my options to import this data to Anaplan? Thank you! Renier
-
Upload modules into new model new workspace
Hello Mates, I have exported (csv) my 10 modules from my model 1. This model 1 is in workspace 1. Now i want to copy/.upload all these 10 modules (with formula, format, summary..etc..) in different model which is in different workspace. But there is no import option available. Simply, i want to replicate my work in…
-
How to relate sub-region under regions
Hi Experts, I have problem in importing data again. Could you tell me how to map data Sub-Regions under Regions? For example NOAM > US North > Anderson, Janet Kindly see what is expected and what it is now in my screen. thanks in advance. Regards, Tsuyoshi <<What is expected>> <<This is my screen now>>
-
What are the settings for Exporting a Dashboard as PDF?
There is a dashboard which I want to export as PDF. But the exported PDF is very different from what I see on the dashboard. Please help me with this Dashboard ViewExported PDF View
-
Format of export data (ISO-8859-1 or UTF-8)
Hi Product team, What is the format of data when exported as .CSV or .TXT? Is it ISO-8859-1 or UTF-8. What I have seen is if the module is English only it outputs as ISO-8859-1 and if the module is Chinese, output is UTF-8. Can we have some clarity on this please? Thanks in advance. -Regimon Sebastian
-
Date Format conversion
I have a module in Anaplan whose one line item is date formatted. I imported a csv file which is having a date column with the format MM-DD-YYYY. The import results showed a failed report becasue it accepts date format as MM/DD/YYYY. Is there any way to map my csv file having the abovementioned format with the date…
-
Import of partial list
Hi All, Is there any way i can import a part of list into a model from a huge list from another model?
-
Can't upload the parent under partner list
Can't upload the parent under partner list
-
Get list of all models in workspace.
Is it possible to get list of models from workspace using Anaplan Connect? When I use Anaplan Connect, I have to use model ID. I want to download all models with model names and Ids. Customer will choose Anaplan model name in his app, I will download all models and I will get Id, I will send Id to Anaplan.
-
Ranking on data Loads
Hi, Please see attachment for details. Thanks in advance. Regards,
-
Parent Child Mapping Error
Hi, I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify those combinations in a staging module for error check in anaplan.
-
how to do variance in list items.
Hi All, how to get the values form one module to another module in list items using subtracting function. Please find the attached Screenshots list items formula given bellow: Base-Base Base- Simulation 1 Base-Simulation 2 we have using bellow formula IF ITEM(Snapshot Versions) = Snapshot Versions.Base THEN 'TW28: What If…
-
Read access and write access driver query.
Hi, I used read access driver and write access for a line item to get the dynamic cell access. (calculation formula is used to get the data for this line item) . 1)It is not working though I used DAC concept 2)Quaterly data is also not displaying for that line item though I changed summary items to ALL or ANY from None.
-
Make Existing List a Parent of another Existing List
I have two lists that already exist. The first list has items that are a concatenation of employee, role, and project. The second list is just the projects. There is a module that has the following items (in addition to others): * Text format: concatenation of employee, role, and project * List format: concatenation of…
-
size limit of data loads
Is there a limit on the size of data imports taken through the Anaplan Connect?
-
Line items with list dimension - Importing data and design of model
Hi, I am modeling our warehouse operations and it has a bunch of line items and "categories" as follows: Jan-19Jan-19Jan-19Feb-19Feb-19Feb-19Mar-19Mar-19Mar-19 I/O…
-
Separate Report Export per Region
Is it possible to setup an action where a report export to xls loops through all territories and saves a separate file?
-
anaplan api 401 Not Authorized using Postman
Using Postman: I can use Post and get an authorization token, but when I create the Get with Authorization = AnaplanAuthToken <token from Post> Content-type=application/json Basic Authentication and workspace ID and Model Id in URL https://api.anaplan.com/2/0/workspaces/<workspace id>/models/<model id> I get: { "status": {…
-
Make REST API Calls From within Anaplan
Hello all, I was wondering for whether it is possible to make rest api calls to another service (say servA) from within anaplan. The other service servA will of course then make some work and then maybe make a rest api call on anaplan back. I understand by reading some other posts regarding REST, that it is possible to…
-
REST API CORS block
Hi I can successfully connect to Anaplan using Postman. Can do all the necessary calls and get returned data. However, if I try to access the REST API via REACT, Angular or even regular webpage I am always blocked by CORS. Can anyone offer some advice on this?
-
Simulating Ad-Hoc Data Push With Anaplan Connect
Currently, Anaplan does not support data push, or ad-hoc integrations from within the platform. This can be achieved using a microservice, such as Flask, but can also be simulated using Anaplan Connect and a couple simple scripts and a simple module within your model. The first step is creating a small module in your model…
-
Changing date formats while importing into modules
I am building intermediate module. While importing data into Rep Setup module the Start Date and End Date are formatted as DD/MM/YYYY instead of MM/DD/YYYY. How to change this? I observed that in excel it is in MM/DD/YYYY format and there is no option to change format in Line Items formatting or while importing
-
Using Python results in Anaplan
Hi All, We are trying to build a model which would contain forecasting results flowing from Python. Please direct me to the best learning material from where I can work on this integration of Python / R with Anaplan Thanks and regards, Aishwarya
-
How to Create 'Export a Dashboard as PDF' and publish it to dashboard?
Hi, We have an option 'Export Dashboard as PDF' on the dashboard. Based on this option I am able to create a PDF. When I go the list of actions I do not see an action in the exports that is created for this. Basically I want to place that action on the dashboard. So that in one click I will be able to generate a PDF.…
-
How to create a Java Key Store (JKS)
Please note that Keytool is a java application and you will need to confirm that is installed on your machine. If not you will need to install a java version that has keytool, either jre or jdk. Once you have confirmed that a jdk is installed, please go to the search bar and type in – cmd. This will bring up the command…
