Data Integration

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…
Block any other transactions being processed between actions in a Process
Description of the enhancement required: We are requesting that Anaplan implement changes so that, when a process with multiple actions is run, no updates (manual data updates or configuration updates) are allowed to occur in between each action's running. This means that the process should be treated as a global action…
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.
Level 2: Conclusion: Activity: Add Currency Conversion Functionality
Hello, I am having trouble pulling in all the data for all the Time/years. What does it mean in the Activity Instructions: ..."contains data needed to set up this module. Use the Symbol as the Code for each currency." The CODE used throughout is not the column in the data extract under Symbol (eg USD) vs. Code of "US". I…
Requesting conception about new UX
Good evening Friends, This is an existing Model in App Hub, I downloaded it. Now what we find is that: It was Process and Delete Actions created (first two pic). In the third pic, we have the module names and fourth the list names. Now my question is: If I want to migrate to new UX, will I have to create every Module again…
Worksheet or Board?
To publish data in new UX, which is better Worksheet or Board?
Level 2 Sprint 1 -- User Story 3
Hi Everyone! As I've been going through Level 2, I have come upon an issue with importing the Historic and Volumes file into the DAT03 Historic Volumes Module. This is the error I have been getting, any help would be great, thanks in advance!
How to Import Multiple Files through Anaplan Connect?
Hello, I hope you're all doing fine. I would like to seek help on this issue that I'm currently having a challenging time accomplishing. I am using Anaplan Connect basic Import authentication. I am successful running the script when only one file is in the script. If I tried to include two files in the script, it is not…
List of actions inside a process
Is it possible, through Anaplan Connect or using the APIs, to list all the actions added within a process. e.g. Let's say I have process name 'Main_Process' and this process executes 3 actions : i. ClearList ii. LoadList_XL iii. LoadModule_XM Is there a way I can use API or Anaplan Connect to list all the actions (all 3…
Anyone available and interested in Zoom learning?
Hey there Anaplanners! I have recently completed my Level 1 certification and am starting Level 2. Was just wondering if anyone would be interested in setting up some time for online tutoring/coaching? I am the type that learns better when the setting can be interactive. Many thanks! Tricia
Issue with model mapping
Hi! While updating model mapping from 'Level 1 Data Hub' to 'Level 2 Supply Chain' workspace, I was able to do it successfully. Post the mentioned activity steps, when I got an error while running an action (9. Import Data from Hub) - I realized couple of the 'source object' has not been mapped (marked in 'red' box) to my…
Import Error
Import action is created to import in a numbered list and I received following error. Please help suggest changes to be done to achieve successful
Level 2 SYS05 Sprint 1 Saved Views Region Details (missing Code)
Hello guys, Started the long journey to L2 and having troubles early. I am trying to build out my Saved views. I don't think my SyS05 Region details is correct, it used to have 'Code' and now I can no longer see 'Code' . I know I did something and cannot revert, any advise on what the correct view should be and how I get…
Testing the Anaplan Office Add-Ins and Your Models — Featuring Technical Lead Eddie Dvorak
Our engineering team develops the Anaplan Add-ins for Excel and PowerPoint. This team is primarily composed of developers and quality assurance engineers who write and test the code behind the add-ins. This month, we're sharing insights from Anaplan Technical Lead @edvard_dvorak to illustrate how we test our products…
Data export from dashboard
Hi, One user reported issue that one column( line item) displayed in dashboard is not coming when she tried to export. Data>export. I am not able to replicate the issue. Any hint? Thanks
Urgent--- Can we copy a model from
Can we copy a model from one workspace to another? If yes, please describe.
VLOOKUP between lists with Property as key
Hello and thank you all for your time and help. Is there a way to set up a kind of vlookup between 2 lists, using one Property as the common line between them? I have created the same special key within both lists using 2 codes, that is a property. Now, I just want to do an old fashion excel´s vlookup between those two…
[ACTIONS/IMPORTS] When importing use the file name for automatic mapping
Description: As a model builder, I want to be able to use the file name that the user uploads, so that it can pick up automatically a dimension. This can be done when the source system exports files that have dynamic naming based on the selection of dimensions. Example of Enhancement: I’ll know this is successful when I am…
How to add a Data Hub to existing ALM structure
Hello everyone, Our current workspace/structure as follows: DEV workspace TEST workspace PROD workspace ALM: DEV --> TEST, DEV --> PROD We are considering implementing a Data Hub to hold transactional data & be the single source of truth. I know it is best practice to first create the Data Hub and then the other spoke…
Import Error
Hi All, I am facing an issue in the import action button set on a dashboard. The action button allows the users to upload the excel file in anaplan but after the upload is complete the details show that import process is successful and show nothing under the updated, ignored and failed sections and hence no data appears in…
Anaplan API — If SSO is disabled do CA Certs really help that much?
Hi All, I'm working on developing some best practices for our organization surrounding Anaplan API connections. I know Anaplan recommends using a CA Cert when connecting with the API, but I'm not able to find much guidance from Anaplan regarding API connections and SSO. I did find this thread where most users seem to be…

Data Integration

Discussion List