Importing and Exporting Data

2.3.9.2 Update Historic Volumes for Baseline Forecast_i am not able to get data
Hi, I have used below offset formula. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 I am getting all zeros also my volume line item data got blank. At first I was able to see data. But now both the line items showing data as 0. Could anyone please help me. refer attached…
Level 1 Exam Activity 4
When I am importing the data nothing seems correct. Role is completely missing. Please help I am on activity 4 right now.
3.3.3.1 Create Distribution Center Parameters Module
Hi everyone, thanks in advance for any help! I have attached several pictures including my blueprint view and grid view of each module. I believe I have the import set up correctly, screenshot attached. I am receiving "Invalid data or timescale identifier" errors for 371 entries, but I am getting 1484 Updated entries when…
6.6.4 Activity: Add Time Settings by Year Module
Hi there, I am having trouble with this activity. Instead of showing the years side by side, it shows them on separate pages. The second picture is what the module should look like. I have also included the blueprint view. Any idea what I'm doing wrong?
2.3.9.1 Import data into DAT03 Historic Volumes module_unable to run_getting below error
Hi, I am not able to pull the data into supply chain model. Could anyone tell me adjustments in order to avoid errors in the import process. I am getting below error screen. Thank you,
Integration acknowledgement to Anaplan
Hi, In the scope of an integration from Anaplan to a target system using Mulesoft, I want the best and most efffective way to perform "Ready" and "Success" flags. I explain : Mulesoft flow will use a scheduler to connect to the Anaplan connector at a regular timing. If the Anaplan user performed a new calculation and have…
is there a way to forecast expenses by vendors?
I'm trying to forecast the details by department's with their vendors, like for example Anaplan as a license vendor I want to forecast by that line of expense as part of the Technology department that eventually will roll up to the Software expense P&L as part of the total company. Not sure if I need a list for Vendors and…
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…
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…
More information about imports in transactional api
As an application and integration builder i need to have more information available through the api regarding imports : - The information data source id : currently seems to show up only on files and not on other sources - the source model id (workspace id / model id) - the target object id (list, module...) - the detailed…

Importing and Exporting Data

Discussion List