Importing and Exporting Data

7.2.1 Activity: Import Data into Product Details Module- Have been stuck for 5 days
Have been stuck on getting this list imported for 5 days. I have tried many ways and cannot figure it out. I know I am trying to get the size input into the size line item. I cannot figure out how. Are there any live or virtual options for assistance. Feeling defeated.
Show 'referenced by' also for saved views
We use frequently saved views to import data from a source module into a list or other modules. A great challenge is to understand where these saved views are used, it is particularly challenging when you import data across models. The only current way is to go through the import sources of each model or use the business…
Windows cmd shell script for dynamically generating JDBC.Properties file (A.C. 1.4)
Use Case: Batch import automation scripts using a SQL query in Anaplan Connect (AC) 1.4 require a companion .properties file that contains a lot of information about the query (connect string, login credentials, SQL statement, parameters). As a best practice, you should avoid hardcoding usernames and passwords in plaintext…
Add 'Use Current date' as model action
The 'Data Write' action functionality in Anaplan App (UX) is great and provides the ability to 'Use current date'. This means that by pressing an action button on the page, a module with a date format will be updated with today's date. Seamless and simple! Below I have 2 simple use case examples for this: 1. Workflow -…
Importing into a numbered list and module
Hi Anaplanners, I have a query, I have a numbered list KKT with display name property and I have made a KKT DET module dimesioned with KKT and has line items code and name. These line items use formula code(item(KKT)) and KKT.display name. To create actions I used a file to load KKT list and then same file to load KKT DET…
Facing issue in Parent Child allocation
Hi Community , Need Help from the topic " Lists" . While importing data for Parent Child bifurcation or allocation facing the following issues : ( Not getting the correct profile ) : The screen shots attached for 'Product ' & ' Employee ' Lists. Please help Thank you
Data type mismatch: format other than LIST or DATE being referenced as a relation
Not sure what the issue is! Please help.
Level 2 Conclusion: Importing Shipping Export INV05 into OTH 01 Non Employee Expense
Hello Friends, I am getting error as attached herewith in the above process. Could you please help. Thank you in advance
Anaplan model data source
Hi Anaplanners, I am working on an existing model and have some queries: 1. Some lists and modules get data from informatica cloud, how can I know what all modules or lists get data from informatica cloud, also I cannot find this under Actions or Imports right? 2. To load a list from informatica cloud, what all…
Interaction with Rest API for 100+ users
Hi All, I working on a web form developed in .Net C# which interact with Anaplam Imports and Exports. On Webform users will input data and on submit of webform data will push to Anaplan so how can i do achive this functionality , as of now i am checking with REST API provided by Anaplan. I need clarity if multiple…
2.3.9 Activity: Historic Volumes to Baseline Forecast -Action Contains the wrong information
When attempting to Run Process 9. Imort Data from Hub- I consistently hit this error. Import into DAT03 Historic Volumes module unsuccessful: Ensure the column headers in the import file map to the correct dimensions in your module, then run the import again. I searched this community before posting this question and saw…
Automate pdf Export
Hi, The new UX looks great and I know it has the ability to export a dashboard in pdf format. Is there a way to automate this process? I want to schedule some reports to be exported as pdf files to a cloud location or send as attachments to an email distro list. Thanks for your help.
L1MB 4.6.8 Activity: Import Data into E1 Departments List
Hi All, Newbie here. Have a confusion on the below activity. Below is what suggested in the training module. Grid view should look like this When I import the Department for the above grid view - I get the warning but the data gets loaded as per the document. When I try to correct the import via these steps Correct Mapping…
Insufficient permissions for Amazon S3 - Cloudworks
I was wondering if anyone had any insight on the following error when attempting to run an integration with Cloudworks?
Exporting Layout Help
Hi friends, I'm looking for a way to export data to match a client's mockup. My export module is set up with all necessary dimensions but I can't figure out a way to have my line items (Area, Account, Budget Code, etc.) to the left of my time in months - layout only needed upon export. Appreciate the responses
1.3.6.1 Code and Items?
Hello Everyone, Instructions for 1.3.6.1 go as follow: 1.3.6.1 Create Build Region Saved View Create a saved view for importing: * Module Name: SYS05 Region Details * Saved View Name: Build Region * Include: Code and items Make sure to select SHOW for the Code line item and save the view. This will ensure that as new line…
Can I add drop down list (with data from a list) to cells that are loaded with data?
Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to data if the loaded data is incorrect. I'm having trouble including both a drop down list and prepopulated data in the same…
Prevent Import
Hi, I have a scheduled import into a history module with a snapshot of data, every Friday at 2:00am. This all works. However, sometimes we need to take the snapshot manually earlier in the week, and if this has happened i dont' want to allow an import on Friday. As the import is using anaplan connect and runs every Friday…
Activity: Import Data into FP&A Model
Hi Team, I'm unable to understand the import below shown is my mapping.
Import Final Demand Forecast into DAT02 Module
I'm unable to understand why errors are coming though i think mapping is fine plz help
Enable Power BI Anaplan Connector with SSO
The majority of our customers have an SSO only policy. This means Power BI can not be used by them for additional analysis of Anaplan Data. As a Power BI end user with SSO enabled I want to be able to use the Power BI Anaplan Connector so that I can do additional analysis in Power BI.
Import data to read quantities per dimension instead of actual data
Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location.…
cURL fetching an export from API intermittently failing with 500 Internal Server Error
Hi All, We are trying to GET the exports from API but it is intermittently failing. At times when it is successful the response header will have content type returned as "Content-Type: application/octet-stream" and when it fails response header contains "Content-Type: application/json;charset=UTF-8" FYR see below when it…
Date Formatted Line Item || Default Mapping during import
Hi, I have a date formatted line item in one of my modules where we are importing the data from a file upload. I want to understand that what is the default format anaplan would require 'Date' column in the file if I do not select a custom mapping? Regards, Aakash Sachdeva
Import Error
How to resolved this error.? I have attached screenshot.
Missing employee names in The import of lesson 7.2.3
I am not sure what I am doing. I have read some of the other folks issues. I have made some of the adjustments. I am very new and definitely lost. Any guidance would be helpful and appreciated. Katherine
Google Sheets Add-On
Is anyone else having issues with refreshing data in Google Sheets via the add-on recently? The load keeps freezing or telling me there are various errors.
Importing data level 1 lesson 7.2.1
I have mistakenly imported the data file more than once. How can I reverse the problem or do I have to delete the module and recreate it. Thank you for any help. Katherine
Create filter based on line item
Hello All, I have a requirement where we can create filter based on line item so that we can export them. There are five line items for example - Payroll tax, salary, overtime, incentive, and bonus. The user should be able to check (using the new UX) which of the line items they want to export. Based on the checks, we…
File upload Question
I am trying to upload the file with the data and headers below. But for some reason I am getting an error on the time setting. not sure what to do here or how I should be setting the dimensions of the module.

Importing and Exporting Data

Discussion List