Importing and Exporting Data

2.3.10 Activity: Create Demand Forecast - Workspace Size Limit Issue
Hi, I'm trying to make a new module with these required lists, but I couldn't do that apparently due to the workspace size limit. Could you guys please tell me what to do? Thank you in advance.
How to shorten names for a data flat file you use t import into List
Hi, I have a List that will get populated once a month from a flat file that is given to me from IT. The only issue is that some of the naming in the flat file is too long to bring in as a List. And if the name is too long then Anaplan will not bring in that name into the list. I want to know what is the best way to fix…
Export data using Cloudworks
Hi, Is there a way i can use CloudWorks to export data without using the connector? I cannot select the Target folder where i want to save the extracted file. Thanks in advance for helping. Regards, Tom
How to remove List Subset Item from Labels in Export
Hi I have an export from module, where one of two dimensions is the List Subset Item. When I want to export it as Tabular Mutliple Columns - I see in the Lables only name (connected to the First Dimension). I need to removed List Subset Item from my export, like other labels. I wonder how to do it?
Chunks Error
chunksArray = jsonResponse["chunks"] KeyError: 'chunks' Hi all, I have connected with Anaplan through API with help of Python . Basically I am Exporting file from Anaplan for getting suggestion But now If i am using my credentials and my Model it is working fine. But for others it showing error above pasted. Chunks are…
4.8.2 Activity: Import Data into E2 Employees# List - Struggle to import
Hello, I am struggling to import the employees list during the 4th activitiy. I face the error in the screen below ? Is there something missing ? Something I uploaded in the wrong way ? Thank you for your help. Best regards.
Stuck on model 1 exam activity for question 3
Hi, I am on the exam but noticed my DATA02 SKU Volume only populates for January alone. Every other months do not populate. I have tried tracing back my steps but still no positive result. I have checked if someone else had the same problem within the community but no help still. Screenshot below Plese a
SYS06 7.2.2
Hi! I've been trying to figure out what went wrong when importing products.csv, but I haven't been able to. Every piece of information imported correctly, except for the codes for the first 5 candy bars. May someone assist me with this?
Stomped Level 1 11.3.2 Activity: Import Data into P&L Actual and Budget
I am stomped at Level 1 11.3.2 . Invalid versions, Invalid date or timescale identifier Can someone please help me? Thanks
Mapping Volume Input -Lesson 8
I have done all the solution here for lesson 8, Activity 8.5.3 - Mapping Volume -input. I am still having error. I attached my screen shot - please help
Data Copy for more than 10k rows of a single line item.
Hi Community, What are the possible ways to load a single date into (Date Formatted) line item which has more than 10000 records. I know the few drills which is 1) Importing manually by creating a csv of that single line item with multiple rows 2) Copy down method (applicable only for 10k rows only) Does anyone have any…
Transactional or Bulk: When to use which API?
* What are we talking about? * What’s the differencebetween bulk and transactional? * When to use Bulk API * When to use TransactionalAPI * What else can Transactional API do? What are we talking about? See our refresher here. Anaplan has a set of APIs that allow for a developer to programmatically interact in certain ways…
Ability to Import via .CSV non-US formatted dates
Looking for an enhancement to allow non-US users that don't use US formatted systems to be able to upload .CSV files that contain dates. Currently any non-US formatted files will cause an incorrect date to be populated without any errors or notifications.
3.3.3.2 Importing data into DAT04 module
Hi, I am trying to import the data from the Data Hub model DAT04 Distribution Center Parameters module into the Supply Chain DAT04 Distribution Center Parameters module. My issue is figuring out the correct time dimensions. I am initially going with YYYYMMDD. Could someone point me in the right direction on what to think…
Export Top Level item using Tabular Multiple Column
Dear Anaplan Community, I would like to export data using Tabular Multiple Column (to use it later as export action in Power BI with Anaplan Connector), including the top level item of my list. In the export definition, I did NOT select "Omit Summary Items", however, in my export I don't see the Total row. What am I doing…
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…

Importing and Exporting Data

Discussion List