Data Integration

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
Ability to add dimension headers in exports
There should an option to add the dimension header that are placed in rows while exporting by end user using the export option is grid. For example if I am using the SKU list as the row dimension and user is trying to export the data from the grid published in pages, there should be an option to get the SKU as the header…
Anaplan Connect concern
Hi, I am currently having issues with my script using Anaplan connect and I hope someone could help me with these: 1. How to do a loop in a file directory in Linux? - I have this file directory where all my files are starting with Test prefix (Sample: "Test1, Test2, Test3"). I should be able to run all Test*.txt items in…
L2 Sprint 1 G2 import from SYS06
I am trying to import SYS06 data into the G2 Country List. I have reloaded my Country flat list. When I ran the import this is the result I got:
Mapping error with dates
Hi, I'm getting a mapping error with my dates because they are not formatted identically. How can I fix this without going in and mapping each date to one another manually? Thank you Pics attached
L2 Sprint 1 G1 Import from saved view in SYS05 Region
I have been trying to import the saved view in SYS05 Region and I keep getting errors and I don't know why. It seems like there is a disconnect between what is in my G1 list and SYS05 Region file. Thank you for your help.
8.3.2 REV02 Date Upload problem
Hi All, I am uploading data into the Level 1 Practice model for lesson 8.3.2 and am having trouble mapping dates- the format I am using is showing invalid, even thought I have selected the periods>YYYYMM format. Any troubleshooting ideas would be appreciated!
Sort function missing "OK" button
Hello, I am trying to complete Activity 12.4.6 in Module 12 of Level 1 Model Building, but my sort function is missing the OK button to implement by sort. I've tried restarting my browser and computer, but no luck. Has anyone else run into this issue?
PowerPoint Add-In
Hello, Is there a reason why all the saved views from a deployed version do not show up to add as a connection in the PowerPoint Add-In? I am unable to select a module that I want to export to PowerPoint.
Setting chunkcount for export actions
I noticed that every time I save an export definition, the chunk-count definition is set to 1. However other files created earlier have their chunk-count set to 0. Is there a way to select the chunk-count definition when creating an export action? (small file, no need to chunk. And only files with chunkCount 0 or large…
What should be the date format for jan-20 while importing in to lists
In the attached source file how to import in to the list with format jan-20 and what should be custom fixed position....
Anaplan and Google
Hi Anaplan community, Last month, Anaplan published an interesting video about Google Cloud. I wanted to learn the study case or training materials that explain Anaplan functions in Google Cloud, AI & ML. I need advice for the Anaplan community, please. Thanks,
L3 MB Instructor Led Training
Is there any instructor led L3MB course that I can purchase?
DigitalCPX 2020: Expert Advice: Anaplan API & Python w/ Christophe Keomanivong
Fully on board with Connected Planning? Looking at expending your sources to the world wide web? In this session, we will illustrate how to use Python to import data into Anaplan from any remote source. https://www.youtube.com/watch?v=MyhxirGAGI8 We will focus on getting started using Python as your steppingstone for…
Number of Actions assigned to Process
Hi All, Is there any limitation of numbers that have to be assigned to a process? Ideally how many actions a process can run via Anaplan? Thanks, Aish
Delta load to Anaplan with informatica cloud(hyper connect)
Is there a provision to load only the change or new data instead of importing the full file to an Anaplan module in using Anaplan/Informatica Hyperconnect?
Anaplan with google cloud/ Apigee
Hi Anaplanners! I was curious to know if anyone has any exposure on building Anaplan models integrated with Google cloud/Apigee. I was wondering to know if there is any native connector between Anaplan and google cloud /apigee. If there is not any connector, does anyone know what should I do in this case? Thank you!
Fail a process if any subsidiary action contains errors
I would like the option to fail an entire process if one or more actions within that process contains errors. For example, if any errors exist when updating a list, I do not want the next import to run that loads properties of that list into a module.
Level 2 badge
Hi I completed my level 2 on 23/02/2021( attaching the certificate for proof) still I haven't received my badge. When can I expect the badge to get issued? @Misbah
Anaplan Connect Error
Hi All, I have an issue while uploading the file via Anaplan connect. Following is a snippet of the error. > > _2021-02-26 17:35:07 INFO [c.a.client.Service :83 ] 1532 |-- > Initializing Service..._ > _2021-02-26 17:35:07 INFO [a.BasicAuthenticator:26 ] 1532 |-- > Authenticating via Basic..._ > _2021-02-26 17:35:11 INFO…
Level1 Model Building: Import into DAT01 PL Actual and Budget module failed
Hi All, I am facing issue on importing data into P&L Actual and Budget Module For your information, i have mapped time as Period (YYYYMM) Import into DAT01 P&L Actual and Budget module failed: The column headers in the file you are attempting to import do not match the import definition. Have attached mapping and error…
Scheduling refresh in Power BI
I am using Anaplan Connector for Power BI to export data from Anaplan to Power BI, instead of manually refreshing, is there a way to schedule the refresh in Power BI ?
Import failure based on module cell count?
I have just submitted this to Anaplan support, but wanted to run it by the Hive Mind. Any insight into what's going on here would be appreciated. I will update this thread with any answer I receive from Anaplan support! We had a very puzzling issue last week that prevented loading of data. We resolved the issue, but the…

Data Integration

Discussion List