Importing and Exporting Data

Anaplan Power BI Connector
Hi I am using the Anaplan Connector to load data into my Power BI Desktop. Is there a way to do the same to Power BI cloud version? If so what are the steps required?
Field Separator for Export File from View
Is it possible to export data from AnaPlan using a pipe separator for columns. I can't find where this can be changed from a comma. Thanks
Retrieve Model ID and Workspace ID via API then load as CSV?
Hello All, I was wondering if it is possible to retrieve Workspace ID and Model IDs of any given Model which then can be pulled into a CSV file? Then imported into my current model? What I am looking for is something like this: 1) Retreive Current Model Details via API, extract into CSV. *Looking for ways to grab either:…
Dynamic exports - Export actions linked to saved view with filters or user selection
As a model builder I would like to set-up exports that are connected to saved views and that synchronize with a dashboard to provide end-users with dynamic and efficient exports and ensure sustainable integration with other systems. An example: A module is published to dashboard with month as headers. I want an export…
SYS08 Employee Details
How do I resolve the greyed out items? Please help.
Error while importing data into SYS08 Employee Details module
Error while importing data into SYS08 Employee Details module
how to import locations.csv in level 1 model building
how to import locations.csv in level 1 model building
Mapping the products.csv file in level 1 training
Hi, I created a hierarchy of product family and products. I need help with mapping the products.csv file. Please find the screenshots attached.
Regarding Email Notification via Anaplan Connect Script .
Dear Expert , Hope you are doing great! I am looking for your kind advice on Subjected Matter . I am working for Anaplan Connect Script for Import ., where we need to trigger mail to support team in case of any error while importing to Anaplan model . Could you please help me with the details and sample script to write and…
how can I automate or schedule a process with in Anaplan
Hi, I am looking for a functionality about how can I automate or schedule a process with in Anaplan, which transfers data from one model to another model with out clicking manually each time on that process in dashboard?.. I appreciate your help on it. Thanks! Suman
Got struck in 8.5.3 import volume file
While mapping i am a bit confused how to map time dimension to the source and line item mapping .please help me out on . I am attaching screen shot of what i mapped in the import
New UX and blocking actions
Hi all, I'm starting to implement the new UX to replace some of our existing dashboards and I would like to know if users working on a page are affected by blocking actions (import/export) as it happens in the model. This is one of our biggest challenge (ie: reduce blocking actions) to increase the anaplan adoption in our…
Importing List Formatted Line Items into List Formatted Line Items (Numbered List)
Hi, I have been getting import errors when trying to import a line item formatted as a numbered list into a different line item formatted as the same numbered list. We import directly from our source into a list formatted line item and the only workaround I've been able to come up with is to make a new line item, make the…
Model Builder 7.2.1 Import Data into Product Details Module
Hi All I have spent considerable amount of time trying to Solve this.. Can Someone please help.
One question regarding level 1 - Activity 7.2.3 : Import Data into Employee Details Module
Hello there, I meet one issue when I import data into employee details module for level 1, activity 7.2.3. The result can be seen from screenshot (refer to Result.PNG). Here we can see that Name, Country, Start Date and Leave date columns were not imported at all. The imported report can be seen from screenshot (Import…
8.5.3 Activity: Import Data into Volume Inputs Module
Hello! I have a question - when i created the modules, i deleted Time from dimensions. How to add it back after the module is created? Now I have this But i need to have this Thank you in advance! Anton
Automatically remap line items in import actions
As a model builder, i would need that in the following conditions : - an import mapping uses manual mappings for line items - the source line item name(s) are changed in the source module, that the manual mapping would be updated automatically or alternatively that we get a blocking mechanism that alerts us upon trying to…
Duplicate line items while importing
I am trying to Import data from a .csv file into an Anaplan module. The line items in the .csv file and in the module are distinct. The module uses a list subset. These line items are in the first column. When I try to Import there are 2 line items that are repeating when I go into the third tab to map individual line…
Importing CSV with Name & Code on file
For one of our models we have an import routine that brings in the below for a variety of reasons it needs to be in this format. As there is both name / code when we go to import it doesn't actually make it because the of there being the name column and they're being used as time. Beyond deleting the name columns prior to…
Importing Multiple Rows based on a Quantity Value based Cell?
Hi Everyone, I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item? For example, if I wanted to create 5 new employees that will have the same salary and reside in the same state and cost center. Is there any techniques that…
Import and Automate Current Date Import to Anaplan Using Python
Connect or Python Summary As a supply chain Anaplan data integration modeler, you might be asked by your business partner to display actuals for elapsed periods and forecasts for unelapsed periods. If you are not using the current period, which must be manually updated by a workspace administer, and you want to automate…
Backup - Archive PY cells
Rather than functioning towards excel for the previous year / excluded year data to save for future. There must be a process which will archive the data as soon as year got changed in TIME settings (with the warning popup) within given model and ready to refer as and when require. [Benefit]: Get rid of multiple models…
Timeout error while CA Certificate Authentication for file Import.
Dear Expert , I am trying to Import Data into Anaplan via Anaplan Connect Script. I am trying to Import with Certificate based authentication in Script but getting time out error as shown below. Could you please help me with the solution to deal with .Is there any ways to see the error log?? Script : @Echo off rem For…
Level 2 Sprint 1 DAT03 cells blank
I am at the end of Level 2 Sprint 1. I am going through the checklist to make sure everything was completed. When I got to DAT03 I noticed there is no data in any of the cells. When I did the first import, there was data there. So, I reimported the data from Historic Volumes and it said the import was successful, but I…
TIP: Anaplan API with Postman
Doing some work with the Anaplan API recently I found myself annoyed with having to copy/paste the tokenValue you need for each subsequent command after authenticating via https://auth.anaplan.com/token/authenticate. Below are some tips I found on how to automate it: * Create yourself a Postman Environment and store your…
Automate Process Running in Anaplan Model
Hi Guys, Is there an easy method of scheduling process running in Anaplan? Our consolidation process is not live and requires data pushes through inport actions within the model - that we need to run at certain hours. Basically we would need to open Anaplan model and run the process that we can even attach to a welcome…
3.3.5.1 Create Inventory Ordering Module Beginning inventory
My beginning inventory is in Negative. Why is this happening? Is there anything wrong with Beginning inventory or ending inventory formula? I have attached screenshots.
Lesson 2.3.9 Running import - Process 9
Hi I got this error when I run the process. I noticed there are two source models for the same action in the supply chain model. One created by Anaplan and another created by me when I built the Data Hub model. As follows: Then I tried to map the source object model I created when I completed the Data Hub model to the…
Level 2 Sprint 1 DAT03 Historic Volumes error
I imported data into my DAT03 and it populated all of the categories, but when I compared it to the screen shot I realized I have data in my Jan19 column and it's not in the Anaplan example. How do I get the data out of that row? I reviewed the previous steps about setting up the time range and it looks like what they…
Level 3 query
Hi Friends, I am not able to understand the exact requirement of the question. What is the total sales target for the medium sales account in Canada?

Importing and Exporting Data

Discussion List