Importing and Exporting Data

Data Export
Hi, How can I hide a specific line item/column when exporting? Please see screenshot. Thank you.
What is json and why is it used in Anaplan
Hi Friends, What is json and why is it used in Anaplan? Also what is Apiary?
OAuth for Integration?
Hey community, I can't find any info on using OAuth for integrations. Is this possible, and if so is there documentation somewhere I can access? Thanks!
Level 2 Sprint 2 - Off Set Volumes for first forecast year
Hi I'm currently working through Sprint 2 on Anaplan's Lvl 2 training course and I'm having an issue with my OFFSET formula. The formula itself is correct (as the course later confirms) though it doesn't seem to pull through any data from the Volume line item? (See attached) Line item formula: IF 'SYS01 Time Settings By…
Do Read my Latest Article on Imports and Import Data Sources
Community, Here is my latest article on the best practices about Import & Import Data Sources. Please do read it. Imports and Import Data Sources as Production Data - Anaplan Community Thank You @rob_marshall for reviewing it and giving it a fine touch.
Facing trouble in importing .csv to Anaplan without Time Dimension in the Source file
Hello Everyone, Hope you all are doing great! My name is Bhumika, I am learning Anaplan. with the help of Anaplan Community. I am facing a trouble, as I am trying to Import the .csv Data File to one of my Modules. I have downloaded .CSV file from the Lessons only, but that .CSV file doesnt contain Time Dimension. How to…
Solution Architect Eligiblity
Not available unless: You are a member of the Audience: Customers Qualified for Solution Architect what does this mean??
Level 1 Model Building 8.5.3 Activity
Hello, I tried to import data by following the instructions but cannot. Here are the screenshots and csv file I am trying to import. Some data is imported but they are wrong figures compared to csv file. If someone can help how to correctly import the csv file, which is very helpful. Thank you so much.
Import bulk users into a list having selective access
Hello, If there is a list hierarchy and we enabled the selective access to it. now for each list item, I want to add bulk users at a time. Is there any method or can we use any module to import bulk users? Thanks, Mahesh Kumar
Data Integration in Anaplan
Hi Friends, Please tell me, using this Python Code, if I want to import Data from Oracle Data Base. What are the steps I need to follow? Is this the only step for Basic Authentication? # Insert the Anaplan account email being used username = '' ----------------- # If using cert auth, replace cert.pem with your pem…
Progress Bar in the New UX?
Hi Community! I recently saw a demo in the New UX that showed a progress bar as Anaplan stepped through various actions after clicking the action button. The progress bar appeared to be dynamically updating after each action was run. Does anyone have any examples they can point me to that shows how this can be done,…
Copy Paste Formatting into other Tools (Excel)
Description: Much like this example, Anaplan formats in odd and weird ways when moving into Excel. Numbers being copied pasted into excel should retain a numbered format instead of scientific notation when pasted into Excel. Example of Enhancement: Values copied from Anaplan have a format attached to the value in the…
How to integrate Anaplan to AWS
are there any API's available in Anaplan to push the data to AWS cloud. Or can it trigger message to AWS ?
Export using JDBC - API request fails
Hi Experts, Trying to export data from Anaplan to SQL using JDBC connection. the script was working good for my last export where i was able to export the data to SQL successfully. Approach is the same and with new export script now, Script was working good till export and i encounter 500 internal server error for new…
Anaplan Integration most popular used Tools
Friends, Which are the most commonly used Data Integration Tools? Also let me know, which are they used to integrate? eg:- Anaplan Hyperconnect -> Informatica
Issue: Exporting action fails on New UX
Hi, would like to bring up that there seems to be an issue when running an export action from the New UX. Although the process is marked as complete on Anaplan, an Export Failed notification occurs, with the file failing to generate on my browser. I have tested it on the old UX and the action seems to be working fine. I am…
Anaplan Connect JDBC Error # 28
Hello I am trying to export data from Anaplan to Vertica and i get the Error # 28 / Error # 27 for some files. Not sure of the error type. Other files in similar formats are exported fine.
Search option while importing Saved Views from one model to another
While building imports from one model to another, it is tough to look for Saved Views as they are not sorted alphabetically. It would help if we can have an option to search the Saved View while importing.
Anaplan User activity Record from History
I need to make application for ANAPLAN in which I can load per day user activity in the model building , any idea what can work ?
How to export History in csv format
Need to export History in csv format,any idea ?
Filters when loading data from Flat File or external sources
It would be very useful to have filters to filter our some of the unwanted data in the source while loading the data into a list. Example Filter out certain Time periods, empty products, range of customers etc. Otherwise this is done in the model or the Hub after bringing all data. Other planning solutions have this even…
Dimension as User ID
How to set USER ID as dimensioned in Module for making user contribution application
Prevent Anaplan from running two processes simultaneously
Hello, Would it be possible to have an action or a property that allow to put in waiting list the effective start of a process if said process is currently running ?In this case, would it be possible to display in Dashboard of Classic and New UX which user/launch_date are currently on the waiting list ?The idea is to…
Automated import from Power BI to Anaplan
Is it possible to connect Power BI to Anaplan such that I could import Power BI entities or tables into Anaplan?
Load Data between two model from Numbered list to another Numbered list
Hi, How can i automatically map my data load from data hub to FPA model? In my data hub, i am using a numbered list(Coded) and trying to load this module in my FPA model using the same numbered list (Coded) but the mapping are not automatically updating. > I have mapped the building Code-Dum to the coded building column. >…
Import new list item from module using users dimension
I have an employee list for which I would like to create an action that allows to import new employees to the list. In order to do this, I have created a module using the Users list as a dimension with the line items needed for the import (including parent and code). After importing this modules in the employee list, no…
REST API - Speed
Hello, I am currently setting up calls to the REST Api, and I want to know if there are any best practices to improve the speed. If I try to run the same data that we are using with Anaplan Connect, it times out. This is a listing from the history for 14 Days of data, that does not time out. We usually run 60 days with…
New UX Process
Hi Friends, I would like to know, if the Process button (Action button) that is in the Worksheet can be published in the Board?
Anaplan Export using JDBC properties files
Hi All I have an issue when trying to execute an insert query using jdbc. # JDBC Connection string (Oracle, Mysql, H2, etc.) jdbc.connect.url=******* # JDBC login username jdbc.username=****** jdbc.password=****** jdbc.fetch.size=10 jdbc.isStoredProcedure=false jdbc.query=Insert into flash_rw (Period) Values (?);…
Toolbar new UX Dashboard
Hi Members, Please help me find this button. It is not displaying in my Worksheet Designer.

Importing and Exporting Data

Discussion List