Excel Add-in v3.0 now supports time ranges and time scales (with one exception) when displaying Anaplan data in Excel.
A module or line item can be configured with a user defined time range, as an alternative to the time range defined in the model calendar. A time scale can also be applied to a module or line item which is different to the time range. For example, if the default dimension for a model is measured by Year, you can create a line item that has a timescale of Month, which is displayed as a subsidiary view.
The previous release of the Excel Add-in had limited support for time scales, and no support for time ranges.
In the previous release, if:
a module or line item had time as a dimension, the time range of the model calendar would always be used.
a module or line item had a user defined time range applied, this was ignored, and the time range of the model calendar was used.
summary periods, Year to Go, Year to Date, or All Periods were configured, these were incorrectly associated with the Day period type.
These limitations have been addressed, and the Add-in now correctly displays time ranges and time scales if they have been chosen for a module.
If you have previously created a connection to an Anaplan module which uses time ranges, you’ll need to pivot and filter the dimensions for that connection using the add-in before it will be able to refresh Excel with the latest data from Anaplan. If the add-in gets stuck when trying to refresh these connections, or you see a message asking you to pivot and filter the dimensions, you’ll need to identify the connections that use time ranges, and pivot them before you can refresh.
Time ranges and time scales at line item level aren’t currently displayed, and will inherit the time range or time scale of the module or, if this hasn’t been configured, the model calendar.
Easily save changes to dashboards in run-time mode
We've made it much easier for administrators to save changes to dashboards - to either the master or a personal view - without having to hit Edit to save updates in the Dashboard Designer. Now, any changes you make to a dashboard in run-time mode can be saved straight from the dashboard toolbar using the Save As Master and Save As My View buttons.
Toggle All Users in the Users List
If you're a workspace administrator, you can now choose whether the Users list, when used as a dimension of a module, shows all the users with model access or just your own user. This enables you to get an end user's view of dashboard grids that have the Users List as an underlying dimension.
The following issues are resolved in this release:
A corrupt model is created if you create a new model in a workspace that has insufficient space.
Renaming a list item with an existing name causes a rollback.
Copy/paste on numbered list with subset causes 'Unknown list member' client error
Copying and pasting a list with a subset causes the 'Unknown List Member' client error to occur.
When using theCopy Branchbutton for a list which is used as the dimension of a DCA driver an index out of bounds error is displayed.
Unable to add users to a model if there are more than 8 characters after the period in their email address
When you clickAdd Userin theUserstab ofModel Settingsand then type an email address with more than eight characters after the period in the email address, it is shown as invalid and cannot be added to the model. For example, email@example.com.
Internet Explorer version 11.192.16299.0 with decimal and grouping system setting other than English
If a user's system settings for decimal and grouping separators differ from the English settings, an Invalid Number error is displayed when copying and pasting a number with three decimal places.
If a cell is selected, pressing the volume button on your keyboard clears the data within the cell.
00180789, 00189726, 00191703
Whitespace generated below grid element
If a grid has the list used in a create action as a dimension, andSynchronize Selectionis selected on on Rows or Columns within dashboard settings, clicking the create button generates whitespace below the grid element.
If your infrastructure re-sends requests while Anaplan is still processing the original rollback transaction, this can lead to the requests being repeatedly processed and can block users from the model.
00181819, 00156741, 00163255
Grid displays odd behavior when refreshing
When you click an open dashboard button that opens the same dashboard, odd behavior is shown if the grid contains at least one line item with a filter enabled and that is placed above a grid with two lists nested on rows.