What's New in this Release?

Features

51536 - Added new calculated column function called EXTERNAL.COLUMN which allows for columns from a different cube to be included in calculated columns

51568 - Parentheses and commas are no longer allowed in column template IDs

51605 - ACCUM.EXTERNAL can now be used without an MITS.APPS.IDENTS.XREF record, if the identifier abbreviations match between the cubes.

51609 - The column selector now offers a section of columns from other hypercubes

52222 - Change Displayed Columns now includes columns from other hypercubes and a new calculated columns wizard

52251 - Improved error messaging on the main grid

52280 - You can quickly create calculated columns based off of a column you've clicked in the main grid.

52444 - Added new breadcrub widget at the top of the main grid to replace older drill down method

52605 - Select exploration has moved to the breadcrumb

52615 - While working on a grid report, the browser back button returns you the listing page rather than undoing changes.

52666 - The Select Values page is now more functional for root restricted users, though with some restrictions. If the "filter results by drill down" checkbox is unavailable, follow the instructions in its tooltip.

52700 - You can jump to a particular row of the report, and can scroll to load more data.

52928 - When a report uses 4 or fewer time periods, a time change accelerator appears at the bottom of the report and lets you quickly change the time periods uses on the report.

53124 - The visual appearance of the entire product has been updated and will be more usable on mobile devices.

53360 - UniVerse deployments can now handle up to 24 Identifiers, 2000 prefix files, and up to 12 external cubes in a report.  Unidata is unchanged.

53794 - When editing a dashboard grid object, there's now a checkbox for whether it should include links to detail display.

53820 - There is now a way to handle reports with invalid columns and allow users to fix the issue.

53918 - Instead of looking like ADD_SALES.Y_SALES.Y-1 calculated columns now look like ADD(SALES.Y,SALES.Y-1) and can be nested in each other. Don't put in spaces.

53993 - The styling of the product is changed, with a few changes in wording and minor UI changes.

53995 - The styling of the product is changed, with a few changes in wording and minor UI changes.

54004 - Under the covers, when creating a calculated column, it is now created with the new syntax using parentheses instead of underscores.

54104 - There is a new interface for creating calculated columns, which allows using calculated columns as inputs to each other

54171 - When selecting which dashboard to add an object too, there are more helpful messages about why some dashbords are unavailable.

54185 - The options in the menu bar have been rearranged

54208 - Dashboard object creation can now be done from within the dashboard and from MITS Report.

54209 - The options menu on the main grid has changed substantially.

54214 - Added the ability to override the column headings on a report.

54225 - When creating a dashboard object, it no longer asks you for what cell to use, it just uses the bottom right cell.

54290 - Enhanced the content validator to add a new section to the cube-specific summary portion of the content validation results that covers warnings that are not associated with a specific cube. It includes invalid MQL statements, unsupported dashboard items and MRQL content validation errors.

54317 - Total rows on reports have different labels than they used to, and there's no more column of plusses and equals. 

54318 - The help link now says "MITS Help" instead of "User Guide" and points to http://help.mits.com  unless you override MITSDiscover.help.url in the properties file.

54323 - It is now possible to configure a cube with multiple relational extractions into the same target file.

54367 - Now there are handy rolling 3 month and rolling 6 month eons for reporting and charting. Also if you're using daily resolution, YTD and MTD months.

54368 - When a column heading has more than 20 lines of text, we truncate it with an ellipsis in the UI and show the full name in a tooltip. In version 11.0 you can override the heading to something shorter.

54384 - To support multi-company sites where the different companies' information is stored on separate servers, it's now possible to perform the same SQL extraction over multiple relational connections.

54389 - The admin pages now include a section for managing "connection properties" that permit administrators to configure values that can be swapped into the SQL statements executed over each relational connection in MITS Report.

54439 - SQL extractions now can have multiple extractions into the same file. The UI for SQL management now lets you select which extractions into a file occur.

54451 - Now allowing the admin user in MITS Report to be given access to the content on the system.  Setting the "admin.access.mode" property to FULL_ACCESS grants the admin user full permissions on all aspects of the application, similar to the MITS Discover admin user.  It also allows the admin user to authenticate against MITS Discover.  Setting it to ADMINISTRATIVE gives the user the same permissions they used to have. 

54504 - Though there is no column maintenance feature in this release, the column's expression is visible to users with the Administration permission by viewing the "additional column info" section on the column heading's dropdown.

54514 - On the manage users listing page, users and templates are marked in red if they have restrictions on invalid accumulators.

Bug Fixes

45592 - There's no more error when you click a zero for detail display.

47085 - Fixed an issue where Safari would attempt to auto-completing passwords when modifying users or database connections.

47488 - Fixed the display of dropdown boxes on iOS.

47739 - Users with identifier restrictions now have more complete functionality when selecting identifier values in a drill down path.

