Importing and Exporting Data

It would be helpful to have an “aggregation operator” property that would apply to a hierarchy.
For example, consider the following hierarchy, applied to a module, with the following values: Net Income: $10 Gross Margin: $40 Sales: $100 Cost of Sales: $60 Operating Expense: $30 Clients would prefer to see Cost of Sales as a positive number. In aggregating, they would want to see Cost of Sales subtracted from Sales to…
Data Hub Connection to multiple output models
Hi Everyone, We set up a Data Hub and would like to use it for multiple models, because there are lots common lists that we can use for various models. When we build connections among Data Hub model and other output models, we can set up actions in output models, by importing connecting "Data Hub" model's lists, to push…
How to Export a Dashboard to PDF?
I created a dashboard in one of the models I am developing. I want to export that dashboard out as PDF. I found this https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Work_with_Data_on_Dashboards/Print%20a%20Dashboard.html on anapedia, it says * Open the dashboard to be printed. * Click Export on the…
Anaplan Integrations should work to edit model cells in addition to bulk upload.
Anaplan ETL connectors provide bulk upload capabilities. There should be capbilities for the customers to edit model cells in addition to bulk upload.
New workflow dashboards: auto-refresh when launching actions
In a standard dashboard data within are automatically refresh when a process/action is run. If you are loading data from a txt or from another module the user see that data are changing at the end of the action. With the new workflow this is not happening and, from an user stanpoint, this generate confusion and the need to…
Provide the workspace and model data available for querying in Bigquery
We have our data in Anaplan workspaces and models but our power users like to query the data. Would it be possible to make our workspace data available to query in bigquery ?
creating transactional store of plan data
I have various modules which use numbered lists as children of cost centres. Users add items to these numbered lists to capture planned costs for different activities over time. To export data to our reporting tool I've created a module which collects the values dimensioned by cost centre, gl and time. It is…
HyperConnect / Informatica Cloud (Training Course)
Course Objectives Resources Video: Locating and using Informatica help resources HyperConnect Overview (Start Here) The Secure Agent Demo Secure Agent Setup Connections Demo Connecting to Anaplan Demo Connecting to Salesforce Demo Connecting to MySQL Data Synchronization Demo Sync SFDC to Anaplan Demo Sync Anaplan to SFDC…
how to add new member in a list (not numbered) from a dashboard
Hi Experts, I have to create a dashboard and use it to update an list. New members will be added in the dasboard which will add member in the list. This list is not a numbered so i cannot use create button. I have manage to udpdate the list properties via import but cant figure out how a new member would get created or…
Excel Add-in and Note pad
Can I use the excel add in to download and upload to the notepad?
Is it Real to make dynamic List
Dear Anaplanners, I have a modeling issue. We have an "Agreement Register" in anaplan, it has the structure you can see in attached photo: The values for each agreement are being changed every month. Also every month we need to Export "Unique code + Value" to other system, and each line there becomes enrighed with…
Ability to rename a version without breaking the import mapping
When performing a module to module import from the same model, if a version which is used as the source of an import is renamed, both the old and new version names will be listed as source items. The import will display a successful import message, but the number of rows Updated/Ignored/Failed will be empty and the module…
Import Mapping
Hello, please see the attached screenshot: can anybody give me a hint why the "automatic" mapping does not work thought the strings are equal? (None of the pairs do...) Kind regards, David Mandl
History Export Slow and large file
Hi, I wanted to check if anyone has experience on regularly exporting the history of the model. I have a model for which I am trying to export the 30 days history and it lasts a few minutes to download a 3.5Gb text file. It's a big file that's hard to manipulate. Is there a way to easily do that? Any best practice tools?…
Customized Mapping in Imports
Hi, I am unable to customize the mapping for imports in Anaplan, as an non-workspace admin. I was able to do that until 17-jan. Can you please guide if that's a change/bug in Anaplan Platform. PFA the screenshots for your referral.
Allow history export summary only
When the model history is shown on the screen it is as a summary. When it is exported as a file it contains all the details. For some uses this is too much data and it would be good to have the option to export as a summary, just like the data shown in the dialog.
Export the 24 hour history summary without transactional detail?
I have a nightly batch that runs 14 processes. Most of them upload a file and run two import actions. Since this is the data hub, the only activity is this batch. The History page for the last 24 hrs shows a nice summary of what got done. During routine operations, users will rarely go into the data hub ... so there's not…
Anaplan Connect - Cannot enter password
Good afternoon, I am trying to upload a file using Anaplan connect. When running the batch, the windows prompts me with a password. However it seems that I'm not able to type anything for whatever key I press on the keypad. my script : @echo off rem This example loads a source text file and runs an Anaplan import into a…
Data Export for Selected Line Items Only
Hi Everyone, I have a view that I want to export into a file via action. The view has 2 lists as column and 3 line items across. The module itself has 7 line items. However, the export always output all 7 line items. Is there a way to limit the export to the selected line items only? Regards, Andre
Allowing imports into more than 1 fixed month
It would be nice if we could select “Fixed Months” when doing an import and have the option of importing one file into multiple months rather than just one month at a time.
Issue importing dates as text
Hello, I'm trying to import a date into a text-formatted property from a source file. This works on my machine, however when another user uploads the same file, it seems to be creating a text field which includes 2 digits for the year vs. 4. So, when I run the import, the text-formatted field reads "12/31/2018", but when…
Import monthly data to timeline
I have seasonality input per month (January, February, etc.), summing up to 100% in a full year. How can this be uploaded to the timeline?
Make upload templates as a flat file so we can have 1 upload template per model
It would be interesting to have the possibility to have upload templates as flat file in order to ease the management of upload templates. This would allow us to have to manage only 1 template, and a list of columns that are "uploadable" We would need to have as many columns as dimensions, 1 column for the line item and 1…
Date Stamp List Property for Imported Data
A similar concept around date stamps was suggested here: https://community.anaplan.com/t5/Idea-Exchange/Date-Stamp-for-manually-entered-reference-data/idi-p/38423 but I would love to see this for imports too. A problem I've come across is importing data from a CSV without a date column into an import list. There are…
Changing the date format while exporting data from a module
Hi all, We have a module where the time is like Jan-19, Dec-18 etc. But we want the export file from the module to have date like 201901 or 201812. Is it possible? We don't have the option of exporting the data out from the module and changing the format and loading into another module as these are biggest modules and we…
Exporting data of selected line item from module
Hi team, I need to export the data of some selected line item(not all) from the module. As from general export it is exporting the whole data of all line items. Could you please suggest a way to export the data of selected line items from module. Thanks in advance. Regards, Mohammad Husain
Option to Omit Empty rows for imports
Description of Enhancement: I would like the ability to Omit Empty Rows when importing How this would help their business process: We have saved views used as IDS for imports between models. There are two fundamentally different approaches to set up them: 1. If we put all necessary dimension in rows and apply imports, it…
Import Action Editor Visibility
It would be great if all features of an import action, including field mapping, were visible and could be edited in one place. Particularly challenging today if an import file is set to private, once it expires after 48 hours, it is impossible to view or edit the import mapping.
Number format being changed when importing between models
I am attempting to set up an import between modules in two models; the target module has a has a list of numbers as the 'applies to' while the souces has a list of business areas. To get around this I have created a line item in the source module to assign each entry a number reference. This number is formatted at zero…
Model Import Failure
HI All, I'm trying to import a model from one workspace to another but I'm getting the attached error. This error is happening only for specific models and not all models to which I have access to. Can you please let me know what is causing this issue. Thanks & Regards, Prateek

Importing and Exporting Data

Discussion List