Data Integration

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…
Not able to get correct hierarchy : Level 2 Sprint 1 G3 Location
Not able to get correct hierarchy : Level 2 Sprint 1 G3 Location need help Attaching screenshot for reference
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.
Looking to hire someone with Anaplan SDS experience
Messaging 'Available Talent' Excellent opportunity at Symetra insurance for someone with Anaplan SDS experience. See job posting here.
Getting data from one module to another
Hi, I have two modules with project data. The first module has a dimension of serial numbers (1,2,3,4). it is not a numbered list. One of the line items is defined as a list format of project numbers. this list is a numbered list. The second module has a Dimension of the project numbers (numbered list). I need to pull data…
Data in 2 modules with exactly same lists
Hi Experts, I have a doubt. I have created a module i.e. Module 1 and also created another module i.e. Module 2 with exactly same lists as Module 1. In Module 1, have entered so many data, but that data is not appearing in Module 2, which is same as Module 1. Is it the expected behavior? where we have 2 exactly same…
CloudWorks custom load calendar
Suggest to add ability in Cloudworks to create custom load calendars. Not all data integration loads follow a recurring pattern but are instead based on custom load dates. Adding ability to e.g. specify a specific load calendar for the next 12-18 months will ensure load dates are aligned with business processes and reduce…
Export/ Import
Hi All, I have a module created in the system with numbered list in the rows having duplicate entries and time in the columns with only one line item as named 'value' in the page selector for which the user inputs the values. Request your suggestion on how to create the export and the import action button for the same grid…
Activity 7.2.3 Importing into Employee Details
Please help with data import query. My file is not loading correctly despite several attempts. Name: most rows are empty, I am not sure why only a few are bringing the Name up Same with Country only a few which also have the name in the them For Name & Country it didn't automatically map, I had to manually map - why not…
Transactional API Library
With the general announcement of the new Transactional API, I'm happy to share a simple Python library to help users utilise this new feature. This library was written with version 3.8.0 of Python, and requires installation of the Cryptography library. All other packages used are included in standard Python installations.…
Integrate Anaplan with Siri and iOS shortcuts
We now live in a connected world, and Anaplan provides us with Connected Planning—but what about extending that connectivity even further? Every day, we carry mobile phones in our pockets that are amazing in the possibilities they offer to our lives. Anaplan has a great mobile app so that you can review your dashboards and…
Finding Average using Formula
I have a table with Grade,Region,Salary of employees and i neeed to find the average of salary by region in another module and i am getting an error. I am new to the platform.Kindly guide me Kindly guide me.Thanks in advance
Extracting all line item formulas from a module
I want to extract all the line item formulas from an Anaplan module. Is there any documentation in the API to do this? I want to do this so I can run a **** diff across multiple environments.
Mapping Options for Module Import
When uploading a CSV a few more options about whether specific columns can be ignored or manually mapped (in a similar way to how imports to lists work)
Anaplan and Power BI - It's here!
Finally! It's here. For those of you that use Power BI to supplement your visualizations, you're in luck! https://community.anaplan.com/t5/Releases/Announcing-the-Anaplan-Connector-for-Power-BI/ba-p/89942 Brilliant! Nice job @MagaliP Personally, I give you the most improved aspect of Anaplan award for 2020. Am I allowed to…

Data Integration

Discussion List