51608 - The "trending upward overall" and "trending downward overall" options in the new report wizard were not useful and have been removed.

51777 - More gracefully handling cubes with bad eon loaders that end up with error messages in the dates for eon records.

51807 - Added validation against duplicate column template ids in the cube.

51879 - Tilde is no longer allowed in column template ids.

51889 - Equals sign is no longer allowed in column template ids.

51890 - Exclamation characters are no longer allowed in column template IDs.

52060 - The same columns will always appear on your detail display regardless of what you've drilled down by, rather than dropping columns that correlate to the drill down path.

52321 - Now you can filter to values that are empty or not empty, even on numeric columns.

52435 - The old style calculated columns could not handle a bang field with an underscore. The new style calculated columns can.

52635 - Fixed the content validator catching issues with chart drilldown paths on generated-path dashboards.

52764 - Scrolling into reports is faster than it was in 11.0-B. Some dashboards run faster the second time. 

52801 - When creating a new report, the wizard will no longer attempt to add a drill down path for the user's root restriction.

52816 - When attempting to launch a nonexistent report, there is now a nicer error message instead.

52822 - No longer hiding all-zero rows by default when creating a new report.

53194 - Modified the modal dialog that is shown when selecting the column to add row restrictions to a user to include a message notifying the admin when there are no indexed columns available for the source for which to add row restrcitions for.

53501 - When modifying a user's permissions, now displaying the username in addition to the first and last names.

53724 - Fixed loading reports that use an invalid related column (aka "bang fields").

53896 - Support for sub-routine using a ~ has been removed.

53999 - Fixed an intermittent internal error that could occur when setting an extraction schedule.

54029 - Fixed an internal error that could arise while canceling out of adding date range columns.

54056 - If a user does not have Manually Modify Dashboards permission, they shall now be able to modify the MQL and HREF.  Previously they were not able to.

54061 - Fixed a bug that would cause Select Exploration to only contain 1 value when the identifier's description field was pointing to an I-type dictionary.

54072 - The list of cubes in a dashboard's footer now includes cubes used only in time comparison grid objects

54076 - Avoiding a case when MITS Report objects on dashboards could error out due to a calculated column that has not been materialized 

54095 - Fixed an issue where attempting to re-render a dashboard would cause the data to not load. 

54099 - Fixed a rare case where use of a C4 column could sometimes cause fewer rows to appear on the report than expected. 

54108 - In new style calculated columns, the resulting treatment for the column is improved for the rare case that either has a scale set. If both columns are using the same precision, use the highest scaling.  If the columns use different precisions, use the scale of the column of the highest precision.

54122 - Improved error messages in MITS Discover when the MITS Report evaluation period has expired.

54124 - Fixed validation of numeric column filter values.

54125 - Now avoiding internal error when numeric filter values have spaces.

54129 - Fixed modifying dashboards on iOS.

54141 - Fixed performance issue that could cause the "New Automatic Report" modal to take a while to open if the system had a large number of reports.

54148 - Fixed dashboard export failing if width or height is less than 97 pixels

54154 - Now when creating or copying a user, the new name is permitted to match the ID of an existing report library. A warning message is shown to indicate that the new user will have access to the library.

54167 - The cancel button in the "Add Column from Source Dictionary" area of source management no longer goes all the way back to the source listing.

54175 - When creating dashboard objects, root-restricted users are now offered more dashboards to put the object on. The object will be modified to meet their restrictions.

54183 - Fixed support for SSELECT on identifiers in cube management.

54230 - Fixed an issue where the content refactor tool would change OR to ! in expressions and cause column compilation errors.

54233 - Fixed a bug that prevented exporting a report to PDF that contained a calculated column that used the "Days Elapsed Between" function that resulted in that column containing more than two digits.

