Importing and Exporting Data

What is Excel Add in?
Hi Friends, By using Excel Add In, can we do only data update in Module & Lists? Or can we update formulas as well?
1.3.3.1 ERROR WHILE IMPORTING REGION DATA
Hi, I'm trying to import region data into a flat file in the given L2 data hub model. while doing so I'm getting some error saying "Invalid Code". I have attached the screenshot of source data and all the steps for the same. Any help in this regard would be helpful. Moreover, I want to understand when my source data has 2…
Multiple file upload prompts in a proces
Hi, I have a process published on a dashboard as an action. My process includes multiple actions that use the same csv file for various uploads. When I run this action I am promoted to upload the file more than once for each of the actions in the process. Is there a way to change this to prompt me to upload the file only…
G lists view is not similar to the output screenshot given in the training module.
As the system modules' saved views e.g. SYS005 saved views are generally created by the available data in the module. While importing data in the module most of the data is not getting imported or the file itself is not complete or blank. Therefore, my saved views' data is also blank, resulting a blank G lists. Moreover,…
Duplicate Data values
Hi Friends, Q1] What do we need to do, to avoid duplicate data being entered in Data Hub? Q2] Can we write any formula in Data Hub for concatenation, to increase performance? Does Data Hub supports formula or calculation?
Data Hub Optimize
Hi Friends, If the Data Hub size is huge, how can I optimize it? As it is taking a lot of time to get data imported into Modules. Regards,
Level 1 - Lesson 8.2.2 Add Volume Inputs and Lesson 8.5.3 Import Data into Volume Inputs Module
Hi I have just imported data into the REV02 Volume Inputs Module. My import of data went through correctly, I have attached a screenshot of what the data looks like in my module. As you can see the pages are Location and Product and the line item is Volume. My concern is in the lesson 8.5.3 the picture of the imported data…
Anaplan level 1 non employee expenses upload
I am unable to import data to non employee expense module .Not getting option to map manually. Please see the attached files and guide
Hierarchy Uniqueness - Non-Numbered Lists
Hi, I currently have a hierarchy with 4 levels (non-numbered lists). In our official hierarchy, levels 3 & 4 can have the same name, so we append a L4 to those particular items in Anaplan. Recently, I updated the process to pull the metadata from a different module in the data hub - but did not incorporate the L4 to the…
Print as wysiwyg
What you see is what you get (wysiwyg) is a common feature in most reporting tools and a fair request. Currently when we try to export through classic or new UX (as PDF), what we get is far from what we see. This greatly reduces the application of some of our modules as we cannot create PDFs and forward it to higher ups…
AN EXISTING REPORT TO QLIK
Hello Guys. Is here anybody who can help me to sort this out? I have to add an existing report to a Qlik. Thank you.
Level 1 Lesson 7.2
Hi I have imported Employee.csv file into Employees Details module but with errors. The date in the csv file does not match the module date format. Because this is a training course for ANZ I am not sure whether I change the csv.file date format or the date format in the module. I have attached a screenshot of the error…
Print Modules/Dashboards Directly from Anaplan
My users want to be able to print directly from Anaplan (without exporting).
Data import vs named list with hierarchy
Hi, i fance the problem during the data import - once i want to copy data from one line item to another in the same module i get duplicate values in some fields. After some investigation i realized that on my one dimension (named hierarchy list) i have the same name of member but on different level ex. Level4 - Duties and…
Imports and import data sources as production data
This article explains the different scenarios and the implications of marking imports and import data sources as production data. Before we begin, let's define production data. In the simplest terms, production data is data or artifacts that can be changed directly in a production environment without pushing the change via…
User Access Management
Hi, I have 5 levels of hierarchy and all are numbered list. I have one dashboard of user access management where i give access to users for the levels and import it into user settings. I am not able to create process for clear action and assign action in one process as it is overlapping the items. What should be the…
List import
Hi, I am facing an issue while importing the values in a list which is not a numbered list but the parent list is a numbered list I'll be really thankful if my below asked question could be answered: While importing items in a list if the parent list is a numbered list but the child list is not then what is the automatic…
In week 1 lesson 4.8.2 Importing Data into E2 Employees list
Hi I am in level 1 lesson 4.8.2. I tried to import data into Employees list and I tried various options but am getting an error message as attached. Would appreciate some help. Thiru
Import Process
Hi All, I have an import process in my model from module to module. The process is taking about 20 mins to get executed so are there any possible ways which can be used so that the import process time can be reduced. Thanks in advance!
Formula
Hi, I have a module created with dimensions rate area, brand and channel. However, I have another module where the user inputs the values only at rate area and department level. So from the module where the user inputs the values we are getting it into the module with extra dimensions(i.e. brand and channel) thereby…
Posting it for Wider Audience
These are my latest three articles that got published as Best Practice in this month. Please read if you haven't already done so, for they say Sharing is Caring 1. Anaplan Time Import Mappings Untangling Anaplan Time Mapping in Imports - Anaplan Community 2. New UX and Analogies Understanding Anaplan's UX with Analogies,…
Fetching anaplan export defenition failing with HTTP 500 Error
Hi Experts , I'm new to Anaplan and working with anaplan REST API's . I'm trying to fetch the export defenition from anaplan using postman . I have 4 export ID's for which I need to fetch the metadata . One of the export ID gives me the right metadata structure as output when i use a GET method and call the below…
How to upload data into week time when my format is week number
HI Anyone please guide on how to upload data into week time when my format is week number. I tried and got error of mapping and week headers. Thank You
Retrieve user details when Importing to list
Hi, I have a module where the user populate a few line items with information, which is then imported into a list and used further on in the model. However, now the client wants to include a column (line item) where they can see who made the new "transaction", that is, the user that is logged into Anaplan. So my question…
5.06-02 Delete unwanted sources
For one off imports, or when import sources are no longer required, delete the sources to keep the source list tidy
5.06-01 Naming Convention
Rename the import sources as soon as possible. For a saved view include the module name (e.g. module.saved view). For model imports, include a shorted version of the model name (e.g. model_module.saved view) Best Practice article: Naming Convention
Data Export in Individual Tabs in Excel
Hi, I was trying to take export in form of .xls where each item in my page selector should get copied to an individual tab in Excel and the tab name should get renamed as that of the page selector. I was able to get individual copies from each page selector in separate tabs by Exporting in Grid view and selecting All Pages…
Ability to include a timestamp on exported XLS files
Description of the enhancement required: Date Time Stamp as data field in the exported file (accurate to DDMMYYYY HHMMSS) An example of the enhancement: Formula which captures the current system time at time of export would be highly appreciated. How would it help the business process: The customer server would be able to…
Data export
Hi Friends, Other than Tableau, what are the external systems where data gets exported?
Can someone please explain, what these mean in Anaplan Informatica Connector?

Importing and Exporting Data

Discussion List