Importing and Exporting Data

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.
Ability to exclude time dimension from an export
A description of the enhancement requested: When you export a module, in the Labels tab you have the option to remove any labels for a list dimension on rows and therefore effectively remove it from the export. This cannot be done with time and the customer would like it to be. A story for why they want the enhancement…
Updating an import source file
Introduction The process to update the source file for an import action is not obvious—but it is simple. There are a number of reasons you may wish to update an import source file, and I have listed some below: * Adding or removing fields from your source file and target list or module * Changing the format of specific…
level 2 Activity 2.3.10 Growth Rate Formula error
I have applied right formula in Growth Rate% of DEM03 module.But the hierarchical aggregation is going on.Is it right or Can I make a change so that Hierarchical error will not take place. But when I changed summary setting of growth% from sum to none then only SKU products have entries and levels above it didn't .I think…
Level 1 lesson 7 import of numbered list
I have mapped as per rules define for mapping of numbered list still there is no update in the module after importing the data many times, kindly assist me what i am doing wrong
Filters on the "Actions" tab
It would be nice to have the ability to sort and filter imports by source/target type.

Importing and Exporting Data

Discussion List