Data Integration

New API Error 504 - Gateway Time-Out
Hi community, Myself and our client @gmazzonegp are running into a new issue with an API file load that has arisen with no changes to our imports, the file structure, the size of the file etc. Problem: For the last 6 weeks we have been receiving error 504 - "Gateway time-out" from API when trying to upload a file using the…
L1 Lesson 7.2.2
I am not sure why the product family row is showing codes instead of product names. I thought the issue was because of branches but when I removed them it made everything worse. Any suggestions on how to fix this issue?
1.5.2 Activity: Import Data into Beginning Inventory_not getting correct data after import
I have downloaded below inventory file. Performed below mapping. Still I am not getting correct output( Beginning Inventory column). I am getting below output. Could anyone please help me.
Postman API authentication
I have been trying to get an authenticated/authorized API to work and I just am not able to do it. Can anyone help with what I may have wrong here? This is the detail from the Console: 11:30:10.374 POST https://auth.anaplan.com/token/authenticate: { "Network": { "addresses": { "local": { "address": "...", "family": "IPv4",…
L1 Lesson 6.9.3
Hello, Is there a way to delete the All Products column? I can't delete it from the Products list because it is considered a top level item somehow. I'm not sure how it got there.
Importing into a Numbered List from a saved view
Hi All - I feel like I am missing something simple here. I have a saved view from my data hub model that I am using to import into a spoke model. I am setting up a numbered listed in the spoke model b/c of duplicate data. I have set up a display name and have successfully imported the data from the saved view. What I do…
Export Action to Power BI
Hello! I´ve created an export button to export a table from Anaplan to Power BI using Anaplan Connector. I can see the table in a list of export action in Anaplan, as shown below: However, I´m not able to find this export in Anaplan Conector in my Power BI. I search the right way to get to the table but this export name…
Level 1 Lesson 4.6.8
Hello, Any advice on how I can get the codes to show in the code column? I'm not getting any errors when importing the data.
10.2.4 Import Data Problem (Bonus Percentage)
I imported the information. but the bonus percentage section looks different from the original, how can I solve it.
Importing Hiearchies
Hi, I'm trying to import our company structure, the structure is made up of Department > Division > Cost Centre > Budget Some items in the Division list have the same name as their parent and are being rejected e.g. Marketing > Marketing > Brand > Brand Budget Does anyone know how to resolve this? Thanks
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, I am following all steps and in 2.3.9.1 Import data into DAT03 Historic Volumes module section. It says : * Run Process 9 Import Data from the Hub. However, Process 9 doesn't show in my Data Hub. Did I miss something? Could you help me ? Mark
Import takes time with filter view
Hi, I want to know filter function. I run Import Action from saved view which filtered by Lineitem. But It takes long time. The point was module pivot. View A and B was filtered by same Lineitem. But it takes shorter set source module as ViewB than ViewA. View A ProductLocationTimeAmountAX1/11AX1/22AX・・・3BX1/14BX1/25BX・・・6…
Anaplan Connect Error on certificate usage
Hi, I am facing the below message in command prompt (highlighted in blue) while trying to run a batch script with certificate and private key. Certificate and private key is already placed in "E:\anaplan-connect-release-3.0.0\Certificate 2022" (-a|-action) (<id>|<name>): select an action by id/name (-P|-processes): list…
Coupa -> Anaplan
Has anyone seen any documentation, white papers, materials on integration with Coupa? Maybe more so from a functional, use case perspective?
Impact of failure dump on import duration
Hi all, I remember reading a best practice somewhere (not quite sure where) that if possible an action should return "Success" by default rather than "Process complete but with failures", as failure dump generation lengthens the import duration. Just wondering if this is the case and if anyone's aware of any correlation…
2.4.4.2
I do not understand where I have gone wrong... But my module DEM03 Demand Forecast seems not have pulled the data even though I have given the formula in the Growth rate line item... Could anyone please help me with this? My module doesn't match with the 'Check your work' screenshot which is attached...
Python binary file is very slow in execution
Hi all, I have written a script on Anaplan connectivity through python. Now I have converted that python script (.py) file to binary (.exe) file with the help of pyinstaller and --onefile But on launching that '.exe' file, its taking too much time approximately 10 minutes or more than that. Any suggestion please...
Running Anaplan connect
Hi Guys, While i was running Anaplan connect ,I am facing the following error. Can you please do needful Request details: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target executing…
Importing fata
I'm unable to upload data for utilities and total line item plz help.
Impact of Exports
Hi, Hypothetically, if I have an export running for 2 hours, what all does that export block in the model? I reckon users can still navigate around in the model/app but they won’t be able to run any action or make any manual changes (user inputs). Is my understanding correct and are there other things the user can’t do?
Can't map account to existing model
Hi, I'm trying to map an Account to another Account in a different workspace but I can't seem to be able to map these as the Account field is greyed out. Does anyone have a suggestion on what to do here? Thanks, Tom
LV.1 Exam Question 4
I've been stuck on this exam for too long trying to figure out where I went wrong. I thought I had the correct formulas but it is not producing the correct values to this question. For the medical cost of the Finance team, I used 'EMP03 Employee Drivers By Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department,…
Manage the saved view - Display by all modules
Hi all! It would be great if you could refine the "Manage Saved Views" feature and add the ability to view saved views of all modules at once, with the fields: Saved view, module, use in action, note. Saved viewModuleUse in actionNoteName of the saved viewThe module in which the view was createdProcesses in which the View…
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello Everybody, I get this error when i lunch the process, can you help me please ? Best Regards,
Cannot import record into numbered list as it has a new name (#1)
Hi, I'm getting the error message 'Cannot add new entities to numbered list when matching involves name'. Attached is the view of the mapping and the datahub I'm trying to connect to. Does anyone have suggestions on this? I tried reviewing this link but I didn't fully understand it.…
Error In Mapping Data
I'm trying to complete model building activity in Sprint 1 Level 2 and facing an error while importing data from the file. Do let me know what mistake I'm making.
Use multiple characters together as the delimiter when importing
Currently if more than 1 character is used as a delimiter in an import Anaplan treats it as an OR, and looks for either individual character and not both characters together. For instance if you want the delimiter to be "|~" then Anaplan will look for just "|" or "~" rather than them both together. It would be good for…
New Lists Changing Previously Created Lists: Potential Parent Hierarchy Issue
Hi All, We are encountering issues where lists which were previously created have been changed when a new list is created. The "New List" is has the "Previously created" lists as its parent hierarchy. For example List Named "Department D2" is correct. A subsequent list called "Department D3" is created which has Department…
Reduced number of items to map to
Hi, I am trying to map 30+ columns, similar to how one of my models is set up but in the new model I can only map 3 columns. The source data is the same for both. Does anyone know how to increase this? Thanks, Tom
Anaplan Excel add-in Login Issue
Hi All, One of our business user is on 64 BIT Excel. When tried using anaplan excel add-in login, it never shows up the pick up account screen. The screen is always blank and never loads. Did any of you face this issue? If you did, what is the fix for this problem. Regards, DDYal

Data Integration

Discussion List