-
combination of properties import code creation
Anyone who has imported on a combination of properties into a list will understand the frustrations that can arise. For me there are two specific frustrations that i can think of a simple solution to. The problems: 1. Importing into a list using a combination of properties ALWAYS creates a new list member even if the same…
-
Add Minutes to trigger frequency in Cloudworks
Suggest to add minutes to trigger frequency Currently in trigger frequency in scheduling window there is no option to select minutes, This can be extremely beneficial and can add more flexibility to scheduling tool As example 1. During active forecast and budget time data constantly needs to be imported & exported 2.…
-
Bulk Copy On Items Within Modules and Bulk Copy Actions On Dashboards
Hi Anaplan, Currently the ability to 'Bulk Copy' of data only exists a list items data to be copied to another list item across the entire model. My idea is to have the ability to 'Bulk Copy' but only within a module from a list item to another list item within that model. Meaning that the data being copied only happens…
-
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.
-
New UX: Model Status/Refresh Messaging on New UX Page
Idea is to have a message or status on the New UX page in order to notify user that something is happening in the model that is causing the model to queue or be blocked (examples include: save state, actions, etc.). The lack of messaging causes massive frustration for users who think the New UX page is "slow". The classic…
-
Ability to copy/paste values incl. hidden decimals from Excel
When copy/pasting values from an Excel table to Anaplan, it only includes the decimals shown in Excel. E.g. if the value 0.5499 is in Excel but the cell in Excel is set to only show one decimal place, the value displayed will be 0.5. When copy/pasting to Anaplan, 0.5 will be used and not the full 0.5499. This issue can of…
-
"While/Wend" or "Do Loop" Functionality in Anaplan
Within VBA, it is possible to create "Loop & Exit"/"While/Wend" or "Do Loop" functions. This allows formulae to continue running until an answer is produced. Within Anaplan, there are workarounds, but none are truly as flexible, and all have their limitations. Creating this functionality would close the gap on some of the…
-
'Used in Dashboards' and 'Used in Action/Import' for SAVED VIEWS
When performing model clean-up's OR revising actions / New UX dashboards, it would REALLY helpful to have a view within the model settings area to review the full list of SAVED views along with the following key information; * 'Used in Dashboards' * 'Used in Actions/Processes' * 'Used in New UX Dashboards'
-
Log exports in the model history
Description of the enhancement required: Customer wants to capture the export information also to be captured in the history log. Currently, only import information is available. A story for why you want the enhancement: For the customer, apart from imports that are scheduled , if a user clicks on export they want that…
-
Export User Access with Display Names of Selective Access Lists (if Numbered)
If in the system Selective Access is set to Numbered List, when you export User Access list, all items are shown as #NAME instead of display name. Currently, on quarter basis we are preparing current user access lists to provide to responsible people. An it takes a lot of time to manually replace #NAMES with Display one,…
-
Update export actions created from a saved view when saved view is modified
I think the title says it mostly, but to be clear I'd like to be able to do the following: 1. Create a saved view of a module 2. Create and export action using the saved view as basis 3. Modify and re-save the saved view (i.e. add a new column, change the filter etc.) 4. The export action should update itself based on my…
-
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…
-
Enable Power BI Anaplan Connector with SSO
The majority of our customers have an SSO only policy. This means Power BI can not be used by them for additional analysis of Anaplan Data. As a Power BI end user with SSO enabled I want to be able to use the Power BI Anaplan Connector so that I can do additional analysis in Power BI.
-
Dynamic names for exports
It would be nice if we could define dynamic parts in the export filenames. For example a timestamp and or information about the selection perimeter for example : define the name like VALIDATED_INVOICES_%ORG ITEM%_%YYYMMDDHHMMSS%.csv that produces a file named VALIDATED_INVOICES_FRANCE_20211005165155.csv when generated
-
Use setting grids as a model Import Dat Source
There are certain fields in the settings tables of a model that would be very useful to be able to easily import into a module for further calculation/model usability. The uses I have already encountered would be: * The 'user settings' table - this would allow filters and dynamic cell access more easily based on role, or…
-
Clear an entire module
Scenario: If I am importing data into a module and a line item no longer exists in the source file, the Clear Before Import will not clear that line item as it will only clear line items that are coming in from the file. This can lead to numbers being off. Current workaround: Create a duplicate module that is filled with…
-
Export excel number format align with Anaplan data format
We have lineitem set as number with 2 decimal places. We set export file action with excel format template for user to easily upload back to the system. The excel output does not set data format by column but by cell which making us lost decimal number if we did not change format to number. Cell that already has data…
-
Use Gregorian calendar week numbers instead of fiscal week numbers
Hello community, Currently Anaplan uses its own week numbering to determine the week number. When fiscal period is different from jan-dec, then week numbers do not match at all with calendar week numbers as defined in ISO 8601. This makes it very confusing for users to adapt to these new week numbers, especially when users…
-
Cloudworks Integration not able to see API files
Hi Team, Our client has decided to use webMethods for their Anaplan integration. When webMethods sends a file through the an Anaplan integration user, the file is set to private and we do not have the ability to change the file to admin or everyone through the API or on the integration user on Actions - Import Data…
-
3 Improvements for Comments in the New UX
Hi, I'm missing 3 basic capabilities on the current comments' fucntionality to be able to use it for my clients: 1- Comments are not flagged to end user 2- Not recorded in full context (in all dimensions I'm looking at) 3-No option to publish or export from Anaplan This custom fucntionality I built allows me to overcome…