Data Integration

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…
Feature while Exporting
Currently when we export the data out of Anaplan we either create line items in the export module or we rely upon Properties of the dimension. Idea I am proposing is to give modellers third option which is to pick the line items from diff modules in the export window (Preferably System module) which share the common…
Level 2 sprint 3: Create DAT04 Distribution Center Parameters module & import data from Data Hub
Hi Team, I am confused as in, In the activity, we were told to import from the data hub model, which has half-yearly as line item along with weekly safety stock. Because of which I cant map it while importing. My importing was complete but with error and I can see the data in the supply chain model as well. Do I need to…
Level 2 Sprint 2 DEM Restricting export functionality
Hi Team, I have cleared level 2 sprint 2 exam, but with one wrong answer. In one of the activity, we need to restrict the export for the 3 module from DB. So I unchecked button DATA-EXPORT checkbox in menu options. But it seems it is an incorrect option. What should have been done then?
Re : Actions
Hi All,@VIGNESH.M @ @JaredDolich @rob_marshall Please let me know the solution for this issue. " For material 079A1803 the Product Hierarchy was changed end of may from PL 31 to 48. In H1 the Product line is correct 48, in M1 it is old 31 I can see the M1 is automatically updated 17 june. Please check why P03 is not…
Donwload Anaplan File from Cloud
Hi, I understand we can use Anaplan Connect to download file that has been uploaded. Can we also do this via Action that is published to a dashboard? I do not find Action that can download a file. Regards, Andre
Anaplan REST API with Cert Access: Connect to different Models
Hello All - I am building a process to connect to Anaplan via REST APIs. I have an integration account and utilizing CA Cert for authentication for API authentication. I have two workspaces, say WorkspaceA (with Model Model-A) and WorkspaceB (with Model-B). I have build a list in WorkspaceA/Model-A. My integration account…
Ananplan 3.4 excel add-in value name
Hi, we have just upgraded from Office 2010 to O365, and the excel add-in is now restricted by GPO policy - can anyone tell me a) Does the add-in need to be reinstalled ? and b) What the add-in name value is, so that it can be added to the GPO list of allowed add-ins. E.G. for the Adobe Acrobat PDF addin the value name is…
Generic Email ID used for Integration
Hi Anaplanners, Need to have some understanding on the Generic Email id that can be used for Data Integration to Anaplan Models. We are planning to use the system generated generic account for data integration to Anaplan Model from 3rd party tool, as per Anaplan policies that password needs to be reset every 90 days, will…
How to connect Anaplan to Tableau
Hi Everyone. I am attempting to utilize Anaplan to see my information in tables however not fortunate. Is there any approach to acquire the information from Anaplan and see them in Tableau? Effectively attempted a great deal however no luck. If anyone knows pls guide me. Thanks in advance. Tobi.
How can I establish connectivity between Tableau and SQL Server?
I have a Windows machine with SQL Server Management Studio (SSMS) and Tableau Desktop installed. From SSMS I can connect to a database on another machine. However, when I try to connect to the same database from Tableau Desktop I get the following error. Could not connect to server[Microsoft][ODBC Driver 13 for SQL…
SQL Server Edition Compatibility
I'm Newbie to Tableau SQL Server 2012, I found out that there are paid and free editions of SQL Server 2012 available . those are 1.Enterprise [paid] 2.@Tableau 10.4 B.I [paid ] 3. Standard [paid] 4. WEB [paid] 5. Express [free] 6. Evaluation [free] 7. Developer [free,paid] Now I have ambiguity between the paid version…
Run Data Import
Hello I would like to seek for your advise. During data import i am supposed to see this area after i have imported my excel file But as i was doing it, this is the only steps being shown:
Importing Data Into List Issue
Hi Anaplaners, I'm encountering an issue when importing data into a normal list. Let's call the List "L1 Property" The list has a parent called "L0 Group" I'm loading data as shown in the table below into L1 Sub Group list. L0 Group: Ice Cream L1 Sub Group: Ice Cream Anaplan is not able to load the data through importing.…
Dump Files in Mulesoft Connector
Hi, The Anaplan Connector for Mulesoft only let you download the dump files in path, it push you to work with a local server, when in almost all the cases the customers use Cloud environment and the data goes through streaming to Anaplan. Would be nice if you can collect the dump file directly in the connector and sent it…

Data Integration

Discussion List