Data Integration

Publish Export Actions to UX without creating a Process button
At present we can publish all other actions to UX except for Export Actions, without creating a process button. It would be nice to publish the export action without having to create a process button. We could create process button only for those which needs to be grouped together. When we have siloed export process of one…
question about 2020/12 maintanance
Hi, I can not find the news about Platform updates in Dec 20. Does anybody has information?
How to get the FY19 and the FY20 values in the same Line Item.
Hi need help on the below query. I have three line items. A, B, C where in A and B are the inputs and the C is based on the Formula. IF (PREVIOUS(C) + A + B) < 0 THEN -(PREVIOUS(C) + A + B) * 0.0386 ELSE (PREVIOUS(C) + A + B) * 0.0386 The Function previous gives the value of the previous month. But I want the value of FY19…
Support of cyrillics and possible other national symbols in Anaplan Connect
Not quite critical, but It would be nice if Anaplan connect scripts could support names of the tables/fields written in local languages for example using cyrillic symbols. Currently such names are being corrupted into ??? characters and cannot be found by the database. This makes us to create additional views and thus…
Anaplan Certificate Authentication using python
Hello everyone, We are working on POC to integrate Anaplan with the other system in the enterprise, We are using Python, and currently struck at the Certificate Authentication We are using the below Code to Test the Authentication using the Certificate (public Key), Private Key and we are following, Please find the…
Google sheets add on is live!
Delighted to see the latest addition to our Extensions family is now live. For full details of our Google Sheets Add On check out https://community.anaplan.com/t5/Extensions-Knowledge-Base/Version-Information-for-Google-Sheets-Add-on/ta-p/91919
Level 1 model building Part 10: OTH01 Non employee expense module
Hi Team, I have done as instructed in the training and imported the data from a csv file to the module. All data gets imported but there is no mapping for the "Total" column in Source to target mapping, which seems to throw result as zero. PFA pictures for more clarity. Do I need to use a formula in total column or I am…
L1MB Part 8: Data Import for REV02
Hi, I have a successful data import (Volume Inputs.csv data) for REV02 Volume Inputs Module but I don't see any data inputs in my module (see screenshots). Can anyone guide me on what I did wrong? Thanks!
8.5.2 question volume input
Hi guys my view for Rev02 is different to the one in 8.5.2 how do i fix it please? is it supposed to look like this? Learning content My Content
Export de données
Bonjour, Savez vous s'il est possible d'associer une action d'export à une vue ? Exemple : j'ai créé une action d'export des résultats le mois dernier, donc avec comme sélection "Sep 20". En relançant mon export ce mois-ci, j'ai à nouveau "Sep 20" alors que j'aurais souhaité avoir "Oct 20". Pourriez vous m'aider s'il vous…
Importing into system module
Hi Team, I am trying to Import data into SYS08 Employee Details as part of my Level 1 model builder training program, but while importing i am confused as in what to fill in the time dimension. 1) Since they are flat modules so time dimension should not come, so is that my mistake? do i need to remove time dimension from…
Does anaplan support inbound and outbound REST integration?
Hi, We are using Anaplan API to integrate with other systems today. The process exports and import CSV. As we are trying to build the next version we are looking at options to use REST services with Anaplan APIs for both inbound and outbound services. Let us know if Anaplan can accept JSON name/value pairs for inbound and…
Level 1 - Lesson 7.2.1 and Lesson 7.2.3
Hi I am stuck trying to import data from the Product csv file and the Employee csv file. I think I am doing the mapping wrong. I tried all different combinations but failed. I have attached the screenshots of the messages I have been getting. I would appreciate some help. I can't see any imported data in the modules.…
Anaplan Certification Learning Path
Certification Learning Path At Anaplan, partners and customers are an extension of our team. Together, our teams ensure an elegant first deployment, from which customers can build as many additional models as they need.Anaplan partners are: * More customer-focused than ever * Empowered * Accountable * Certified to use…
Level 1 Model Building
I'm having problems on section 7 importing the file for SYS006. I believe my issue is with the mapping of the Time. I'm also having issues with SYS08 on seeing the data after importing the data. It is showing all 111 records did update with no errors. Any help would be greatly appreciated! Thanks! Terri
Import Saved view into list
Hi All - I am new to Anaplan and sure missing something obvious in implementing this use case. Could you please point me what I am doing wrong Use case: Create a button in dashboard for admins to add new Regions. As soon as a new region is added it should be saved in a list Here is what I did 1. Created a module (INP01…
Anaplan connector 3.1.0 for Mule 4 Integration
I am getting below when we use load data Anaplan component for model and workspace. Can some one help on this? details" : [ { "localMessageText" : "Import into FDL001 Data Hub - Casework module failed: The dimensions in the target module do not match the import definition.", "occurrences" : 0, "type" :…
Name an action on set up
I would like the ability to, when setting up an action initially, give that action a name that would be used in the Actions section of the model settings library and indicate if it is recurring or single use. Then by running that action it would either be kept with the name given - recurring - or be cleared from the…
Incremental data export to interface (informatica)
Hi All - I am looking for design suggestions to below the following use case. Please guide me . Thanks 1. We have a module for employee - role mapping (1:M) 2. Planners have an option to change employee role (add / delete) 3. There are other downstream systems looking for modified employee -role mapping data. Hence, the…
Level 2 - 3.3.3.2 - Dimension problem for Import data from Data Hub model to S&C model
Hi all, I am working on this task from Level 2: I have the following DAT04 module in the Data Hub model which was successfully imported from csv file called Weekly Safety Stock.csv (attached here): The same module in the S&C model is this: And I can't import the data from DAT04 from the Data Hub model to this one. It looks…
PowerPoint Add-in: Installation requires elevated privileges
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…
Anaplan Data Export using Cloud ETL - Snaplogic
As per the Business requirement, need to export the data from Anaplan (Not Manual). To define this, we used Snaplogic cloud tool to extract the data and do data manipulation by using Anaplan Read Snap. We can configure this Anaplan read snap in two ways 1. Basic Auth 2. Certificate + Keys based on above information, we can…
Mule4 with Anaplan Integration
I am using Anaplan connector 3.1.0 and trying to access execute import streaming. I am getting below error. Looks the issue with user credentials. Any help would be much appreciated? Message : Authentication Failure. If you're unsuccessful after multiple attempts, your account may be locked. If you are using the Anaplan…
Power BI and SSO?
Is there a possibility / workaround to use the new Power BI connector as an SSO user? It seems only exception users can login as described in the documentation. Most customers I work with have a SSO only policy. Would be great if this is also an option for them, like with the Excel Add-In.
Anaplan to Qlikview Connection
Hello Everyone, Is there any API connector available for Qlikview? I want to import data directly to Qlikview from Anaplan Modules. Thanks, Sandeep
Anaplan Way - SOW and Foundation Phase
Hi I am in Foundation phase of the Anaplan Way and realise most of the work is done in this stage. I am curious to know how do you set a budget for the project in the Statement of Work which is done prior to this phase without the activities of the Foundation phase? I realise through previous experience you will be able to…
Image Link on share folder
Hello everybody, I would like to insert a picture on a page. For that I created a text link Line Item. This link is connected to a picture on our MS Teams share folder. Even though I do have the access to this Teams folder, the image on the Anaplan page will not be shown. Can somebody help me? Many thanks
Excel extract in attached format
Hi All I want to take extract from new UX grid in attached excel format. This template has a special requirement of showing cells name which appears in drop down option highlighted in yellow in attached screenshot at top left corner. So when we select a value from drop down it refers to a particular cell in the sheet. Do…
Filter on Imports
An option to filter on imports would be a nice to have feature. That way model builders will have an option to pre-process data instead of making a process to prepare the data after importing to list.
Anaplan stops during large imports and processes
Recently I came across and issue where Anaplan users won't be able to work if another user is importing a big file or running a process. it was reported by users that during those time Anaplan stops responding and the dialog box appears which says some user is making changes. Does anyone faced same challenge and what can…

Data Integration

Discussion List