About AnaplanIdeas

I would like the capability to blank out cells. This is not currently possible without clearing target before import.   Description of the enhancement required: Ability to blank out cells without clearing the entire module each time   An example of the enhancement: During the upload, there is an option which allows user to blank out previous stored date and then proceed with importing the new values.   ... View more

I want a version that contains values from another version, but doesn't rely on lists/formulas/etc. Changes to the model should not affect this version copy.   Description of the enhancement required: I want to be able to take a copy of a version which is just a copy of the numbers, so once you agree the budget it is copied and does not update due to any formulas. It is in essence a copy valued version for reference only. This would work for prior forecast as well, so during the year you can compare actuals and forecast to multiple prior forecasts. At present when I bulk copy it still looks at list information, so if that changes it changes the numbers in the version which you don't want as it's a fixed budget or prior forecast. It means I can have a model which has actuals/multiple forecasts/ budgets and 5 year plans all in one   An example of the enhancement: Once I have the budgets signed off by the directors this needs to be a fixed budget, as such at this point I want to copy the version where the budget has been built into a budget version. The version that was copied can then be used for forecasting purposes and then for budgeting in a years time as the formulas should still apply. This will apply for prior forecasting comparisons as well.   How this would help my business process: This enhancement would give us the ability to compare to budget and multiple forecasts. Due to being a rapidly growing business/industry we need to be able to refer to multiple prior forecasts to learn from the decisions made at the time to improve forecasting moving forward.   ... View more

Currently this is not an option in Anaplan Connect, and I've tried to post a JSON request to do this, but I get "Method Not Allowed".   Use case: We need to take a snapshot of our Production model every week & Month end. Those snapshots are then used for reviews as well as to pull in some of the lists into our Anaplan Production model. ... View more

Use case: As a user, I want to display the current time (e.g. 9/12/2018 5:00AM) in a cell. This should behave similar to the "NOW" function in Excel.   Business case: When a user presses a button, we want to display the last time the button was pressed. ... View more

I would like the ability to populate a subset based on a line item attribute in another import module that contains the full list. ... View more

Description of enhancement: Ability to set formula scope for selected versions rather than just the limited options of All/Actual/All except Actual/Current.   Business case: This would give us the ability to control what versions applied to a given formula. Would allow us to create snapshots. Would allow us to work in two versions (with the formulas calculating), while the other versions are static snapshots. ... View more

Capability to Export Model Map from Contents page to PDF/Excel. ... View more

Looking for more robust logging of actions: History record of all actions run with date time, who ran it and the outcome (success, error) Want to track if this action was run via the UI or API Want to see all historical data with a minimum of most recent 6 months Available in the API and UI Also want to see data after each action is executed Currently, a summary count of successful updates, errors, etc is shown See the actual data for each count (so if the summary shows 3 records are in error, show the rows with the error) Available in the UI and API but providing it in the API first is acceptable ... View more

Description of the enhancement: To be able to export the line item codes instead of only the line item name.   Description of business use: I have a financial statement report module where I have accounts as line items. This is because some of the accounts are calculated. We have a need to export this module with account codes for integration with, for example, data warehouse instead of line item names and we cannot find an option to export line item codes. Let's say I have a measure named "X" that is calculated X+Y/Z. That X has to be a line item to have the calculation. Let's assume that this item X has code 123 that is used in data warehouse. I cannot directly export this measure with code 123 but only with name "X" that is not used in data warehouse (or the name changes once in a while and therefore I have to use the code).   Workaround: I managed to find one solution for this. I created a module where I have list with same items that are line items in another module. Then I update the export module with the import-function by matching line items with dimension. Then I can use the export function and choose to export codes from the account dimension. This works but is not that elegant way of doing it. ... View more

When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0. To reproduce: 1. Create list with leaf item and parent 2. Create module with column 1 as "Data", column 2 as "Parent", and column 3 as "Lookup", using list from 1. as the dimension. 3. In column 2, set formula to "PARENT(ITEM(List))" 4. In column 3, set formula to Data[LOOKUP:Parent] Column 3 displays 0 ... View more

Description of the enhancement: We would like to have a Week format that will combine the number of the weeks in period and the period associated with the week. For example, for week 50, we'd like to see Wk 2 - P13 FY14. I imagine this is a concern for retail companies as this is the way most retail companies look at weeks.  Currently, there are only three formats in the Time section in Model Settings: Numbered, Week Commencing, and Week Ending.   Business reason for wanting this enhancement: We need a quick/easy way to compare the current week to the same week in prior periods. It is more intuitive for our users to see the week formatted this way; currently they waste a lot of time trying to figure out the week in the period. ... View more

Description of the enhancement: Essentially, we have many dashboards with floating page selectors, e.g. Cost Centre list (or subset). We want to be able to ensure that the dashboards always open with the top level Cost Centre selected, not first leaf item Cost Centre.   Business use case: In a scorecard dashboard, we would have e.g. a Cost centers list published as a page selector. When we open the dashboard, we see a specific cost center (e.g. Bobby123) in the page selector by default. We would want "All cost center" to be set as the default option in this page selector when the dashboard is opened.     ... View more

Description of the enhancement: Add an option to include conditional formatting in exports to xls ... View more

Description of the enhancement required: Ability to sort line items the same order in the subset as they are in the originating module   Example of the enhancement: A Line Item Subset for P&L report that he is using in another module; however, the line items in the Subset are not in the same order as the Line Items from the originating module. Every time users try to fix the way the lines in the module using the subset, the sort gets even more messed up. Currently, line item subsets used as dimensions are sorted based on the "Parent" column in the source module. Users want this sorted the same way it was sorted in the source module. ... View more

Description of the RFE: Users are copying and pasting formula from drilldown dialog, which isn't possible because parenthesis are removed. This is an RFE to retain the parenthesis, or at least provide that option. Use case: Drilldown formula is removing parenthesis. This is causing come issues for us working with a large formula as we try to paste the formula from the drill down back into the line item. ... View more