Data Integration

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
Script to Automate Current Date Import
I have a client that would like to automate the process of updating the current date in their Date Attribute module. Are their any scripts available to auto-generate the current date to load into their module? Ideally, we would install and use Anaplan Connect. Thanks, Tony
History Export Slow and large file
Hi, I wanted to check if anyone has experience on regularly exporting the history of the model. I have a model for which I am trying to export the 30 days history and it lasts a few minutes to download a 3.5Gb text file. It's a big file that's hard to manipulate. Is there a way to easily do that? Any best practice tools?…
Customized Mapping in Imports
Hi, I am unable to customize the mapping for imports in Anaplan, as an non-workspace admin. I was able to do that until 17-jan. Can you please guide if that's a change/bug in Anaplan Platform. PFA the screenshots for your referral.
Option of removing the space for Row label header from the export file if the header is not included
In the model currently we doing an export to APO. Our export file currently has a blank line which is generally there for the Row Label headers. APO is not able to pick up the data from the file as it it not able to distinguish between the header row and data row because of which now we have redesign the complete set of…
Anaplan Certification Types
Hello Friends, Can someone help me about what types of Anaplan Certifications are available? Are all of them chargeable? And what is the minimum cost for any Anaplan certification? Thank You. Regards, Sammy.
Allow history export summary only
When the model history is shown on the screen it is as a summary. When it is exported as a file it contains all the details. For some uses this is too much data and it would be good to have the option to export as a summary, just like the data shown in the dialog.
Export the 24 hour history summary without transactional detail?
I have a nightly batch that runs 14 processes. Most of them upload a file and run two import actions. Since this is the data hub, the only activity is this batch. The History page for the last 24 hrs shows a nice summary of what got done. During routine operations, users will rarely go into the data hub ... so there's not…
Anaplan Connect - Cannot enter password
Good afternoon, I am trying to upload a file using Anaplan connect. When running the batch, the windows prompts me with a password. However it seems that I'm not able to type anything for whatever key I press on the keypad. my script : @echo off rem This example loads a source text file and runs an Anaplan import into a…
Center of Excellence Map
Having an org chart with names and contact info built into each model accessible via drop down menu by "support" to see who owns the models and leads the Center of Excellence would both help users identify who they can contact internally on initiatives or for internal support and it would evangelize the vision of connected…
Data Export for Selected Line Items Only
Hi Everyone, I have a view that I want to export into a file via action. The view has 2 lists as column and 3 line items across. The module itself has 7 line items. However, the export always output all 7 line items. Is there a way to limit the export to the selected line items only? Regards, Andre
Allowing imports into more than 1 fixed month
It would be nice if we could select “Fixed Months” when doing an import and have the option of importing one file into multiple months rather than just one month at a time.
Issue importing dates as text
Hello, I'm trying to import a date into a text-formatted property from a source file. This works on my machine, however when another user uploads the same file, it seems to be creating a text field which includes 2 digits for the year vs. 4. So, when I run the import, the text-formatted field reads "12/31/2018", but when…
Lists - duplicate childs for each list members
Hi, I'm working on a financial forecast model where sales is presented through 18 markets (Countries) to the 5 Products. So for example: * Product 1 - Country 1 | - Country 18 * Product 2 - Country 1 | - Country 18 * etc. I have made several lists with: Total Company (L1) -> Products (L2) -> Markets (L3). Is it possible to…

Data Integration

Discussion List