54240 - Now when selecting values in the report drill down (which you'd formerly see under "Expand by Specific Values") we don't validate manually entered ids.

54241 - Administration tabs for MitsReport and MitsDiscover are now named "Admin"

54262 - Fixed use of RTOTAL in column expression not properly hiding column in column selection.  The column would still be unable to be run on a report.

54266 - Prevent users from accidentally creating reports with duplicate names.

54268 - It is now possible to add a MITS Report report to a dashboard while viewing the report, via a "Send to Dashboard" option in the menu bar.

54270 - Deep Linking to a dashboard now takes library read access into account.

54277 - Fixed an inconsistency with the "add to dashboard" modal between reports and charts.

54278 - Fixed an issue where the vertical bar character would break properties files

54296 - Fixed highlighting on the user group management page.

54304 - Fixed the display of break total rows on dashboard grid objects so that their labels show.

54324 - Fixed an error when user with no access to a dashboard library modifies a user with a landing page from that library.

54326 - Fixing the cursor display on the charting breadcrumb.

54346 - Fixing styling issues on the sidebar dashboard controls.

54360 - Fixing styling issues in user management

54362 - The time change accelerator no longer shows irrelevant options.

54378 - When selecting metrics when creating a new trending report, it was very cramped. This has been fixed.

54382 - Fixed an issue where cell dashboard items had more spacing then was necessary, in comparison to stoplights.

54385 - The time change accelerator on the main grid now includes Period eons if the cube is configured to use them.

54387 - Fixed inability to add dashboard objects from Internet Explorer.

54405 - In the Select Values screen, when searching for a value you can now hit enter instead of clicking the search button.

54409 - fixed an issue with column expressions that had spaces around parentheses

54431 - MQL statements 4080 no longer error during execution

54139 - Removed hero brine

54436 - Fixed the "ALLOWEXTERNALS" functionality that was intended to hide the related columns for an identifier from the column selector.

54447 - Expanded the supported characters in the connection string for relational connections.

54448 - Fixed an internal error when opening a report that uses an identifier that has no title.

54453 - Improved rendering time for dashboard cell objects on from very long reports in MITS Report.

54457 - Fixed display of bottom total rows in certain edge cases.

54465 - In the column selector, fixing the ordering of columns in an external cube when the cube only has one eon.

54469 - In Hoverboard there is now a helpful error identifying the first instance of a char that the package cannot be deployed with.  This error also prevents deploying the package.

54476 - Fixed a bug that caused all the long running connections to multivalue to be used up by a dashboard that is unable to execute all MQL statements for a single cube where the number of statements is greater than the number of long running connections.

54477 - Fixing an intermittent error where scheduled emails would arrive containing just the HTML of the login page.

54480 - Optimized package deployment for packages with large sections (thousands of lines) and added logging for further performance troubleshooting.

54481 - Fixed an issue where pop up menus that appear when clicking detail grid or time comparison grid links weren't getting dismissed in circumstances where a user scrolls the page after opening up said menus.

54484 - For cubes with complicated drill down paths, cube management sometimes would take a very long time to load. With this change it will give up after 5 minutes and just put all the paths into the explicit paths section.

54487 - User names in user management now appear in alphabetical order regardless of case.

54493 - When unified authentication is set up, when a user authenticates into the product, the links appear immediately instead of after a delay.

54497 - Fixed a bug when using UniData on UOJ that caused multivalue to crash when using a Preprocess during an Incremental build.

54506 - Fixed an internal error during incremental updats that prevented user stats from being recorded for the extraction.

54512 - Now more robustly locking out users with security restrictions on invalid accumulators. 

54536 - Fixed a missing word on a modal.

54546 - Fixed an issue where an Extraction that takes less than one second would cause the job to be executed more than once.  If the extraction sent emails, each extraction would send out emails.

54551 - Updated the information on the "Getting Started" page to reflect changes in MITS Report authentication.

54557 - Fixed an internal error when adding a root level chart to a scorecard.

53944 - The export options in MITS Report no longer include flyout menus to the side which could not be used on mobile browsers.

54420 - Fixed an issue where cancelling out of the column selection page when creating a new multivalue source was causing an internal error, due to an improperly configured cancel link.

53137 - Dashboards now have similar padding in visual edit and when viewing the dashboard.

54374 - Fixing the time change accelerator for certain cube configuration edge cases.

54464 - Fixed a bug that would crash cube wrapup when both LAST.FISCAL.MONTH and MONTH.ENDS were both set.

51703 - Errors may arise in various areas of the product due to changes in our javascript libraries that may have been cached by the browser. Please clear your browser's cached files after upgrade. Just the files, there is no need to clear cached cookies or passwords or anything else.

52221 - This is a clarification around the terms used within the product to prevent customer confusion.  Going forward External Columns will refer to the Columns from another cube and Related Columns will be a consolidation of the Bang Field, External Columns (old), and Secondary Fields which are all terms for the same field types.

52333 - For Full screen charting, we are not hamburgering the sub-menu.

52420 - Removing columns using the column selector by double clicking them currently doesn't work on iPad Safari.

52790 - Now a new tab comes up when drilling across from a Report. (not a chart or other dashboard object)

53146 - The Advanced Export link found on the library listing page for Reports has been removed

53215 - We've removed the Clear button on the Reports Save As modal.

53318 - Time columns from relational sources are sometimes converted to text.

53687 - For TWL dashboards, if they refresh while they are still rendering, increase the refresh setting.  

53766 - For both the Cube Update Time and the Additional Information box under the column heading, if you're on an iPad, they don't close until you click something else.  Apparently this is a bootstrap issue.

53825 - There is a slight change for how Modify MQL works: 1. If the character should be encoded, and it's not a [ or ], then Modify MQL will encode it. 2. If the character is a [ or ] then Modify MQL will tell you to encode it and will tell you how.

54096 - Related file columns (aka bang fields) now use spaces instead of underscores in their column headings.

54145 - If you select, as input to a calculated column, a date field, time field, or a field with no treatment, via the UI, you will receive an error that you can't use that column.

54258 - In 11, a line chart with only one point will show just a tiny little dot.

54286 - In the beta, we show an error if you have columns on a report using more than 6 other cubes. In 11 that limit is increased to 12.

Known Issues

52545 - Chart in PDF has elements that clip into each other that makes reading tough.

52943 - In the main report display, we've removed the column of plusses and equals signs that used to appear when using bottom totals, but the column still appears in PDF exports of reports.

53138 - In the create report wizard, time periods cleared out when you select new metric.

53141 - In the column selector, the grouping of non-metric columns under each cube in "columns from other hypercubes" is slightly different than the grouping in the local cube.

53183 - When Discover users are forcibly logged out by enabling or disabling Active Directory, their Report counterparts aren't logged out.

53197 - If a user is logged in, and another user changes their permissions, the user doesn't get the permission update until they log out and back in.

53229 - In Charting the EON slider at the bottom of the report does not work with the Surface and a mouse on Chrome

53836 - Dashboard charts produce errors when trying to chart too many data points.

53874 - Executing cubelet changes while a dashboard is rendering can cause cublet to hang

53923 - On certain customer sites, a dashboard grid with four drill downs sometimes causes internal errors.

54015 - Fixed some confusing behavior when dragging columns up and down while modifying a dashboard object.

54114 - If user security is not enabled, you can't save reports.

54118 - On Internet Explorer and Edge, when adding a dashboard object to a dashboard, a red "no" symbol appears unexpectedly while mousing over the items in the dropdown list.

54147 - On the Edge browser, when selecting identifier values for a chart's drill down path using manual mode, there are spurious errors about bad ident values.

54155 - Known issue: Password expiration doesn't work if you have Active Directory on.

54196 - When exporting a dashboard, if the height is just right, it cuts off the title and puts all the objects on the second page.

54213 - PDF export fail if column headings are too long

54227 - When adding a filter to a report via the Report Filters UI, the wizard modal briefly shows the column selection again before closing. The filter is still added successfully.

54245 - In hypercube management, the "detailStartingDepth" is not applied to the paths defined in the "explicit paths".

54252 - Dashboards are styled somewhat differently than they used to be and may end up not fitting on one pdf page.

54264 - The Report filtering UI doesn't let you remove a column but retain its filtering if it's a multivalue column.

54280 - Directly after adding a dashboard object from a MitsDiscover Report or a MitsReport Report, if you close the browser tab, there is no warning about unsaved changes.

54312 - When creating a dashboard object from a report, expanding individual sections of suppressed rows are ignored.

54333 - Exports with very long file names sometimes can't be exported while on Internet Explorer or Edge. This has been a known issue since version 9 (see bug 45728)

54412 - If your browser window is particularly small, buttons might be off the bottom of the screen.

54472 - If you have the gateway and the accounts on different systems, and the db server for the accounts has a different date/time, when building cubes (extractions and building), you briefly see the time according to the db accounts date before going back to the app server's date.

54485 - If you have cubes with very large outlines, you may get an OutOfMemoryError when attempting to open cube management. Please talk to MITS Support about tuning the memory usage of your MITS instance.

54519 - In certain rare circumstances while Active Directory is in use, an administrator gets errors about bad password characters when modifying a user. The workaround is for the user to log in, which will fix them, or for the admin to turn AD off and back on, which will fix all the users.

54533 - For Unidata, if you have too many prefixes, please set up the cube to use prefix files and the java cube builder.

41949 - When MITS Report is authenticating against MITS Discover, user names are not case-sensitive. When authentication is local, they are case sensitive.

47050 - When modifying a report, the data may reload after making changes, even if it's not strictly necessary.

48595 - You can't import a report that has a sort or filter on a column that was removed from the source.

51330 - If you have a preprocess, and it takes longer than the RPC timeout to run the preprocess, the build will fail with a general message.

47530 - Charts without negative numbers sometimes have a negative baseline. This is due to limitations in the third party charting library we use.

51033 - Chart data point labels can be confusing when they are the same as the name of the cube.

51589 - On versions before 11, the old filter UI could get too crowded to be able to see the filters added. This problem goes away in 11 where we have entirely redone the filter UI.

52267 - The charting "choose a [identifier name]" wizard page is confusing.

 

Tested Browser Versions

The following web browser versions have been tested with this version of MITS Discover. If you are having trouble viewing MITS Discover or using its features, check to ensure you are using one of the web browsers listed here.

• Microsoft Edge version 38
• Mozilla Firefox version 50.1.0
• Google Chrome version 55
• Apple Safari version 10
• Apple Mobile Safari iOS version 10.1
• Google Android Chrome 55