-
Remove 10 million item limit from the ISFIRSTOCCURRENCE function
Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.
-
Excel Add-in 4.0 - Make Clone function be able to clone a tab into another workbook
Hi, I would like to suggest adding additional functionality to the Clone button. It would be helpful to be able to clone a tab and all of its formatting (or at least the tab's connection and connection settings) to a new tab in another Excel workbook and/or to a new tab in a brand new workbook to be opened. Thanks,
-
Dropdown menu in Excel AddIn
Hello, We currently have a dropdown menu in the line items when selecting items from a list - as per image below: However, when we create the connection with Excel, there is no dropdown nor anyway of knowing the names of the list which have to be manually inputted - please see image below: Is there any way of giving the…
-
Make Bulk Copy between Versions an Action
Currently our team EVERY WEEK, has to bulk copy the current version to the previous version because there is no way to automate this. That is 52 manual interventions every year. If you could create an ACTION that would allow you to bulk copy and have user select source version to target version, than we can schedule an…
-
Excel Add-in for Mac
Some of our clients use Mac computers and it would be great if you could develop excel add-in for Mac OS too!
-
Action/Process Run History
There currently isn’t a way to find out when an action or a process was last run. There is also not a way to see when the last time that a file was uploaded. We would like to Anaplan to capture the last time each one of these actions, processes, or data uploads occurred.
-
Provide detailed log on cloudworks
As an integration admin, it woulf be very useful to be able to get (through api or the ui) a log detail of the last cloufworks run for a given integration. This is necessary as the current error messages are a bit cryptic to understand like "process failed"
-
Ability to Use Workspace and Model Names within Anaplan Connect 1.4 scripts
Ability to Use Workspace and Model Names within Anaplan Connect 1.4 scripts instead of just Workspace and Model IDs.
-
Selective slide exporting from Management Reports
It would be great to be able to select specific slides to export when export management reports to PDF. Currently the system automatically exports all slides and you can't deselect any if you don't want to include them in the report pack.
-
Anaplan Excel Add-in Prerequisites
I wanted to share an uncommunicated prerequisite for the Anaplan Excel Add-in 4.x series. Reading through prerequisites, the documentation explicitly indicates certain items that are not natively part of an operating system, like the version of MS Office or the supporting technologies of .NET 4.7.2 and Visual Studio Tools…
-
Conversion to V4 - copy of older version is not made on Onedrive
To upgrade to V4, workbooks that are created in lower versions have to be converted. On conversion, a copy of the older version is supposed to be made. This works on a local drive but it does not work on OneDrive. As most of our files are on OneDrive, this will not work in our business operating environment. We will not…
-
Unable to open several workbooks with same connection
I have recently been testing v4 of the Add-in. We are current using v3.3. I am unable to work on several workbooks that have the same connection/model at the same time. V3.3 allows for several workbooks to be opened at the same time. I would point to several systems that allow for this, namely, Smartview (Oracle) and BW…
-
Excel Add-in: Clone Workbook button
Currently on the Excel Add-in I am able to clone worksheets. I would like to have the ability to clone an entire workbook or multiple copies of a single sheet rather than doing this 1 sheet at a time. Why? * Currently the Excel Add-in does not allow for copied workbooks to be opened simultaneously * This will facilitate…
-
CloudWorks - Possiblity to launch processes without being necessary to choose Datasource or Target
As Model Builder/ Data Integration specialist I would like to be allowed to create a Process in CloudWorks even it is not chosen a Datasource or Target. CloudWorks could be very useful tool to schedule data integrations between Anaplan models. Currently, this is not allowed and it is received the error: "Connection and…
-
Google Sheets Add-on: remove connection owner limitation
Currently only the one person who sets up the google sheet connection to Anaplan can refresh the sheets. It will be much better since we are a team and sometimes don't want to just rely on one person to refresh the connection. Or if the person needs to take vacation, then no one can refresh the connection other than to…
-
Import: add "Ignore All Unmapped" option with manual mapping
currently w/ manual importing Match or Ignore are the only options for assign/ignore an item. It would be huge time-saving for Admins to add "ignore all" option so all unmapped can just be skipped. IRL example, source have 400 accounts and target only need use 20 of them. it's very time consuming to click "ignore" for the…
-
Integration with Google Docs
Google docs integration with Anaplan as we use Google docs like Excel.
-
Excel Add-in: Filtering options
Hi, The Pivot & Filter's Filter dropdown functionality does not operate how most people (generalizing) are used to dropdowns working in hierarchical list . Please see screenshots below. Here I have regions, manager names, apartment properties, and floorplans coming from anaplan in a hierarchy. When I uncheck an item at a…
-
Excel Add-in: refresh all connections in a workbook at once
Hi It would be great if you could refresh all connections at once in one excel workbook. Currently, each sheet has to be done manually. In some of our excels we use for reporting, I have 15-20 sheets as currently you can only have 1 connection / 1 sheet. This would help a lot in efficiency. Thanks Kinga
-
Google Sheets/Google Slides Add In
My team at AdRoll along with many other customers that I know of spend countless man hours every month/quarter exporting our Anaplan dashboards into google sheets and then into google slides just to get data in front of our ELT. I have seen this in this forum before which I believe speaks to the level of impact it would…
-
Excel Add-in: remove 1m cell limitation
Hi, Anaplan connection to MS Excel is limited to 1mil cells only. This considerably limits as to what we can do with auto update of data straight from Anaplan to MS Excel. Removing the ceiling on cell count will really boost the efficiency for data analysis. At the moment, users have to either reduce the selection by…
-
Excel Add-in 3.2: increase cell extract count
In the current version of the Excel Add-in, it is not possible to create a connection to a saved view or module with a total cell count of the dimensions (rows x columns) greater than 1 million. Any saved views with hidden line items or filters applied will not have an effect on the view size and will therefore not…
-
NEW UX - Export Boards as PDFs process
Hi Anaplan, It would be great if the NEW UX had the capability to export boards as PDFs for reporting. Many customer are asking for this as they have previously created many reports using this in the OLD UX so would like to see the functionality in the NEW UX. Thanks, Usman
-
Ability to avoid refreshing deleted rows/columns in Excel
Description of the enhancement required: option to not refresh the full view in Excel add-in An example of the enhancement: If you delete a column or row, don’t re-add that row/column when refreshing A story for why you want the enhancement (How would it help your business process?): custom view’s can be created in Excel…
-
Adding to a dimension in anaplan being dynamically reflected in the view for Excel add-in
Description of the enhancement required: Excel add-in be dynamic for changes in the Anaplan view. An example of the enhancement: adding to a dimension in anaplan being dynamically reflected in the view for Excel add-in. A story for why you want the enhancement, (how would it help your business process): The Excel add-in…
-
Have a timestamp on when an action or process was last ran
It would be great to have Anaplan built in functionality to tell a user when an action or process was last ran. This would be extremely helpful in identifing forecast locking, data loads, etc.
-
Ability to export values as formatted for .CSV
As a user, I need to be able to export data in the format I have set instead of a standardised format when exporting as .CSV. For example, I want to be able to export * Large numbers - The option to export "1,000,000,000,000" rather than "1.0E12" * Small numbers - The option to export "0.00001" rather than "1.0E-5" My data…
-
'Last run' column in Settings>Actions>Imports grid
Description of the enhancement required: Imports and Import data source tabs were added with the recent Anaplan release. We would like to be able to view the date the last import is run in say another column. An example of the enhancement: Column field next to the import action that shows the date. How would it…
-
Work with Microsoft to make an Anaplan - PowerBI connector
It would be great to have a Anaplan connector in PowerBI (same idea as Excel and PowerPoint connectors), to have a live interfacing of data.
-
Ability to modify the SSO URL in powerpoint/excel add-in
It would be nice if within the Powerpoint/excel add-in, you could modify the SSO URL without having to uninstall and re-install the software. If a user is having issues logging in, it would be easy to check the SSO url, and modify it if they put in the wrong information. Sometrimes IT has to be involved with installing…