Data Integration

Level 1 Model Building Exam - Model Buliding Activity 4
Hi, I'm trying to download "Employee Details By Role.text" data but it down loads in to the internet explorer. I have attached the screen shots. Can I please request some help on this. Regards, Nayani
Easily Integrate Data From Google BigQuery With Anaplan Connect
Users can leverage Anaplan Connect for bi-directional integrations with Google BigQuery. This free connector makes integrations between Anaplan models and Google BigQuery via Java Database Connectivity (JDBC) drivers that leverage the power of BigQuery's standard SQL. Users can easily pull any data from BigQuery—such as…
Partial Mismatch in Anaplan vs Scrum Methodology
Colleagues, hi! Is there any specific reason why in Anaplan Way we change the terminology for basic definitions? Project Sponsor = Product Owner Master Bucket = Product Backlog Sprint Bucket ? Not even sure as based on Anaplan Way training Sprint Bucket populates specific sprints in a release This is especially odd when in…
Level 1 training program Anaplan model builder | Level 2 training program Anaplan model builder
Hello guys. how long does it take to complete the Level 1 training program Anaplan model builder? how long does it take to compete the Level 2 training program Anaplan model builder? it seems a lot of learning material. what is the best practice; (only to fly above as fast as possible)? or take a note of everything that is…
Refresh button and Pivot button Disabled
Hi All, I had installed the upgrade version 4.0. Now when I login, the Refresh button and Pivot button is disabled. Kindly help in getting this resolved. Thanks Ujjwal
Duplicate item in the import file
In User storry 2.2 we need to update the territory with the accounts name, but each account should be map to a Single territory. At 4.4 we should update Territory to accounts with the file. But the file have one duplicate and generate the followint Warning.
Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)
Hello, I am trying to run an export action using Certificate Authentication but i am getting an error. Below is my script and the error, any help would be appreciated! My script is: @Echo offrem set CertPath="C:\certs\cert.pem"set KeyStorePath="C:\certs\AC1.4_keystore.jks"set KeyStorePass="keystorepass"set…
How to upgrade from 1.3 Anaplan API to 2.0
Hello community, Could you please tell me how to upgrade from API version 1.3 to 2.0? Thank you
Level 1 Exam - Model Building Activity 4 importing data file Employee Details by Role.txt
Hi The text file Employees Details by Role.txt is not importing the data properly. As the columns are not in proper order. screen shot attached. Would appreciate some help. Regards Thiru
Filter with time as page selector
Hi, I am trying to create an import with user input and have time as pageselector. When I created a filter to import data with the rows having user input and time as current page it actually filters first and bring the data for all time periods. Now if I bring time period to row and apply filter it bring multiple year data…
Upload a file (internal error)
Hello, I try to upload a file in my model, with API via a windows script like below. I try to upload like the api use requirements, but I ave an internal error on the second step STEP 1 : upload a file as a single chunk CURL --user user@xxxx.fr:password --header "Content-Type:application/octet-stream" -X PUT -d…
Auto Order Lists and API Enhancements - Help!
Anyone know where I can get the instructions on 9/26 release notes to automatically reorder lists and what the API enhancements are? Looks like some game changer upgrades! https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429 Tag: @Misbah @DavidSmith @rob_marshall @LipChean_Soh @ChrisAHeathcote
Need help in importing data into module
Hi I am trying to load data from .csv file into Module using import option. Data from one column 'PO Approved Date' is not getting loaded into the module.Please see the screen shots attached. Any help would be appreciated. Thanks Regards Prabakaran
Consuming Anaplan Rest API 2.0 from Java
Java Spring Boot Framework Provides an easy way to interact with the API. It can call any application Base API and process the Response according to our needs. This article explains how we can invoke Anaplan Rest API using Java Spring Boot Framework. To start with, we must install the below software and SDE to run the…
NEW BUTTON I ADDED TO EXPORT THE GRID, DOES NOT ACCEPT THE FILTER SETTING
Hi guys. previously, my task was to add a new button to a dashboard, that include an export action. 1) now this is completed because of your help. 2) this new button exports all the data and this is problem 3) new button and included action does not accept the grid filter setting, and the export is always like everything…
Import Action issue
Hi Anaplanners, There is something I need an assistance. I have created an action to import the data, and the Module is multi-dimensioned. During the creation of the action one of the dimension "Match on Names or Codes" is disabled, which means by default we have to match it manually. Can anyone please let me know why the…
Designing a Better Upgrade Experience: How Customers Helped
As a Master Anaplanner and the Extensions product manager at Anaplan, I'm excited to share today lessons learned from building a better Anaplan product, how our users have contributed to our decision making, and how you can apply those principles as a model builder for your community of Anaplan users. In August we launched…
Text Encoding
Hi Anaplanners, Can you please guide me which Text Encoding should be used while import, when the data set have some data in Chinese Language. Thank you!!
Excel Add In - Add Properties Similar to Labels Tab when exporting out of Anaplan
It would be great if you could add properties in the excel add in, similar to how when you export from Anaplan you can add properties from the underlying list using the labels tab.
Unable to upload Model history for Supply Chain Model after completing L2 MB Conclusion Exam
Hi Im unable to upload Model history for Supply Chain Model although Ive completed the Conclusion Exam. Is there anything missing/undone to be able to activate the link to upload the Model history file.
Level 1 - Importing Data into Product Details and Employee Details modules
I am hitting errors when importing data into both modules for product details and employee details. I am not sure if I am mapping it correctly or if I have created the modules / dimensions correctly in the first place. When I look at the exaple Model, my modules look different to the modules in the example model - I have…
Import Export Action Button
Hi All, I have a module with a time range(a customized time range created in Anaplan by the user) of 3 years(2018,2019,2020) where data is input for each month for the current year. We are providing an export/import button to the user on the dashboard to upload the data for the current year. But I am observing that on…
Anaplan Connect Install 1.4.4
I am installing Anaplan Connect for the first time. When I try to run the import script, I get the below error message. I do have the WorkspaceID in there. I also want to runt the script on a shared drive in Unix if possible. Can anyone help? Thank you. ======================================================================…
Access right for Import
Hi, End users do not have access right to import data to a module that they can edit. The module contain a selective access list. What can be the reason and how can I fix it? Thanks, Xin
add export qlik extract of an existing report to a dashboard
hello. anybody to help how to create a Qlik extract for an existing report and add this function to a dashboard? thank you.
Text to Date conversion
Hi All, My import has dates in following format: "01-sep-20" and I want to convert it to monthly date "Sep 20". I was trying combinations of PERIOD, DATE, VALUE: PERIOD(DATE(VALUE(LEFT('DATE (txt)', 2), MID('DATE (txt)', 4, 3), VALUE(RIGHT('DATE (txt)', 2)) But it seems that it won't work because it doesn't recognize…
Log for load
Hi Anaplanners, Is there a way by which I can get log history of records, when data is loaded through Integration. Ideally, the history log in Anaplan can just let us know for the number of records which gets loaded, not the one which were ignored. Is there a way to find that through Anaplan? Ideally if we manually load a…
API to get detail data for a module ID
Hello, I'm using RestAPI https://api.anaplan.com/2/0/workspaces/{workspacesID}/models/{modelID}/modules to get the list of modules available for a Budget Model. Is there an API to get the data details or items behind the module ID? I tried using the API to get the file details, but did not work.…
add a button to a board and assign an action to it
hello everybody. I am a new here. was assigned to a relatively easy task, but do not know how to solve it. to describe the case: 1) there is a working dashboard. 2) for example it has a grid and an extract button. 3) now my task is to add another extract button, to export what in the grid into a .txt file, so the managers…
Anaplan Connect Migration v1.4. SQL Server Connection (check sql server driver for jdbc)
When migrating some Anaplan connect scripts from v1.3. to v1.4. I encountered an error with my sql connection. The error I received when running my script was something like 'check sql server driver for jdbc'. I wanted to share the solution for reference as it was not that obvious. In my original script (v1.3) my…

Data Integration

Discussion List