- 4 Minutes to read
- Print
- DarkLight
- PDF
2.1.2.2 Modeling Release Notes, July/August
- 4 Minutes to read
- Print
- DarkLight
- PDF
Version 2.1.2.2 is a hot fix release to the July 2017 2.1.2 release. Version 2.1.2.2 is still being called a July 2017 release even though it is being released in August 2017.
Substitution Variables Optimization
View and Report Save As Enhancement
Substitution Variables Optimization
The Substitution Variables functionality that was introduced in Version 2.1.2 has been enhanced for better performance in Version 2.1.2.2.
View and Report Save As Enhancement
In this release, when users Save As a report or view, the Groups assigned to the view or report are saved as part of the view or report. For example, if a view has group access defined in its properties as follows:
Then when you select Save As, the duplicate view you are creating will retain the group access in the view properties. Previously, the group access entries were omitted in the duplicate view.
This feature applies to both views and reports.
Known Issues
3080 | In some cases, strange artifacts appear on screen in Excel while saving a large report with freeze pane. |
3079 | In some cases, Excel 2016 crashes with cursor on a blank cell and selecting Design Manager in report design. |
2975 | Substitution variable and its runtime value should be retained after report is converted to Excel-based Report. |
2974 | User can see substitution variable expression from Excel-based Report but cannot edit it. |
2971 | Breakback does not hold the cells on the report which are locked. |
2953 | User should be able to change substitution variable in Expression UI when current substitution variable is not valid |
2916 | Report needs to be reloaded if Substitution Variable is removed. |
2873 | Breakback on rollup value from negative to positive may yield weird or incorrect results. |
2778, 2752 | Breakback can be performed on cells that have scaling (i.e. Amount Format) and on cells that are locked from Report. |
2611 | Cascade Reports will not work as expected if the user deletes a Dimension or an Attribute from the Model. |
2492 | If a report which is saved in an excel work book(offline) is renamed then users need to reload that report into the Excel workbook. Best practice is to refresh all reports in the saved workbook before renaming any report. |
2421 | Excel "Compatibility Mode" is Unsupported |
2354 | Snapshot email link will not work for users with SSO integration if they are not logged into the application. As a workaround they should log into the application and then access the Snapshot email link. |
2276 | If user makes any changes to the report (ex:- formatting, adding rows or columns, deleting rows or columns) after running it and then take a Snapshot then user will not see all the changes made to the report and in some cases the snapshot will look weird. We recommend users to take Snapshots without making any changes to changes to the report after its executed |
2113 | Integration between Planning & Modeling applications from web interface is best supported in Google Chrome browser. Users cannot navigate from Planning to Modeling if Internet Explorer compatibility mode is turned on. |
2080 | If users are using Firefox browser, right clicking an item in the Folder structure may display an incorrect menu. |
1845 | If POV member defined is removed or renames, it cannot be fixed in report design mode and error is displayed. |
1492 | Using special characters for the model name results in errors. |
1464 | When suppress rows/columns is enabled, If Dimension Members and Data Intersection are available in same column/row in a report then dimension members will be suppressed along with data intersections. |
1457 | In some cases Suppress blank rows/columns is not working as expected when Groups are expanded in the report. |
1455 | Suppress blank rows/columns is not supported in Spotlight (i.e. Web Interface). |
1454 | In Some cases Suppress blank rows / columns is not working as expected if groups and freeze panes are enabled in the Report. |
1446 | Unable to navigate to Design View after rename or remove HostAnalyze worksheet. |
1406 | Excel 2016 charts containing 3D Clustered Column, 3D Stacked Column, or 3D Stacked Bar are not supported. |
1322 | Unable to cascade with substitution variables. |
1321 | Substitution variables are not working as expected in Cascade Report. |
1273 | Cascade Report has inconsistencies with Filters. |
1144 | Freeze Panes location should not be outside of the sheet viewable range. |
687 | Modified Report definition by removing months column still retain after Refresh. |
The following issues are specific to Excel-based Reporting.
2518 | Reviewer user has no access to Publish Excel-based reports. |
2302 | If there are any Snapshots in the workbook then Convert Entire Workbook option will not convert the workbook. |
2203 | Shared POV status is lost upon changing value of POV in Design Manager / Formatted Report and EBR. |
2199 | Filter member options are not available if only 1 cell from a model exists, in formatted report and EBR. |
2097 | When using Design Manager, Update button is enabled only after entering a valid New Value and hitting enter. |
1887 | It takes over 1 - 3 min to open 22 MB Excel workbook. |
1755 | Locking / Scaling is not applied when converting a Formatted Report to Excel-based Report. |
1699 | It may takes up to couple of hours to Capture Entire Workbook with 30 worksheets and ~7000 data cells or more cells |
1698 | Message shows 'Please contact administrator...' when select Refresh after session timeout. |
1683 | Specifying a relative cell address to a cell in another tab in EBR creates an absolute cell address. |
1672 | Provide an option to reset the Excel workbook so users can upload using a different Report Template. |
1624 | Unable to download the same report as it's being used by another process. |
1550 | Errors when Capture Data as SpotlightXL Formulas with a cascade report. |
Resolved Issues
3037 | Performance issue opening an existing report containing numerous substitution variables. |
2923 | Cannot use the model if it contains an invalid formula. |