Data Integration

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 Load from SAP BW to Anaplan using API
Hi All, Do you have document or articles explaining the data load from SAP tables to anaplan lists/modules via API? Thanks, Santosh
Anaplan and Power BI
Hello! I need to integrate Anaplan and Power BI. I will do as described herehttps://community.anaplan.com/t5/Best-Practices/How-to-Create-Connection-Between-Anaplan-and-Power-BI-with-API-2/ta-p/66364. But our power bi was greatly customized for integration under the site. I know that the developers suffered for a long time…
Integration between Anaplan + Power BI
Hi Team, Has anyone explored the option to integrate Anaplan to Power BI or vice versa? using Informatica IICS or Informatica PwC. I have both ETL tools. If anyone has explored this integration using either of ETL tools, please let me know. Thanks, Santosh
Import a subset from one list to another
I have an import of an entire organization, which includes all levels (sales person, manager, regional manager and divisional manager). I would like to use the list that it imports in to and populate individual lists (one for each of Sales Person, Manager, Regional Manager and Divisional Manager). I have them all in…
Level 1 Course importing files
Hi, For the Level 1 Course I have a few questions about importing files. I was wondering if it would be possible to talk to one of the experts on zoom because I think that would be easier and faster. I have to submit it soon so I would really appreciate any help. Thank you so much.
daAnaplan V2 - Informatica IICS - Error
Team, I'm using the Anaplan V2 connector from Informatica IICS but it's giving me very generic error message. Note sure what is the issue here. Any suggestions, please let me know. Thanks, Santosh Biradar
EMP02 Module_ Level 1
Data was successfully imported, mapped and formulation was correct as well in EMP02 module W.r.t EMP03 and SYS08 however, the value for Dec 2020 is not the right answer. Now I am confused as in what exactly went wrong. Can somebody please guide? Thanks
Anaplan Interface
Dear All, Just wanted to know whether Anaplan supports any kind of interfaces like Oracle Planning Cloud SmartView where data can be edited manually by the user using Excel. Thanks Abhishek
ALM - Best Practices
Hi Guys, We have just started going though the documentation on Amapedia and make some testing for our organisation, as we are preparing to bring in ALM (we already have a production system). Those are some initial questions that poped up, before going even deeper in updating any referenced formulas. Would appreciate if yo…
Copying Actions
I have an action to import today's date into a field 'Today' in a time assumptions module, every night using connect script. Great, works perfectly, all is good. I have a separate action/process that runs ad-hoc, but when it does, I would like to import today's date into another field in the time assumptions module 'Update…
L2 Supply Chain Model - Errors while loading data from Data Hub Model
Dear Community, I'm facing show stopper while running the historic volumes import into Supply Chain Model from the Data Hub Model. I ensured the source model is mapped correctly in Supply Chain Model. Further also checked at the individual import step to see if the object is referred correctly. Still, I'm getting below…
Update Anaplan connector for Informatica Error Message
When using the Anaplan connector for Informatica Cloud and an export fails when writing the output to a table that it can't accommodate a generic error message of [ERROR] Exception in thread “Thread-9” is displayed. It would be beneficial if a more meaningful message is displayed. Current Error Message: Proposed Error…
Level 1 - Expense by Role
I need to set Employee drivers by Role, so i created a list and imported roles data into it. 1) what should be my parent hierarchy in this case - All roles? or All departments? since i had initially created Employee hierarchy with E1 departments - (All Departments being at the top level) then #E2 Employees with E1…
Anaplan Data Integration options for Oracle as source
Hi - One of the challenges i often face while talking to clients is around the data integration options with Anaplan. What are some of the popular options to import actual data into anaplan from source systems. I am interested know about over and above the anaplan connect or flat file upload options. Is hyperconnect being…
Correct mapping guide
Hi, I have created a new list called 'SKU' which needs to be added at the bottom of product hierarchy for SKU's. I have denoted the hierarchy and tried importing the data. Can someone please correct what's going wrong. Thanks STEP 1 STEP 2 STEP 3 ERROR HIERARCHY Thanks
Updating a file through Dell Boomi but unable to change Default file type.
I am an admin and I am uploading a file from Dell Boomi using my credentials and while editing, I can see the records in the file being created but another admin can not see the updated records and Hence, Can not use the import actions using that particular file. Also, there is no option to change the settings of the…

Data Integration

Discussion List