-
about sum functon **** we can get the data last from 6 months actuals?
i have actuals data from last 6 months ..i have created last 6 months line item to get the data here .. Then how can i write the formula here .. Example Jan Feb Mar Apr May Jun July Aug Sep Actuals 100 200 300 400 500 600 700 800 900 last 6 months 0 0 0 0 0 0 0 0 0 Present my module is like above format so i need last 6…
-
Security protocol/connectivity between user’s excel add-in and Anaplan platform
I’d like to know security protocol/connectivity between user’s excel add-in and Anaplan platform? This issue will raise to security team to allow network firewall.
-
BOM Creation in Anaplan
Hello Everyone, In supply chain projects, it is often to have a BOM with more than 15 levels. One level can be both parent and child. and for one level, we need to identify all of the parents in order to calculate the quantity to produce. Clients often provide a file with at least 3 columns, The first one is the compound,…
-
Model to model Import
Hi All, Which function will go for avoiding duplicates when we are importing from model to model?
-
Help me with 7.2.1 Activity: Import Data into Product Details Module
Hi All. I am brain storming with this issue from last 12 hrs and checked all possibilities to do Import Data into Product Details Module task. I deleted my SYS06 module and recreated and checked if the formulas in line items are correct etc. Also check size list under general lists. I attached all the screen shots required…
-
502 Error for Large files
I am trying to load a very large file using a library partially built by Jesse Wilson. I am using the attached code, but am receiving the following error after about 40 minutes. For smaller files (files that take less than 30 minutes, everything works fine) 502 Server Error: Bad Gateway for url:…
-
Anaplan Connect Export Scripts Question
Hi Dear All I started learning export data by using Export Script through Anaplan guideline, but I found the script is a little different from the script which I found here. And my question is whether I write scripts by copying which one, an errors came to me, would anyone can help me to check my scripts? Thank you And I…
-
Alternative to hard coded username and password in JDBC connection properties
passing hardcoded user name and password in .properties file is not good practice this has raised questions by information security team
-
2.3.9.1 Import Data into DAT03 Historic Volumes module
I do not understand why I have to upload the file again...
-
Anaplan Connect - Put file gives Array Index Out of Bounds
Hi, I am having some issues with running one of my Anaplan Connect scripts to import a file & run a process. When trying to upload the file, I receive an error "Array Index Out of Bounds: 0". When I run the process from the Anaplan website and import the same file there, it works perfectly. When I run the script, using…
-
Real time inventory model
Hello Anaplan Community, I am attempting at building a real time inventory model that has kafka and postgreSQL integrated with Anaplan and has a base code in Java. I was wondering if anyone else in the community has an experience with similar techniques and would want to collaborate or offer any advice. I was also trying…
-
Import data error
Hi, In the above mapping, how could I correct the errors. The drop downs don't have other options to select. Can someone please advise. What am I missing? Thanks, Balaji
-
Level 2 Sprint 1 1.6.2.2 Create Saved View for Export
While importing Shipping Metrics.csv to module DAT02 Shipping Metrics, you may get invalid data format error. To solve the problem: simply edit the date format by Untangling Anaplan Time Mapping: to edit the FY( fiscal year) use: ??YY This solves the error. FYI
-
Incomplete certificate
Hello, I've started level 1 certification few months ago but was unable to finish it due to health and personal issues ... can I still complete level 1 certification???? Do I have to sign up for it again ... I need to complete level one certification, would love some feedback and I did the free course ... I don't want to…
-
Dependent dropdown
こんにちは！ 従属を使用してプルダウン項目を制限する場合、親階層を表示することは可能ですか? 仕様を知りたいです。
-
L2 - 1.5.6.2 Import Data into Historic Volumes Module - Issues uploading data
Hi, Im having issues importing the historic volumes file. Below my selection for importing the data But when i run the import, the data is ignored. See below Can anybody help? Thanks
-
ANAPLAN API 1.3 WTH PYTHON || IMPORT FAILED
Hi All, I am trying to import an file into Anaplan. I have run the import action using python. I am getting status code 200 and when i have checked import status it's showing successful but the data load is not happened in the module. Kindly help PFA Thanks, Sai
-
List Update Behavior - Manually Add an Element vs Import the Element
Hello, I have noticed a behavior on the list updates and I am not sure if this is normal, or is it something I am doing wrong. I have the S2 Supplier list that is updated by users, based on a module, where they enter the name of the supplier and the parent. Next an import action is run to update the S2 Supplier list based…
-
Exporting a saved view
Hello, I've created a module with 2 lists and line items . I saved 3 views, in which i hided some line items of my module so the saved views are showing different line items of my module. I tried to export a saved view choosing 'Tabular multiple column' , I have in output a file with all the line items of my module and not…
-
Importing into module
I'm unable to replace the highlighted parts with the name of employees while importing. Can you help me to do it right ?
-
1.3.4.3 Update SYS07 Location Details Module - Issues importing data
Hi, While performing the step referenced above, the field Region does not upload. I think the reason is because the flat file "Countries" contain regions in the format "AMER, EMEA,APA", while the flat file "Locations" contain regions in the format "Americas, Europe, Asia Pacific". Im wondering if i am missing any step in…
-
August 2021 Release and Sneak Peek at September
August 2021 Release and Sneak Peek at September Bulk Open from Table of Contents: From the Table of Contents section of New Modelling Experience (NMX) you can quickly open the objects of a particular functional area for faster access to the information that you may need. It leads to increase in productivity. Tab…
-
Anaplan Model to Model Import with informatica
Hi, Can someone explain if it is possible to schedule an Anaplan model to model import with Informatica and where can I find references to understand how that can be achieved. Any help is appreciated. Thanks and Regards, Aakash Sachdeva
-
Anaplan restful api uploads with zip files
Hello, I have a question about using the Anaplan integration API V2 guide. Is it possible to upload a csv document inside a .zip file to Anaplan? I'm able to manually upload a zip file with a csv in it, which works, but cannot figure out if its possible to do it with the API. I'm trying to do this with Postman but the data…
-
Control of pull-down items
こんにちは！ プルダウン項目の 1 つを非表示にしたいのですが、サブセットを使用できません。 また、最上位レベルは表示されたままにする必要があります。 これを行う良い方法はありますか? 教えてください。
-
Updating Lists on Transaction Data Import
Colleagues, hi! I'm seeking your advice on the following case: on a weekly basis, there will be a transaction file with the unique "purpose of payment" texts for each transaction and potentially new suppliers that don't exist in Anaplan list yet. How can we achieve automatic update of supplier list upon import and having…
-
REV02 Import mapping Problem
i am trying to map Volume+Inputs file.csv data into module but Cant seem to get data map. Tried Multiple methods. But cant seem to find a way. If anybody can help then comment down. I m also attaching the problem.
-
Retrieving Item ID from Dimension ID (Transactional API) from model front-end
Hi, We have a current use case where we are retrieving module data for a specific object within a list, and achieving this through the use of the transactional APIs (querying the view). We have the view structured such that the dimension for the object that we want to retrieve is in the "Pages" segment of the view. This…
-
Error with Anaplan Connect Script
Hi, I am trying to run a process with Anaplan Connect , using Java 8 and tried both anaplan connect 1.4 and anaplan connect 2 . I am getting the following error Any help would be appreciated. Thanks and Regards, Aakash Sachdeva
-
Mapping issues related to Activity 8.5.3
Hi, Need help in this Level 1 Model Building exercise. Though I did not get any errors after importing the data and mapping, the G3 Location Tab does not look right. Secondly, the pivot table in the line item view has to be changed. The volume needs to be before the Nutzo Bar. See mark up on Line Item screenshot (attached…