Data Integration

It would be helpful to have an “aggregation operator” property that would apply to a hierarchy.
For example, consider the following hierarchy, applied to a module, with the following values: Net Income: $10 Gross Margin: $40 Sales: $100 Cost of Sales: $60 Operating Expense: $30 Clients would prefer to see Cost of Sales as a positive number. In aggregating, they would want to see Cost of Sales subtracted from Sales to…
Ad-Hoc Integration Using Flask Microservice
There are several cases in which it would be beneficial to allow users to trigger integration jobs, ad hoc, from within the Anaplan platform, but there is no native feature that allows this. Previously, I described a solution that simulates this functionality using only Anaplan Connect. This article presents a solution…
Data Hub Connection to multiple output models
Hi Everyone, We set up a Data Hub and would like to use it for multiple models, because there are lots common lists that we can use for various models. When we build connections among Data Hub model and other output models, we can set up actions in output models, by importing connecting "Data Hub" model's lists, to push…
How to sum a column by looking up a dimension in the module
Hi, I have this module that has a dimension list called Sales Title and a list called Quota Types. I have a line item called SSA Revenue, and it is 1 if it has SSA Revenue, else 0. I have a second line item and I want to sum the total number, grouped by Sales Title. Picture attached. Would I be able to get some help…
Intégration with consolidation tool to obtain consolidated budget
Intégration with consolidation tool to obtain consolidated budget
Import raw data of transaction
Dear gurus I'd like to import raw data of accounting transaction data from ERP. I created module "Accounting Raw data". In this case, we need to define unique key in module such as Document No, so I created new list "Sequence No" as numberd list. In this case, I have to import Document No to Sequence No list first, then…
Exporting data with a standard interface to SAP ERP
Is there a standard ETL to transfer data from Anaplan to SAP ERP? Several prospects in our country asked to manage budegting process in a dedicated application (as Anaplan) but transfer data to SAP in order to follow Budegt vs Actual?
Multiple Import Files
Is there a way to combine the multiple select files within an action when imports share a file i.e. updating a list then a module with the same .csv, without deleting and recreating the imports?
Mulesoft API Certificate Authentication
Hi, Does anyone know whether Mulesoft API can support Certificate Authentication? How to do it? I am referring to http://docs.anaplan.apiary.io/#
Anaplan Mulesoft Integration
The current Mulesoft does not support Anaplan connectors. Any advise on what to do regarding this? And how to find import id on Anaplan. Kindly provide your valuble input into this. Should I use backdated connectors/api ? -Thanks
Enable creation of new Version for model in deployed status when using ALM
Provide possibility to create and remove new Version when using ALM in the models that are in Deployed mode. For the enterprise organizations with strict sagregation of duties, it is neccesarry to have possibility to do as described, either manually or using Anaplan Connect API to create/remove versions on scheduler and…
How to Export a Dashboard to PDF?
I created a dashboard in one of the models I am developing. I want to export that dashboard out as PDF. I found this https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Work_with_Data_on_Dashboards/Print%20a%20Dashboard.html on anapedia, it says * Open the dashboard to be printed. * Click Export on the…
How different is 303 from 302
Hi Team We would like to know if 302 is different from 303, only difference we see is getting certified. Kindly clarify Kavin
PowerPoint Add-In and Conditional Formatting
When establishing a connection to a saved view in Anaplan that contains conditional formatting, Is it possible for the PowerPoint add-in to pick-up the conditional formatting as well? If so, can anyone please provide guidance?
Anaplan Integrations should work to edit model cells in addition to bulk upload.
Anaplan ETL connectors provide bulk upload capabilities. There should be capbilities for the customers to edit model cells in addition to bulk upload.
New workflow dashboards: auto-refresh when launching actions
In a standard dashboard data within are automatically refresh when a process/action is run. If you are loading data from a txt or from another module the user see that data are changing at the end of the action. With the new workflow this is not happening and, from an user stanpoint, this generate confusion and the need to…
Provide the workspace and model data available for querying in Bigquery
We have our data in Anaplan workspaces and models but our power users like to query the data. Would it be possible to make our workspace data available to query in bigquery ?
creating transactional store of plan data
I have various modules which use numbered lists as children of cost centres. Users add items to these numbered lists to capture planned costs for different activities over time. To export data to our reporting tool I've created a module which collects the values dimensioned by cost centre, gl and time. It is…
How to Integrate Rest API with Anaplan
HI All, I would like to learn more about Rest API connection with Anaplan. Consider my knowledge in this is 0%. Can you guys please share your thoughts or it would be great if you attach some files as well. Thanks in advance!! Kavin.
HyperConnect / Informatica Cloud (Training Course)
Course Objectives Resources Video: Locating and using Informatica help resources HyperConnect Overview (Start Here) The Secure Agent Demo Secure Agent Setup Connections Demo Connecting to Anaplan Demo Connecting to Salesforce Demo Connecting to MySQL Data Synchronization Demo Sync SFDC to Anaplan Demo Sync Anaplan to SFDC…
Removing empty Numbered List items from Module with Time & Version dimensions
Hi all, I want to be able to create a "cleaning" dashboard that removes redundant line items from a numbered list. I have a module that has the numbered list in question with dimensions TIME and VERSION, which acts as my data hub and records all the information for reports on the system. My first attempt to build this view…
To save records in the module, some kind of archiving within the model not the actual archiving.
So I am developing a model where I need to save the same module with different versions of it. Basically, I wish to make some changes and save it and someone else also should be able to make the changes and see it. I want to capture these modules with the changes made for the future reference.
how to add new member in a list (not numbered) from a dashboard
Hi Experts, I have to create a dashboard and use it to update an list. New members will be added in the dasboard which will add member in the list. This list is not a numbered so i cannot use create button. I have manage to udpdate the list properties via import but cant figure out how a new member would get created or…
Excel Add-in and Note pad
Can I use the excel add in to download and upload to the notepad?
Is it Real to make dynamic List
Dear Anaplanners, I have a modeling issue. We have an "Agreement Register" in anaplan, it has the structure you can see in attached photo: The values for each agreement are being changed every month. Also every month we need to Export "Unique code + Value" to other system, and each line there becomes enrighed with…
Powerpoint Add-in: Simplify option to update specific graph/table
Description of the enhancement required: In powerpoint add-in* REFRESH button it would be great to have option to select which graph or table to be updated rather than update all. Because if I want to update only one graph it is tedious to go through edit components. An example of the enhancement: Right click on the…
Ability to rename a version without breaking the import mapping
When performing a module to module import from the same model, if a version which is used as the source of an import is renamed, both the old and new version names will be listed as source items. The import will display a successful import message, but the number of rows Updated/Ignored/Failed will be empty and the module…
Ability to use retrieve data from Anaplan in Excel using a formula
A description of the enhancement required: Would it be possible develop a "AnaplanRetrieveData" formula for the Excel Add-in, where you can specify all necessary input from excel and the formula then returns the data point. An example of the enhancement: Formula in Excel would be: =AnaplanRetrieveData("Workspace…
Multiple Conditional formats for different rows in a table
I am wanting to set indiviudal conditional formatting rules for each row in a table on a dashboard. How am I able to do that?
Import Mapping
Hello, please see the attached screenshot: can anybody give me a hint why the "automatic" mapping does not work thought the strings are equal? (None of the pairs do...) Kind regards, David Mandl

Data Integration

Discussion List