Data Integration

import a column with alphanumeric into number formatted property
Hi , can you assist me in following , so i am loading a file with a column into a number formatted list property , in the csv file along with numbers some entries have text only while some entries have text along with number(as shown) , when i load this file in model , so all text lines are ignored , but somehow anaplan is…
Import from one version to another version using import
I need to import data from one version to another version - Forecast to calc version (Manual Version). This module has 4 pages - Total hierarchy, year, wave, version Total hierarchy - Total > 1st level > 2 nd level > program Version is fixed version - always to calc version Program - i want to map single program each time…
Accept Cookies Confirmation popup & Course content not getting loaded
Hi All, when even I login to the Learning.anaplan.com I see the below confirmation window pops up on every refresh inspite of providing the Acceptance confirmation. Wondering if this something local to me or anyone else facing this issue as well? In addition the course content is not getting loaded - appreciate any inputs.…
Extracting data from Anaplan with Qlik Sense
So you finally did it – you joined the Anaplan Community. So many possibilities just opened up in front of you when it comes to connected planning and finance, but what about analyzing and visualizing your data? Well, no need to worry about that because Qlik has that part covered. In today's article, we'll be talking…
Basic Auth integration failed
Hi team, as we know anaplan password need change every 1,2, or 3 month. but when i impelement integration anaplan with workato using basic authentication, and every time i get error 401, i need to change my password a couple time in 1 month. why this case it happen?, and how to fixed? Regard, Panji
MB Level 1 Lesson 11.3.4 Getting the Wrong Output
I am having an issue where only 1 cell does not match how my model is supposed to look like. It seems like "Utilities" (and subsequent line items that use utilities as part of its formula) is the only line item that is generating incorrect data. The first picture is of MY module, the second picture is what the module is…
Help with Lesson 8.5.3- Import Data into Volume Inputs Module
Please help. I've attached screenshots and don't know why I keep getting the time error message. Thanks.
Anaplan Connector for PowerBI
Hi, I have a query on Anaplan Connector for PowerBI. We are able to use the Anaplan Connector for PowerBI with Workspace Admin user logins. But when we try using this with a normal user login, connector does not fetch any models from the workspace. Did anyone face this issue earlier? Thanks in advance for suggestions 🙂…
A primer on Anaplan integration using Azure Logic Apps
Introduction With the release of Anaplan Cloudworks, this flow may be better addressed via a blob storage connection in Cloudworks, or with a combination of a Cloudworks flow and a post request to the Cloudworks API. My colleague @christophe_keom published a guide covering this topic. In my case, I wanted my flows to run…
Updated Anaplan Java Client source code is now accessible via GitHub
As a true connected planning platform committed to integrating disparate sources of data from various tools, we’re excited to announce that the source code for Anaplan JAVA client has been updated on Anaplan's public GitHub repo! (https://github.com/anaplaninc/anaplan-java-client). This code is derived from Anaplan Connect…
Import data in to the module
When I import data in to a module, is it inserted into the underlying lists that are used as dimensions while creating the module? Do the lists and modules have own storage? Any documentation would be very helpful.
10.2.4 Activity: Import Data into Employee Drivers Module
Hello All I need help, i am having problem with mapping to the right dimension line item in 10.2.4 Activity: Import Data into Employee Drivers Module. Please tell me were i am making the mistake. After mapping to the line items in my dimension the table is not populating rather it is been ignored
8.5.3 Activity: Import Data into Volume Inputs Module
Hello, Can someone explain my mistake in this data input process: Thanks,
Level 1 Model Buidler - Lesson 4 mapping source to property in list
Hi all, I'm a newbie here and I hope this isn't a stupid question (I certainly feel stupid because I can't figure this out). But can someone explain mapping when we are importing lists into Anaplan? Specifically, for each activity in Lesson 4.6, I got stuck on the mapping for each source in the list. Basically, I'm getting…
4.6.6 Activity: Import Data into P1 Product Family List Unable to import data from product families
I am trying to upload the product family data into my model in lesson 4, and each time I try I get a notification saying "Multiple files inside an upload package are not currently supported." I was wondering if anyone knew how to troubleshoot this problem.
IMPORTING OF SKU FILE
i was unable to import the file correctly
Use Page Selectors to Select Data for Export via Export Actions
As an End User I need to be able to select data for exporting using Page Selectors in the UX, providing a common navigation experience for interacting with data in Anaplan. Currently to select data for exporting I need to use selection criteria (Booleans or List Formatted Line Items) to select what I want to export. It is…
Level 2, 1.3.10.1 Import Data into G1 Region List
Hi all, I'm stuck with importing data from a saved view to the G1 region list and I don't understand where the error is coming from. Region Flat: Saved View (SYS05 Region Details, Build Regions) Regions: Import dialogue: Error message: So something's not working with the code/line item, but I don't get what it might be.…
Why do I still see source items from previous versions of upload files in the import definition?
Hi Anaplan community, I don't understand why I still see source items from previous versions of upload files listed in the import definition tab of an import action. I used file A with periods call AP01, AP02,... and used that to upload into Anaplan and save that upload as an action. Later, I changed the file and renamed…
Cloudworks - Data too Large
Hi all - has anyone ever ran into the situation where the dataset being brought in by Cloud Works is too big? Is there an error message that shows this? I'm suspecting this is the case for me. This is specifically for BQ -> Anaplan. I ran three processes, and the third one triggered was the first one done. The others have…
Anaplan Cloudworks License
Hi, Do we need a separate license for Anaplan Cloudworks or is it part of our existing package? Also can we use cloudworks to directly integrate with Big query? Thanks
NewUX view Source Module
In the NewUX, you cannot go directly to the source module. When selected it takes you to your default dashboard page in the classic version. This is not helpful for users that aren't model builders with access to everything. This functionality and the Drill to Transaction is needed in order to make the NewUX functional for…
Calculation Error for Formula
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 2 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
Anaplan Connect - Transactional APis
Hi Team, I'm trying to add new items to model list without using the IMPORT function. Facing this error - Can someone highlight where I have gone wrong with the scripts Thanks AB
Selecting Levels in Excel Add-In
Hello everyone, When using the Excel Add-In, we find many advantages such as overall better selection/filters for line items and dimensions in the Pivot & Filter section, however a major drawback of using the add-in here is that we cannot select levels like in the browser. Unless I haven't found how to do it properly,…
Save UX Export Definition as An Action
It would be great if we could save/automate dashboard exports from the UX in the same way that we can in the old dashboard experience. Right now, if we want to automate the sending of a dashboard export (a PDF), we need to do it as a saved view of a grid or build an old UX dashboard to export from. Right now, if I export a…
Bringing in Roles - Formula Help
Hi - I am trying to bring in Role. I added them as a line item in my module: Here are all the modules: And here are my lists: There is a dropdown for me to manually put in the roles, but I just don't know what to do for the formula. Can anyone please help me with how to write a formula to bring in Role?
Column Headers causing Invalid date error
Hello, I am currently working on a project that requiers the end-user to export a module, change the data, then import the exported file in the same module. However, since i'm using numbered lists, i need both the code and display name in the exported file ( code to import the data back, display name for the user). But by…
JDBC coonector > Invalid argument in JDBC call: parameter index out of range: 1
Hi Model Builders, I need your advise on this below error I tried to follow the steps mentioned in this document to build a JDBC connector using Anaplan Connect - https://anaplanenablement.s3.amazonaws.com/Academy/Platform/SA/SA_01/L08/WEB/index.html#/lessons/L_kD_rXFRzmz2kf0p4KDbsKlt3RLWk0z It seems that the JDBC…
Extracting Model Size through API
I have used the scripts set out here: Solved: API Python Workspace and Model IDs - Anaplan Community to successfully extract a basic model and workspace list. Thanks to @abhay.kanik for the good start. I have added the ?modelDetails=true switch to the Model JSON so the API send more details about models. The JSON then…

Data Integration

Discussion List