Data Integration

Anapaln L1 TEST
I have imported SKU list what will be answer of naming part cant get a clue about it ?
activity 7.1.3 Mapping
I am stuck with the activity in Lesson 7, mapping. All my mapping attempt is wrong and I think I understand it. I don't know what is wrong.
Marked as (Fixed Target Item) in the Mapping tab; please specify a value (ERROR)
I'm trying to complete my Level 1 Model Exam and continue to get the below error: Marked as (Fixed Target Item) in the Mapping tab; please specify a value I searched the Community, and have not found any help/solutions. Additionally, I tried to do the same task in the Level 1 Model File that was given in the initial exam…
8.5.3 Activity: Import Data into Volume Inputs Module
Hi - I am trying to map an import into a model and my results are calculated as zero. I attached my mapping and the results. Can anyone help me what is the issue with the mapping please? Thank you so much!
Anaplan Model Builder Level 1 7.2.2 Help
Hello, I imported data into the SYS06 Product Detail module and it went through smoothly while also aligning with the picture show in the "Check Work" section of the Lesson Plan. I tried to enter the formulas for the same module and I keep receiving an error. The error suggest that I have no hierarchy attached to the lists…
Can you take a Copy of a model at a point in time without having to restore it?
Hey team, I want to take a copy of a model at a point in time and see the data in it without restoring the current version model to that point. Is this possible and if so how do I do it? Regards Padraig
Export list updates
Hi Everyone, I have a problem statement in which I have to export the updates in list items. Here is a scenario to picture the problem:- I have 6-10 lists in my model and each list has 6-15 members. Let's say, user updates a list item in one of the list then I want to export this information that which list item was…
2.3.10 Activity
Hi, I am stuck at 2.3.10 Activity: Create Demand Forecast of Level 2 - Sprint 2. I think I am doing somethings wrongly in SYS01 Time Settings by Week module. I applied for FY21. I don't understand first line item has not displayed in Boolean. Why didn't my formula work? DAT03 has not any value because of SYS01. I need your…
Upload same Idlaoder with differents amounts
Hi everyone, Can you help me with the next problem, please? I need to load some information and the criteria for upload is the Idloader list. I am testing what happens when uploading two rows that have the same Idloader but different amounts and I am waiting that Anaplan to upload just the last amount. In this case, if I…
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

Data Integration

Discussion List