-
Import into Parent Level using BreakBack
I would be really good if we can import data into the Parent Level when Breakback is enabled. Currently, it is not possible in the system . Hope to see this functionality soon in Anaplan!! 🙂 🙂
-
"Omit Summary Items" on Exports should be an option for Imports
Currently, there is an option to "Omit Summary Items" when you are exporting data designed to exclude parent hierarchies. However, there is no such option for imports and this requires users to create saved views that manually exclude parent levels and can cause a lot of manual work for model builders. Without removing…
-
Excel Add In: remove a connection and multiple connections in one sheet
Idea 1: Currently we have the option to create Read / Read-Write Connection. But when I no longer want an active connection on a sheet, i am not able to remove it. This limits my ability to add a new connection or replace connection on the same sheet. Idea 2: Also, we cannot have more than one connection on a single sheet.…
-
Exclude Line Item Subset from data export
Hi Team While exporting data from a module, if there is a 'Line Item Subset' in the dimensions, we are unable to exclude it from Export. Can you please make the option available? I have provided some screenshot. Thanks & Regards Kudi
-
Add-Ins - Quickly Edit/Amend connections
As a model builder/user I would like to be able to quickly amend my connections so that they can easily be re-pointed to different Workspaces and Models. I will know that this is successful when I will be able to quickly change my connections and re-point to different workspace and models, perhaps with a functionality…
-
Data Integration with Single Click from Anaplan Dashboards - REST APIs
I am looking for an option in Anaplan Dashboards to put a link which will trigger REST APIs and execute the Anaplan operations which lies in the code behind it and return the results. With this way, we can plan to integrate many sources with single button click from Anaplan itself rather than using Anaplan Connect.
-
VBA/macros for Excel Add-In
As a model builder I would like VBA and macros to be supported in the Excel Add-In so that I could further automate workbooks. For example : 1) I would like to be able to create VBA code and macros for the various Anaplan actions so that I could automate a number of tasks (eg Login and refresh data) through macros 2) I…
-
Renaming line items should be propagated to import definitions
Currently renaming a line item correctly updates all module formulaic references. However, it does not get propagated to import definitions and Anaplan silently "ignores" the change i.e. the target column stops getting populated without any error or warning. Ideally name changes should get reflected in all aspects of the…
-
Export button on the Imports tab under Settings > Actions
I frequently export the Imports table under Settings > Actions when troubleshooting or working through a model. Connections between models or modules/lists through actions are not displayed in the model map so I highlight the Imports table and copy/paste into excel to diagnose/troubleshoot actions and discover…
-
Import Saved View - Filter
Hi all, A bit surprised this topic isn't here as it's one of the most common frustrations, similar to the post here. When importing from a filtered saved view there are a lot of cases of missing values. We all encounter it, and the first time it takes very long to determine the root cause. We change the filters but then…
-
Excel Add-In model view
Currently when creating a new connection from Excel Add-In, The wizard picks up all modules that are available to Read, Read/Write for the end user. We want to limit the modules that are shown in this dialog without having to remove the 'Read' permissions. can we either add something like 'invisible in Excel' in the 'Roles…
-
Excel add in sorting
Can we have the option to Re-Order and Sort List items during Pivot ? In General, Custom Sorting is very important when people need to work from Excel.
-
Excel Add-on: Sheet names update when changed on Anaplan
As an end user I would like the names of any sheets to update upon refresh if the associated module on Anaplan is renamed.
-
Have imports run base on the display name rather than a unique ID
This can be an issue when running a Module to Module Import, if both the target and the source module are dimensioned by numbered Lists, if the target Module's numbered list(s) the import will coordinate the import based on the numbered list(s)' Unique IDs. This means that some values will fail to import and other values…
-
Ability to manage metadata (add/delete/re-parent list items) via the Excel Add-in
Summarized Feature Request End users need the ability to manage list items, i.e. metadata, via the Excel add-in. By far the highest-priority and highest-value need is to add new list items. Situation Users switching from Oracle Hyperion / Essbase love the Essbase SmartView Add-in for office. One of the reasons they love…
-
Ignoring some columns when mapping timescale through column headers
When we get a source file with time in the columns it is very common to have columns that are not relevant for the mapping. As time usually requires using an "automatic" mapping it is quite inconvenient that columns that are not relevant are processed as a FAILURA in Anaplan. It would be fantastic to have the option to…
-
Cancelling Import will remove any partially imported data or list items
As a user, I would like any partially imported data or list items to be removed when I cancel an import. Currently, when an import is cancelled mid-way through, any partially imported data or list items will remain after the import is complete. However, the history will show that the import was cancelled. This will help…
-
Audit during bulk uploads
The User would like: A more detailed view of auditing functionality during the ‘bulk upload’ process at the cell level and create an ‘action’ during import. The action would be created upon export of the audit history. During the Sales planning process the User takes the 1st pass of Territory assignments and has the field…
-
Allow for “Send” only option in Anaplan excel plugin
Often times data doesn’t organically already exist within Anaplan, and users are either creating that data in excel or pulling that data from their parties using another excel plugin (Bloomberg, CapIQ, ODBC, etc.). Currently there is no simple way for them to map their formulas inside their excel sheet to always be pushed…
-
Excel Add In - Add Properties Similar to Labels Tab when exporting out of Anaplan
It would be great if you could add properties in the excel add in, similar to how when you export from Anaplan you can add properties from the underlying list using the labels tab.