Importing and Exporting Data

Map attributes to time
I have a source file including 12 columns with the period of the current year. This file needs to be periodically updated into the Anaplan model. The file contains headers such as 1, 2, 3, etc. and I have to map these to the time dimension for the months based on the year the file is uploaded. Can anyone help me with this?
Work with Microsoft to make an Anaplan - PowerBI connector
It would be great to have a Anaplan connector in PowerBI (same idea as Excel and PowerPoint connectors), to have a live interfacing of data.
Apptio - Anaplan
Have any partners or customers encountered an Apptio - Anaplan integration? At its core, Apptio is an IT budget/spend management tool that seems to do a decent job managing the complexities of a large IT landscape, but integrating that (rather than ripping and replacing) with Anaplan could have some pretty awesome…
Having trouble mapping a flat file
Hi, I'm having trouble mapping this flat file into my Module. It will not let me manually map my data when I choose that option. Please advise. Pics are attached. Thank you
Level 2 - Sprint 2 Import into DAT03 Historic Volumes using actions
The instruction states to 'run the 9. Import Data from Hub process to pull data from the Data Hub model into the DAT03 Historic Volumes module in the Supply Chain model.' I ran into this problem while trying to run all actions in process 9. I checked my Data Hub and nothing seems to be wrong with DAT03.Export view.…
DCA working differently for similar scenarios
Hi, We have implemented DCA and applied the Read/Write access drivers in other Modules , post which it has actions to be executed. Once the processes are run, DCA works differently in 2 scenarios as mentioned below: 1. The data for the process "creation of staging list" executes but does not update the data (Step C :…
Re: Issue while importing data using one of the mapping options 'Ask each time the import is run'
Hi, I am trying to import data from one module to another. And in one of the mapping, I gave the option as 'Ask each time import is run'. The issue I am facing is it is not mapping to one particular record, instead, it is loading all the records into one record. mapping Importing from this module Importing into this module
Event based changes in models
As an integration admin, i need to be able to share in an event based logic any time my model is changing calculations. This could look similarly to the "history" log, with the exception that it would allow to be read through the api and show any before / after calculation made (and not just the input values changed by…
Api allow standard application contents type
As a data integrator working on industrializing data flows into anaplan from multiple application, i need to be able to consume standard data formats like json files. This is necessary to be able to call an api which will send me response typically in json format (standard restful for api) and consume the response with…
Level 1 - Lesson 7.2.1
Hello everyone! Lesson: 7.2.1 Activity: Importing Data into the correct Columns Issue: I have this error shown in the screenshots below. I tried to change switch around the sources but to me, this was the best solution. I also need to go back to my general list and delete out the product code data. I need to redo my import…
Decimal points dropping off amounts when uploading data file
I am uploading a .csv file with amounts that have dollars and cents. Whether the columns in my module are set to use decimal places or not, it is not recognizing the cents. 1633.34 shows up like 163334 when no decimal places are formatted and 163334.00 when I use 2 decimal places. Is there a way to see the amounts in the…
Actions in new UX
Hi Friends, I have actions and process created in old dashboard. I want to bring that in the new UX. I am trying to assign cards with Process but it is not getting saved. Any suggestions, will be of real help.
When missing code / unique identifier in transactual data (general ledger) for list dimension
Hi, What is the best way of treating a general ledger, in other words a big data transaction file, that is required to be in the data hub and is missing a unique identifier for each row, i.e. something to be used as a code for the list that will act as the dimension for the DATA module? I could create my own code in the…
Urgent help requested
Hi Friends, If my file is no longer available in the server. Then after importing the file and manually running the action. Will it read the file from the server instantly or in the job run time.
Anaplan Mulesoft Connector Refresh Token Issue
Hi Team, We are using Anaplan Mulesoft latest Connector for our client and With certificate authentication or basic authentication, Anaplan connector is failing while getting Refresh token after every 30 min. This behavior is happening randomly. So when 30 min completed and we send a request it is failing because of…
Import file to module
HI team, I am trying to import csv file to a module, it is worked and record updated in respective module. But when the same action trying to update using new set of records in source csv file via manage import data source "file not exist error " getting. i have delete the action and import again it is working in dev…
Hyperconnect connected by Tenant and allow sub-selections for Workspaces and Models
Within the API, reference support ticket: Issue with AP API 2, it is possible to call the model ID, workspace ID, and all of the actions within the model. When using Informatica Hyperconnect you must set up a new connection per workspace, per model, and that seems extremely inefficient, especially when you are using well…
Level 1 Model Building #E2 Employees import
Hello, I can't get the Employee list import to work. I've tried all thinkable combinations of settings when importing the employee list to the #E2 Employees numbered list, se enclosed import page and error report. Can someone help me out? /John, Anaplan beginner.
Lesson 8.5.3 Volumes Data Import Rev02 New
Hi - I am having trouble importing for module 8.5.3. I have uploaded data and chosen the format as shown in other members questions for this module. Steps I followed: 1. Updated CSV file update to show first header is row 2 and data in row 3. 2. Chose correct parameters and chosen "Fixed Line Item" for Rev02 3. Went to the…
Date format during CSV import
Hi All, I am trying to import the below CSV file to module, but unable to get the correct time mapping detail, any help will be appreciated . CSV File :- Mapping Column view :- Time Dimension mapping view :- The problem is I am not getting the month neither under "Pattern and Separators" nor Fixed Position patterns. I…
Import of Saved View
Hi All, I have created the module SYS12 SKU Data and Saved view as "Build SKU" and "Import SKU Details". but while importing the Build SKU saved view in new list P3 SKU I am not able to find the saved view for selection , below is the screenshot for the same. Let me know if in case I am missing any thing ?
level2 sprint2 : import DATA03 into historic volume
Hi in the attached screenshot my import is getting completed but it's getting ignored. please guide for the same
level2 sprint 2 - Run Process 9 Import Data from the Hub.
Hi all i know we need to change the timescale for DATA03 can anyone guide into how to do this please.
Lookup Mapping
Hi All, i am facing the issue in referring the data using the lookup function, I have described the issue in the attachment, if any body can help me with this it would be great. Thanks Vivek
Importing from a module into Users
I am trying to import from a module into users. There is one field in the module for a particular user that we are trying to bring in multiple values in the list selected. We are using the "text" format to enter the two different values in that list because we can't select multiple values in a list when it is in the "list"…
Time settings change
Dear Friends, If I update time settings (Month & Year) in Dev and then using ALM sync with Test & Prod. Will it get updated in Test & Prod?
Ability to use the CREATE action in the NUX
Currently the ability to create items directly in a list (using the create function) is only in the classic UX. Can we migrate this over to the NUX?
*Urgent* Add user in Production
Hi Community Friends, My Dev model is in Standard mode and Prod model is in Deployed mode. I have added an user in Dev but unable to add in similar way in Prod as it is Deployed. So do I need to follow ALM process for adding the user in Prod?
export action
Hi, We faced an issue with export job. Captured some error in file like " Error parsing key for this row; no values: 1 ". Could you please help me what this error meaning? and why this came? "Error parsing key for this row; no values: 1 " Thankyou
Anaplan clients import options - cost?
Hi, I'm wondering about the 3 more advanced import options that Anaplan have: Anaplan Connect, ETL Connectors and Rest API. I take it that Anaplan Connect comes along with any Anaplan license so would be no extra cost for an existing client? And what about ETL Connectors and the Rest API - disregarding what the client has…

Importing and Exporting Data

Discussion List