Data Integration

Anaplan Integrations
Hi, Requesting help to understand about Azure and Anaplan Integration. Thanks in advance!
8.5.3 Activity: Import Data into Volume Inputs Module
Hello! I have a question - when i created the modules, i deleted Time from dimensions. How to add it back after the module is created? Now I have this But i need to have this Thank you in advance! Anton
Not Able to log in to my Anaplan Workspace
Hi Team, I am not able to login to my Anaplan Workspace. I have attached the image of the error. Please, guide me who's help I can get and from where. Regards
Automatically remap line items in import actions
As a model builder, i would need that in the following conditions : - an import mapping uses manual mappings for line items - the source line item name(s) are changed in the source module, that the manual mapping would be updated automatically or alternatively that we get a blocking mechanism that alerts us upon trying to…
Duplicate line items while importing
I am trying to Import data from a .csv file into an Anaplan module. The line items in the .csv file and in the module are distinct. The module uses a list subset. These line items are in the first column. When I try to Import there are 2 line items that are repeating when I go into the third tab to map individual line…
Importing CSV with Name & Code on file
For one of our models we have an import routine that brings in the below for a variety of reasons it needs to be in this format. As there is both name / code when we go to import it doesn't actually make it because the of there being the name column and they're being used as time. Beyond deleting the name columns prior to…
Anaplan Powerpoint Add-in
Hi, Is there a reason why all the saved views from a deployed version do not show up to add as a connection in the Anaplan PowerPoint Add-In? I am unable to select a module that I want to export to the PowerPoint.
Importing Multiple Rows based on a Quantity Value based Cell?
Hi Everyone, I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item? For example, if I wanted to create 5 new employees that will have the same salary and reside in the same state and cost center. Is there any techniques that…
Import and Automate Current Date Import to Anaplan Using Python
Connect or Python Summary As a supply chain Anaplan data integration modeler, you might be asked by your business partner to display actuals for elapsed periods and forecasts for unelapsed periods. If you are not using the current period, which must be manually updated by a workspace administer, and you want to automate…
Ability to integrate with CI tools
While Anaplan is great as a simple development platform, it lacks Continuous Integration-related features as a full-fledged development platform. There are many excellent CI tools in the world, and they are very effective in improving development efficiency and maintaining quality. Reference:…
Backup - Archive PY cells
Rather than functioning towards excel for the previous year / excluded year data to save for future. There must be a process which will archive the data as soon as year got changed in TIME settings (with the warning popup) within given model and ready to refer as and when require. [Benefit]: Get rid of multiple models…
Timeout error while CA Certificate Authentication for file Import.
Dear Expert , I am trying to Import Data into Anaplan via Anaplan Connect Script. I am trying to Import with Certificate based authentication in Script but getting time out error as shown below. Could you please help me with the solution to deal with .Is there any ways to see the error log?? Script : @Echo off rem For…
Module Views Not Appearing in Excel Add ini
I created several modules with specific views to be used in Excel via the Excel Add-in. When I open the Excel Add-in 4.0, I can see modules and views but many are ones that I had either deleted or remained in Anaplan. The ones that I created today are not appearing. I am only setting up "read only" connections to the…
Drop down selection lag
Hi all, We have a list that is ~1500 items long. We've published this as a list formatted line item because users like to have the drop-down selection for various reasons, but we've noticed there is ~2-3 seconds of lag before the list opens. We cannot reduce the selection materially with a dependent list and we'd also…
March 01- March 07 what has to be covered.
Hi @noelle_murphy , Were we suppose to cover The Anaplan way in the current week as there is no announcements. Please confirm if I have started the correct course from the learning center below: Other And I need to connect with someone as I am not able to solve the DATA02 SKU related problem please advice. Thanks and…
Level 2 Sprint 1 DAT03 cells blank
I am at the end of Level 2 Sprint 1. I am going through the checklist to make sure everything was completed. When I got to DAT03 I noticed there is no data in any of the cells. When I did the first import, there was data there. So, I reimported the data from Historic Volumes and it said the import was successful, but I…
TIP: Anaplan API with Postman
Doing some work with the Anaplan API recently I found myself annoyed with having to copy/paste the tokenValue you need for each subsequent command after authenticating via https://auth.anaplan.com/token/authenticate. Below are some tips I found on how to automate it: * Create yourself a Postman Environment and store your…
Automate Process Running in Anaplan Model
Hi Guys, Is there an easy method of scheduling process running in Anaplan? Our consolidation process is not live and requires data pushes through inport actions within the model - that we need to run at certain hours. Basically we would need to open Anaplan model and run the process that we can even attach to a welcome…
3.3.5.1 Create Inventory Ordering Module Beginning inventory
My beginning inventory is in Negative. Why is this happening? Is there anything wrong with Beginning inventory or ending inventory formula? I have attached screenshots.
Lesson 2.3.9 Running import - Process 9
Hi I got this error when I run the process. I noticed there are two source models for the same action in the supply chain model. One created by Anaplan and another created by me when I built the Data Hub model. As follows: Then I tried to map the source object model I created when I completed the Data Hub model to the…
Level 2 Sprint 1 DAT03 Historic Volumes error
I imported data into my DAT03 and it populated all of the categories, but when I compared it to the screen shot I realized I have data in my Jan19 column and it's not in the Anaplan example. How do I get the data out of that row? I reviewed the previous steps about setting up the time range and it looks like what they…
Level 3 query
Hi Friends, I am not able to understand the exact requirement of the question. What is the total sales target for the medium sales account in Canada?
L1 Model building - error when import data to modules
Hi, I am still in the training course and now in lesson 7.2.3 When I tried to import the data to the module, I couldn't map most of the fields and got a lot error message So basically all the empty fields are not catching up with the source file. Does anyone have similar issues? Thanks!
NEW UX - Export Boards as PDFs process
Hi Anaplan, It would be great if the NEW UX had the capability to export boards as PDFs for reporting. Many customer are asking for this as they have previously created many reports using this in the OLD UX so would like to see the functionality in the NEW UX. Thanks, Usman
Regarding CA Certificte - Ceretion of Encrypted Private key from Recieved S/MIME Certificate.
Dear Expert , To work on Import Script, we are going by Certificate based Authentication . So while Generating encrypted private key from received certificate.pfx, I am getting below error . Though I was able to generate the Public key and unencrypted Private key . I followed the Anaplan Connect Guide while creating…
Power-Point addin
: Hi, Please help me out with this error while refreshing data in Anaplan Powerpoint Add-in. Exception details: level: 0 message: Sequence contains more than one matching element trace: at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate) at…
Error when updating hierarchies with list items
I'm trying to update a list hierarchy from a module, which I have updated with an import file, and everything seems to be working just fine, that is, my list items are updated. However, since I have the same list item occurring several times in my import file, and also in the module I import from, I get the error message…
Search an item in Module in a specific range
* Module dimension: Department, Country * Line item: User Name. (Formatted with a fake User List) I'd like to get all unique User Names from a specific Department 'ABC' and ALL Countries, with these unique user names, I'll able to build a list. I tried to create a subsidiary view in the module, dimensioned with fake User…
Excel 3.0 Views missing
The new Excel add in is a great improvement on the previous version. However, there is one big loss (as far as I can tell) which makes it harder to use. You cannot select a view, and must always select a full module. This means that if there are 'working' lines in a module that you dont want Excel users to see, these are…
Intergration - RDBM to Anaplan
Hey All, Can anyone share, how we can pull and push the data from RDBMS to Anaplan. What will be the impact on performance ? Thanks In Advance @Misbah @roshinrasheed

Data Integration

Discussion List