-
How to link parsed list back to List codes
Hi, I've created a module that contains a list with data that has 3 components of a list concatenated (to limit the number of rows). The list data looks like this: CCCC_AAAAAA_DDD - with the C's being company code, A's being account code, and the D's being department code. I now want to have another module that references…
-
Statistical Forecasting algorithms into a user specific model
Hi - I am new to Anaplan and I have a quick question: Let's presume we are to develop a supply chain demand planning module for a client. Since we exactly know what all lists/line items are needed along with the hierarchy and the calculation formulae for different line items, I prefer to have that developed everything from…
-
Optimize a parameter in statistic forecast
Hi. We are trying the Statistic forecast. In monthly model, we need to set parameters to run the statistic model. (Like Holt's α in Holt's Winters model) But this setup is manual input. Can we calculate the best parameter(0.0~1.0) by Optimize and minimize MAPE?
-
2.3.8.2 Import into DEM01 Module
I seem to be having an issue uploading my data into this module. The module is set to month, yet when I try to set the import period, it is in weeks: Separator can be any non-alphanumeric character Y represents year number (1, 2 or 4 digits) W represents week number in year Further, entering a custom format of YY?MMM to…
-
8.5.3 Activity: Different data problem
Hello all, I am working on Level 1 activity 8.5.3. I imported the file without any problem but my numbers are different from the screenshot given by the course module. Could you please help me with that? Merve
-
DAT05 Historic Revenue by Product
Hi, I'm trying to import historic quarterly 2019 data into the DAT05 Historical Revenue by Product module, but the time settings does not allow for me to select Quarters in the Time Scale column. Do I need to adjust the Time Settings for the Datahub model or is there something else I'm missing? Any guidance would be much…
-
Regarding Current version
Can current version be updated in Prod model after applying ALM through an import process?
-
Not able to run Anaplan Command through Talend Server (But the command is running fine through Local
I executed the below command through talend remote server java -classpath /home/talend/properties/eur_finance_bi/anaplan/anaplan-connect-1.4.3-jar-with-dependencies.jar com.anaplan.client.Program -k /home/talend/properties/eur_finance_bi/anaplan/<jks file path>.jks -ka <keystore> -kp <keystore password> -workspace…
-
Export in Anaplan API - What to do next?
Hi everyone! I'm new working with Anaplan and also with APIs. i've been managing it quite well but I'm stucked in one step hope you can help me overcoming this. I've already get al chunks of the export however I don't know how to download the data... the file exported 26 chunks and I get chunk id 0, 1, 2 and so on. So the…
-
Rest API 403 Forbidden Error while Update module cell data
Hi All, Using below link I am trying update module cell data using Transactional APIs using Postman. https://anaplanbulkapi20.docs.apiary.io/#WriteCellDataByCoordinateModule But I am getting 403 Forbidden error. I am able to use all other GET request successfully. Please find below screen shot: I can manually login to…
-
Add comment field to a Time dimensioned module
We have a process that users import data via Excel to Anaplan. The file format is shown as attached. The business would like to add a comment field at the end of the column for each project (see screenshot. the comment field is just a mock-up on Excel and does not exist in Anaplan yet). To add a comment field in this time…
-
SYS08 Employee Details Region
Hello, I am having trouble with level1 importing employee data in SYS08.I share the mapping screenshots to please check this.
-
Anaplan Connect with Apigee
Hi All, We are looking at using Apigee as the platform for managing APIs, and are looking to using Apigee for Anaplan (we have Anaplan connect at this time as the connector to integrate data between sources and target). Anyone suggestion on how we can get started?
-
How to create a current value by multiplying the value before it with another value
Hi there, I am trying to convert formulas from excel into Anaplan but am struggling with the formula in Anaplan. The pictures i have uploaded show the type of formula i want to create. I guess what i want to know is how can you be specific about the exact cells you use in Anaplan. Any help would be greatly appreciated.
-
Run model-to-model imports in Anaplan on a schedule that works best for you
You can use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation or add-on services are required to use this—everything you need to get started is in CloudWorks…
-
File ID In Anaplan
Hi Team, Does anyone know where can i find the File ID in Anaplan? Thanks, BS
-
PlanIQ [internal server error] Meaning
Hello while making the data collection for PlanIQ, I faced with "internal server error" and failed data collection. By adjusting the original module (by putting time dimensions for row), the issue is now solved, but I'm now confused about the term "internal server error" since the term seems to be broader than "your module…
-
Error while exporting error dump from Informatica
Hi, I'm using informatica cloud for importing from source system to Anaplan Module. The error dump is exported to a windows server to view incase there is an error in the import. Error dump is exported in csv format. But incase of an error in import when the error dump is being exported I get the following failed…
-
Level 1: 10.2.2 - unable to load non employee expenses data
With the above mapping With the above time settings Still the data is not getting uploaded while message says it is success. Tried all optio
-
Weird Character in fist column of .csv import
I have been noticing on some .csv imports weird characters appearing in the first column of the .csv When I open in excel or text editor the characters are not there. Additionally, I seem to be seeing this quite a bit with exports directly from Anaplan.
-
Tableau connector usable with other tenants?
Is there some way to connect from Tableau to other tenant workspaces than your default tenant? I can't find anywhere to change the tenant and there is no word about it in the documentation. In the connector I can only select from workspaces within my default tenant.
-
Anaplan Connect API - Max size of single chunk
Hello everyone, Our integration developers want to connect to Anaplan via API 2.0. However, they need to know what is the upper limit of single chunk size. I know that Anaplan recommends dividing uploaded files into chunks not bigger than 50 MBs (source), so I assume it is a safe limit. However, you cannot set up chunk…
-
How to create Import/Export/Action or Process using Command Line/Shell Script in Anaplan
Iam running the below Command: java -classpath "E:/Neha_Nayal/Anaplan/anaplan-connect-1.4.3-jar-with-dependencies.jar" com.anaplan.client.Program -k E:/Neha_Nayal/Anaplan/keystore.jks -ka keystore -kp keystore_password -workspace workspace_id -model model_id -service service_url -auth auth_url -file…
-
Anaplan Connect - Cannot locate 'Anaplan-connect-@re@.jar'
Hi Team, Attempting my 1st upload using Anaplan connect but receiving the below/attached error. I have below/attached the batch file I am using I have looked in the User Guide & online but cannot find a solution, appreciate any help Thanks! Mark
-
Help with Python API 2.0 & Transactional API
Hello I am attempting to utilize the transactional API in Python. Specifically trying to retrieve all line items in a model w/ID I tried doing this in Anaplan Connect earlier, however, it did not work for me. I am now trying in Python. However, it's quite the challenge as 1 article does not have the steps, I am having to…
-
'cmd' is not recognized as an internal or external command - while importing
Hi, I am trying to use a bat script to import in a list. When I manually enter username and password in the script, it works fine but when I change it to read it from a .txt file, it shows the error: "'cmd' is not recognized as an internal or external command, operable program or batch file.". It's not like there is an…
-
Schedule model-to-model imports in Anaplan as often as you'd like
Use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation, add-on services, or technical resources are required to use—everything you need to move data between…
-
Issue with Anaplan Certificate and Anaplan Connector
Hello All - It is my understanding that the latest version of Anaplan REST APIs and Anaplan Connector (v 1.4, lets call this AC) requires a CA Certificate for authentication against Anaplan. As…
-
Is Anaplan Add-in application the same for both MS Office 32bit and 64bit?
Our Finance team is upgrading to MS suite 64bit. Is there any known incompatibility between Anaplan Add-in 4.2 and MS Suite 64bit?
-
Export not Utilizing Filters
Hi Anaplan Community, I am working on a dashboard that includes a module with 3 dimensions (list 1, list 2, list 3), one for each dimension. On the dashboard there is an additional a module with a single line item that is list formatted. The second module is page synchronized and works as a drop down selector for the…