Importing and Exporting Data

Run process in anaplan from informatica
Is it possible to connect to a process as a target in informatica cloud(hyper connect) and run the process instead of individual actions?
1 4 3 2 Import Data and Add Formula
I have reached to this lesson and have been unable to import the csv file 'SKUs.csv) into SYS12 SKU Details module. Can someone advise if I should have time series as the column in the SYS12 module and should I see Time as the target (which in my opinion, should not see Time as source)? If they should not be here, how…
Change the file name everytime the user Export
Hi, Community I want to change the export name everytime I export The definition of the name whould be "Module name and Time the user selected" or "Setting name when I create the export and Time the user selected I look for the way to do, but I couldn't find it. I really appreciated if you help Kind Regard
Employee detials
Hi Team, Can you please provide me with download to the link for Employee+Detials+By +Role csv from Level 1 exam. My one was opened and I would like to get it to practice before I have another attempt. thanks Regards, Aye
Import Shipping Expenses into OTH01 Module
Hi, I am trying to import shipping expenses into OTH01 Module but I am doing some wrongs, where? Here are my screenshots: Yes, I see that the capacity doesn't match and tried hide it but it doesn't work still. Please guide me! Mark
2.3.9 Activity: Historic Volumes to Baseline Forecast
Hi, Some values should be in 'Offset Volumes for 1st Forecast Year' line, but nothing! Where am I doing wrong? Thanks, Mark
L2 Model Building - Conclusion Exam: Upload Supply Chain Model History
Hi, i'm trying to complete the L2 Model Building Exam and it is required to upload the supply chain model history. I have issue since i transferred my model to another workspace and it makes the history renew on the new workspace. How could i solve this? Because i can't upload 2 files in the fields. Thanks.
12.4.2
Create saved view for country margin but the problem is now I have notice that REV01, 02, & 03 Modules don't have any data for FY21 so the model don't look the same when I check my work, any suggestions?
Drill Through/Link External Source Mapping to a given line item
Be able to list or link to a URL the original source information when there is no deeper level. EG. In a source data module, if drill down is completed the admin has the ability to attach a URL to the source material (if it is an extract/table that was pulled from, view, etc.) and if it is entered having the view/field…
L1 Exam Activity 4 Import Error
I am getting error codes when importing to the EMP03 and SYS08 modules as shown in the screenshots. Can anyone point me in the direction of where I went wrong and/or how to fix it?
Change Source of a Model from Data Hub Dev to Data Hub Prod
Hi All, I am working in a User Story of a Dev Model to change the sources of data from Data Hub Dev to Data Hub Prod. The model In Dev I am working by now has already around 70 actions that are pointing different views of Data Hub Dev as a source of data. In my analysis I found that one way to do the change is: * Go to the…
Issue in Tabular Multiple Column Export Format
Hi All, I am facing an issue while exporting data from a dashboard by selecting Tabular multiple column export option. Although the table on the dashboard has been published by creating a saved view(i.e. by selecting 'Show Selected Line Items only' option). However, while exporting the data in tabular multiple column(.csv)…
Is Summary not dynamic?
Hi, I have explained everything in the below screenprint. Please share your views on how to handle this case.. Note: The module is data module where all the data is imported through csv file.
2.4.7.1 Create Demand Forecast Grid UX saved view_unable to apply conditional formatting
Hi, I am not able apply conditional formatting to get the result. Could anyone please guide me. required output - Applied conditional formatting - Got below output - Thank you,
How to declare a variable in denodo?
There is a question related to this topic but is not the same that I am going to ask, I need to do something similar as we do in SQL but this time in Denodo. This is in SQL: DECLARE @curr varchar (10); SET @curr = 'USD; SELECT Country, Currency FROM Currencies WHERE Currency = @curr; I have tried something like this in…
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…

Importing and Exporting Data

Discussion List