Data Integration

Excel Add-in: Allow for the ability to connect spreadsheet interface to more than one connection
If a model is archived, then retrieved , its model ID changes. The model ID change disables the spreadsheet's data connection. Suggestion: Allow a spreadsheet connection which was created under Model ID "Example_1" to be redirected to Model ID "Example_2". Otherwise users are at risk to lose work created under Model ID…
Ability to change switch models in the excel add in
moment when you set up an spreadsheet reports pack via the excel add in you select a model to work from and are not able to change this. I would like to be able to change the model you look up to without having to rebuild the reports pack. We have a medium sized reports pack that works in the excel add in taking a lot of…
time mapping while importing the exported module
Hi all, I am trying to import data using the export file of the module which has weekly time scale. Every other dimension mapping is ok instead of the time mapping as the exported file has week as time dimension but the target has format of ddmmyyyy to ddmmyyyy. I am attaching the screenshot of the exported file and the…
Integration of Data hub & spoke model
Hi all In an implementation if I have loaded all the master data(assume product list) in the first month and in the next month we have few more products added will we load all the data again in the next month or only load additional items? If we are are only loading additional items how can we update the attributes of old…
Local settings for .csv imports - Booleans
Hello, I faced a problem when importing boolean values to anaplan as part of csv file. Our company uses localized version of MS Excel, which when saving a file containing boolean values to text/csv, keeps them not as TRUE or FALSE, but as local equivalents ИСТИНА and ЛОЖЬ. I can try to change my own excel settings, so I…
maximum number when creating numbered list
HI, Is there a limit as to the number of items you can import using numbered list? Is there a maximum number you can import in the numbered list? Thanks, Ana
is anaplan hosted in saudi arabia ?
hello I wanted to know if Anaplan is cloud is hosted in Saudi arabia ? and also is Anaplan integrate easily with SAP S4 Hana ERP ?
GENERAL Information of Anapaln is gets displayed in log file after running the batch file
Hi All, I'm fetching data into Anaplan model using the BATCH file, which is connecting to Oracle Database and fetches into Anaplan model. And i'm writting the bach execution into a log file i.e; example: Load_Fact_PR.bat > runlog.log. After the run finishes while looking at the log there is a GENERAL Information of Anaplan…
Exporting Flat Lists from Saved View from the Hub to Spoke Model and Create Hierarchy
Dear Community, I am building 4 flat lists in the Hub as below. L4 is the lowest level, L3 is L4's parent, L3 is L2's parent and L1 is L2's parent. The next step would be to create saved views to build Level 1 to Level 4 in the spoke model based on the parent - child relation assigned below. Do I need to build a separate…
Level Model 2 Sprint 1 - Create System Modules. Import Using Blueprint View or Grid View
Hi Guys, I just started with LM2, already having questions. I'm pretty sure I'll have many more down the road. In the activity, when it says SYS05 Region Details module: SYS06 Country Details module: Few questions I have: 1. Do I use Data View or Blueprint View to Import. I understand Blueprint View is used when only…
Level 3 Sprint 3 DAT04 Import issues
Hello I'm having issues importing data into the the DAT04 module form the spoke model (Data Hub). I raised a question about a similar issue i was having in Sprint 2 and got it to work but now I'm having the same issues for the second import at the start of Sprint 3! Can anyone confirm where I'm going wrong?... Thanks
RESTful API for automating recurring data loads
Hello, I am trying to understand if the RESTful API can help for a use case of automating a recurring monthly data load to a DataHub with a file that is being reloaded on a daily basis with up-to-date data. When i review the documentation, i see the need for a manual UI step to create the action, so the file is uploaded in…
Default subset setting
Suggest to add ability for model builder to change the default setting for list subsets. I.e. add option to select whether a subset setting should be true or false for any new list items added. This will make it easier and more flexible to work with subsets, and help avoid having to create a dummy module and action to…
Anaplan Connect Powerpoint Decimal Points
Hi All, When posting tables from Anaplan to Powerpoint using Anaplan Connect it is ignoring my number formatting entirely. As you can see in Anaplan they look real nice but when I import the table into Powerpoint it loses the dollar formatting and the decimal point restrictions. Is there a way to fix this? I can export it…
Level 1 Model Building - Importing Data
Hi In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, 1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) still have to be defined in the import file. 2) the mapping for the parent (Product Family) still…
Run an Import process via postman
Hello Experts , I'm new to Anaplan and currently exploring the Rest API's . I'm doing a POC on the below requirement . The requirement is to send a csv file from a SAP system to ANAPLAN using an Import action (Expectation is the details of the csv file gets updated in the import table in ANAPLAN) . Below steps have been…
Several modules in 1 dashboard but presentation issue when exported
Before anaplan, i have this excel which contains 1 tab where all the financial statements are reflected with consistent time period. When developed in anaplan the 3 financial statements were developed in separate modules and were just combined into 1 dashboard in the model. Now the expectation when exported to excel is to…
Find the import ID from file ID
Hello Experts , I'm new to Anaplan and trying to integrate anaplan using Rest API . We are sending data to anaplan for which I would need an import ID . However , I have been provided with a file ID by ANAPLAN . Could anyone guide as to how import ID can be retreived from a file ID ? Also if someone can explain the…
Certificate authentication issues
I'm finding the information in relation to setting up certificate authentication hard to follow. In the following link: https://community.anaplan.com/t5/Releases/How-to-Use-Third-Party-Certificates-With-Anaplan/ba-p/49116# there is information that says: "When you obtain your certificate from Sectigo, you can either submit…
How to synch user on the page with items of list displayed on the page
Hello, So I've been trying something I thought easy but encountered some problems, what I've been doing wrong, here is the situation : => User going on a page to enter some info about themselves in a board (grid). They open the page. They have to select their user name, as "Name", because their name in the database is…
OEG Best Practice: Best practices about Excel add-In
* General information * About this article * Best practices General information * We have listed below some of the best practices we recommend for the Anaplan product. These are based on our experience and are subject to change as we deliver new functionalities and learn more about how our customers use the product. * If…
OEG Best Practice: Best practices and tips & tricks about PowerPoint add-In
General information * We have listed below some of the best practices we recommend for the Anaplan product. These are based on our experience and are subject to change as we deliver new functionalities and learn more about how our customers use the product. * If you would like to contribute or comment, please contribute…
Data Export
Hi, How can I hide a specific line item/column when exporting? Please see screenshot. Thank you.
Change to User SSO Flag/API Connection?
Have there been any recent changes to the API or user access that would affect how our data integrations work? We currently have some cases where we have set up a connection from Anaplan to Alteryx using Basic Authentication. Over the weekend, something seems to have changed in the connection where the user account we were…
Summary in a hierarchical list
Hi all, I have a module that returns the number of people per project, with a hierarchical list in the dimension. In the "summary" I have the sum of the people who worked per iteration each time : For example: Iteration 1 = 1 person Iteration 2 = 1 person Sum of project 1 = 2 people while it's the same person. I can't fix…
How to check Application version
Hi Team, How do I locate the version of the Anaplan? I completely agree that each release/update to the platform is been pushed to all Clients through their scheduled maintenance. But where do I find the release or version number.
OAuth for Integration?
Hey community, I can't find any info on using OAuth for integrations. Is this possible, and if so is there documentation somewhere I can access? Thanks!
Level 2 Sprint 2 - Off Set Volumes for first forecast year
Hi I'm currently working through Sprint 2 on Anaplan's Lvl 2 training course and I'm having an issue with my OFFSET formula. The formula itself is correct (as the course later confirms) though it doesn't seem to pull through any data from the Volume line item? (See attached) Line item formula: IF 'SYS01 Time Settings By…
Do Read my Latest Article on Imports and Import Data Sources
Community, Here is my latest article on the best practices about Import & Import Data Sources. Please do read it. Imports and Import Data Sources as Production Data - Anaplan Community Thank You @rob_marshall for reviewing it and giving it a fine touch.
Facing trouble in importing .csv to Anaplan without Time Dimension in the Source file
Hello Everyone, Hope you all are doing great! My name is Bhumika, I am learning Anaplan. with the help of Anaplan Community. I am facing a trouble, as I am trying to Import the .csv Data File to one of my Modules. I have downloaded .CSV file from the Lessons only, but that .CSV file doesnt contain Time Dimension. How to…

Data Integration

Discussion List