-
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…
-
"Search" box for the list when list is assigned as a line item format
As a model builder, I would prefer to have a "search" box to look for a list name when I assign a list as a line item format. Currently, I can only scroll to look for a list name. "Search" box is more efficient than scrolling when the list is quite extended . What do you think?
-
MAILTO functionality trouble shoot
Hey Team, I am facing this issue on MAILTO. I tried getting it in two ways: - Option 1: - Used MAILTO functionality MAILTO(u, v, w, x, y, z) Result from triggering this option from the backend and frontend (NEW UX) has led to an error where the line breaker (%0A%0A) inserted in the body of the mail does not function.…
-
Google Sheet Addin: Remove leading spaces from Lists items
Our primary purpose for pulling data from Anaplan into Google Sheets is to use it as a data source. This purpose is made significantly more difficult by the formatting of list items brought in through the add in. Specifically, lists are formatted with leading spaces as you can see by the " Bookings" member in the…
-
Applying one Pivot Filter to multiple cloned connections with the Excel Addin
I have one Excel workbook with multiple worksheets and I want to apply one Pivot value filter (e.g. Time - May 21) to all the worksheets. Rather than updating each individual worksheet "Time Value".... When I used reference this value across worksheets it is blown away after the refresh.
-
Excel Extract in mail attachment
Hi, I want to attach Saved view as a mail attachment and send it to clients. We dont want to show other module data to them so excel add-in doesn't work. So do we have any solution for that. Regards, Ajinkya S
-
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.…
-
Excel and Powerpoint add-ins for Office Online
As well as the existing Excel and Powerpoint add-ins for on premise/desktop versions of Office it would be good to have similar integrations available with Office Online which deliver the same functionality.
-
Excel Add-in: Add Compatibility for Apple Mac computers
Add Compatibility for Apple Mac computers. The Excel add-in for Excel only works on Windows PC's right now. Our parent company only uses Mac computers so they cannot fully utilize my reports that use the Excel add-in.
-
Error : Evaluating the forecast in Hold Periods ~ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
-
The Level of Statistical Product Forecast
I'm Trying a statistic forecast. And there is below statement in this site (https://community.anaplan.com/t5/Best-Practices/Statistical-Forecasting/ta-p/40359). * Multi-Level Forecast: Ability to forecast at different levels of the product hierarchy (i.e. Top Item | Customers, Item and Brand level can all have stat…
-
Control Weekly Seasonality
Hi. I have a question about weekly statistic forecast model. In this model, can we control the difference of weeks in another year? Suppose that, some food's demand will increase dramatically on 01/01(New Year). ・2014/01/01 - Week 1 FY14 ・2015/01/01 - Week 52 FY14 In this case, I think we cannot control the Weekly…
-
Addin Excel : add options like Include Empty rows
Hi, End Users want to have the possibility to include or not include Empty rows like options enable in Export. Best regards,
-
Excel Addin : Display Properties list
Hi, In the excel add-in, have the possibility to display the properties of the lists and not only the display name. End users need access to code or parent for exemple. Best regards
-
Ability to select a specific Page for entire Workbook when many Excel Add-in Data Pulls are Used
It would be great if we could set an overall workbook time period that would allow us to set the time period we or any "Page" selection for workbooks with multiple Anaplan Excel Add-in pulls. We would also still need the ability to change individual worksheet/tabs data pulls. For example, we may have a workbook where 90%…
-
excel add-in : Select a level without creating a view
Hi, A new idea for the excel add-in is the possibility to select a level for a hierarchy. For exemple, I have a module with the level 8 for organization, I wish have the possibility to decide to show only organization level 7 or 6 without level 8. Best regards, Carine B.
-
Excel Add in inheriting flow from the web UX
Does anyone know if there are plans for the Excel add in to more closely align with the web UX? For example, a few things that would be a big help in my opinion: -Allowing user to select a dashboard by name, which would then then filter down to show only the modules on that dashboard (obviously this wouldn't pull KPIs or…
-
Error message : Opitmizer
I tried Optimizer model and run the optimizer Action. But this error message has appeared. "This workspace is not entitled to Optimiser." We need administration?
-
Optimizer Pricing
Do anyone know about the cost and time it takes to enroll Optimizer functionality for a project
-
Not able to open Excel add in file with 4.2 version
Hi, I have installed Anaplan Excel Add-in 4.2 version. But now I am not able to open files which were prepared on Anaplan Excel Add-in 3.4. IF I open a file it closes down automatically. What is the workaround for this issue? Regards, Ajinkya
-
Anaplan Excel Add-in 3.4 Error
Hi All, A colleague of mine is working with a report in Excel using the Anaplan Add-in version 3.4 and is receiving the attached error even when opening the spreadsheet. On other occasions when she clicks on the Anaplan ribbon in Excel the spreadsheet crashes without an error message. She had issues with Excel crashing…
-
Excel Add-in: updating cells with Dynamic Cell Access and have a list format
Possibility to change data in cells with Dynamic Cell Access and a list format with a read/write connection in the excel addin
-
Excel Add-in 4.0 - Add ability to Refresh all tabs at once to the same page selector selection
Hi, I have a workbook with about 20 Anaplan-connected tabs. We have >100 properties in our portfolio. Each tab connects to a different module in the same model and all modules have the same page selector list chosen in the dimensions, being our list of properties from our hierarchical list. Right now, if I want to switch…
-
Synchronize filters across tables in Excel add-in
Add ability to synchronize filters across tables in Excel add-in. Working with the Excel add-in and extracting data from different modules, some of the filters across the different extracts overlap. A good example hereof is forecast cycle or specific versions. Currently, we have to change the forecast cycle in each sheet…
-
Excel Add-in: drag and drop dimensions, view line item formula, keep only/exclude
Please add the following features into the Anaplan Excel Addin - 1) Ability to pivot by dragging and dropping members within the spreadsheet rather than clicking on pivot and filter. 2) Ability to drill down a hierarchy by double-clicking in the spreadsheet 3) Ability to extract just one data intersection using some…
-
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 - Add Ability to remove connection from tab
Hi, Currently there is no button or feature to remove an Anaplan connection from an Excel tab, only to add a new one or modify an existing one. Please add a button to delete a connection. Thanks,
-
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…