Data Integration

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…
Re: Sorting within the archive
Both will be useful. Especially with multiple workspaces and archives, sorting through hundreds of models is time-consuming, especially because the scroll selection form cannot be maximized. Going through the archives for an old Datahub Model for a new model builder course is an inconvenience for a number of clients and…
multiple files upload in random order
Hi, I have a question with multiple file upload in a Process. The Process has A,B,C,D Action and the Action is sorted. A Action needs file a. B Action needs file b. C Action needs file c. D Action needs file d. But when I push the Process button, the place where upload the file is ordered random like below. b a d c How can…
Power BI
Any reason that the Load button remains disabled after previe
Data Import From Module 1 to Module 2
Hi Experts, I have a question. I have a module, lets say, Module 1, in which I have included 2 lists, Time and Version. Through this module, user enters data. I have another module, let's say, Module 2, where I have same 2 lists and time, but I do not have version in the second module. I want to copy data from the Module 1…
Level 2 Sprint 2 Model Calendar question, data not showing
Hi everyone, I followed sprint 2 step by step until I found out my data was not showing in DEM03, so I was searching for recommendations in the community and tried editing my model calendar. However, I think I messed up because, after a few changes, even my DEM01, DEM02, and DAT03 aren't showing data anymore. I tried…
Things to consider when building a robust import action
Import actions are foundational elements of an Anaplan model. Import actions can be scheduled via integration or can be called on demand via dashboards within an Anaplan model. Imports could happen from different sources such as lists, modules, saved views, and files (CSV, TXT). Import primarily import data into target…
8.5.3 Volumes Data Import REV02
Hi, I'm having a problem with the Time tab when importing the csv file. Is there anything in addition anyone would like me to provide to get a better idea of the problem?
Transactional APIs documentation
I'm so excited about Transactional APIs. But I can't find any documentation or technical description of how to use Transactional APIs. It would be nice to have something like that https://anaplanbulkapi20.docs.apiary.io/#
L1 and L2 Model Building Exam Certification Expiry date
I want to know the validity teure or expiry date for L1 and L2 Model Building Exam Certification which I completed in October 2020. Also tell about L3 certification validity. There is no expiry date written on the certificate.
NUX Export Labels
In the current UX, you can include property labels when exporting. I would like this feature to be available in NUX as well.
Side-by-side Chart in classic
Is it possible to publish two pie charts side-by-side with same source module with 2 separate views, but each one filtered on a different value. The goal is to see pie chart side by side to show product % under two different regions, as an example
Copy data from 1 Year to Next 2 Years
Hi Experts, I have been trying to test some scenarios in Anaplan. One scenario is I have to pick Actuals from Last Year for all periods and copy them to all periods to Current Year and Next Year For instance Current Year is 2020 Last Year is 2019 Next Year is 2021 Data of all periods from 2019 must be copied to all periods…
Ability to automate exports to PDF
As a model builder I want specific export to PDF to be saved in the list of exports so that a process can be created to group them together and run specific export to PDFs from dashboards in one go. I will know this is successful when I will be able to create a process and group a series of PDF exports together, which can…
Importing With Varied Dimensions
Have you ever faced a scenario where you wanted to import the data from one module to another with a different set of dimensions, and you were not able to successfully achieve it? Usually, such type of data movement can easily be achieved through formulae, but in some cases, writing formula might not be the solution—for…
Level 2 Sprint 3 INV 02 Country Summary
Hi, Here is my work till now for Safety Stock Flag Count I have used the SUM formula to calculate the Safety Stock Flag Count refereeing to Safety stock exception from INV01 module and Module SKU details line country made in. My INV01 Safety Stock uses Ending Inventory and Safety Stock target (IF--- Then 1 else 0) In the…
Data Import
Hey I am having trouble with level 1 importing employee data in syso8 it says the following: Import into SYS08 Employee Details module failed: The column headers in the file you are attempting to import do not match the import definition.1 Line Item identifier(s) ("Active?") were not mapped and…

Data Integration

Discussion List