Bug fixes and minor changes 12.3

Minor changes

• Waterfall chart - If the Auto zoom option is enabled on the primary or secondary Y axis, the system automatically plots a scale break (a stripe) across the plotting area of bars to denote a break in continuity between the high and low values on the axis. This option is particularly useful if you want to display different ranges in various Objects included in a single Screen.
   

  The automatic scale break appears only if the Auto zoom option is enabled and the initial value of the starting block is not zero. The scale break can be formatted in terms of color and border thickness using properties under the "Starting block style" and "Ending block style" menus in Design mode.

• Show/Hide Points of interest (POIs) on the Google Maps Object - A new option for the Google Maps Object allows you to show or hide Points of Interest (POIs) on the map. The new option is available from the contextual right panel of the Screen editing page once the Object is selected.
    
  

  When the option is enabled, the following POI categories will be shown on the map:

  • Attraction

  • Business

  • Government

  • Medical

  • Park

  • Place of worship

  • School

  • Sports complex

The following image shows the Google Map Object with the new option enabled (on the left) compared to the map with the option disabled (on the right).
 

Bug Fixes

Dataflow

• A malfunction that caused Dataflows involving two Date Cubes to write the same value on empty combinations in the target Cube has been resolved

• Dataflows involving one dimensional text/date Cubes having different dimension between the source Cube and the target Cube are now working as expected

• Dataflows involving Cubes with different dimensions wrote wrong values on the target Cube. If a member included in the Selection was subsequently deleted, the Dataflow stopped working. To solve this issue, a new behavior has been put in place: when you delete any Entity member, all Cubes that include it are immediately examined and all invalid values are deleted as well. If you encounter this issue and you're on a version prior to the 2022 Spring release, please extract, clear and reload the source Cube to solve it

• Dataflows involving Cubes having different dimension are now writing values as expected, even if the target Cube has in its Structure less aggregate dimensions than the  Source Cube

• Dataflows that target ROLAP Date Cubes are now writing values as expected

• Dataflows configured with an algorithm using a conditional with nested parentheses are now writing values as expected

• Two malfunctions regarding Dataflows between temporary Cubes containing replicated Entities have been resolved

• A malfunction where a Dataflow triggered by a data entry action on a Data View didn’t write the expected values in the adjacent column has been resolved

• Dataflows involving Cubes with different dimensions and the "Previous year" time function are now working as expected

• Dataflows using the Yearly Moving Total and Yearly Moving Average time functions with no cycle value set are now calculating values correctly when a time selection is applied

• Rules with the column offset operator (also known as dot notation) in a Dataflow Layout now write values as expected

• Dataflows involving Currency Cubes now write values as expected

• A malfunction where a Dataflow configured with the "Previous year" function wrote values from two years ago instead of one has been resolved

• In some cases, Dataflows having a source Layout with the Yearly Cumulated Value time function caused Procedures to fail

Excel add-in

• A malfunction made it impossible to delete a value of a cell using the DEL or BACKSPACE keys in Excel. The issue has been resolved

• In some cases, connecting to Board from a previously exported Excel workbook caused Layouts to be lost or unexpectedly changed. The issue has been fixed

• An issue with copying and pasting Excel sheets that include Layouts has been resolved

• If you exported values from a  Data View to a flat table in Excel and connected to Board through the add-in, the Save/Undo mode for data entry didn't allow you to save any manually entered value. The issue has been resolved

• If an Excel workbook saved on OneDrive was opened by double-clicking the file, layouts were lost. The issue has been fixed

• Manually set column widths were lost after opening and closing the Layout editor on an Excel Workbook connected to Board. The issue has been resolved

• Users having a role with custom selection scripts using the @var function were not able to open the Layout editor in Excel after having exported a Data view to a Microsoft Excel Workbook for Board add-in. The issue had been resolved

• In some cases, Layouts configured in Excel using the Board add-in were lost after disconnecting and reconnecting to Board. The issue has been fixed

Procedures

• Navigating to a Screen through the Go to Screen action of a Label/Button with the "Same tab" option enabled prevented any Procedure set with the "On open trigger" options to run on the target Screen. The issue has been resolved

• Two users working on the same Procedure at the same time caused the Procedure to be duplicated and neither one was editable any more. Now the Procedure is not duplicated and both users can edit and save it, but the last save will always overwrite the previous ones

• The "custom path" field of a Backup database or Restore database action now shows the default database path as expected

• “Select entity based on Cube” steps weren’t applied correctly when the referenced Cube was empty and the active Data model included a security selection. The issue has been resolved

• Dataflows initiated by Procedures with breakpoints did not stop as expected when a breakpoint was hit. The issue has been fixed

• In some cases, after clearing and reloading data on a Cube where a Nexel formula had been configured, that formula stopped working. The issue has been resolved

• An issue that prevented the Export Dataset step from exporting algorithms correctly has been fixed

• Copying and pasting a group of steps containing a Dataflow between different Procedures sometimes caused Layouts of said Dataflow to be lost after pasting. The issue has been resolved

• Images contained in BLOB Cubes reloaded after having been cleared are now displayed correctly

• A malfunction where different selections on Blocks belonging to different Layouts weren’t retained after the last selection was applied has been resolved

• In some cases, editing an existing Procedure and saving it caused Layouts and Selects in its steps to be lost. The issue has been resolved

• CSV files exported via “Extract” steps now respect the CSV format, even if they contain values in quotation marks

• In some cases, breakpoints added to existing Procedures were not considered when running said Procedures. The issue has been resolved

• Various visualization issues related to color coding while configuring a "Bulk insert to SQL Table" step have been resolved

• The "Normalize Tree" step now correctly fixes missing relationships during the normalization process if the "Do not fix missing relationships (not recommended)" option is unchecked

• A malfunction with "If then else" steps applied to Date Cubes has been fixed

• It is now possible to insert new rows of data into external databases other than SQL Server via the new Advanced mode for the  "Bulk insert to SQL Table" step. See the Other enhancements page for more details

• Procedures triggered by data entry actions performed in drill-down windows now work as expected, with no error notifications

Screen visualization

• Having a selection applied to a Screen with a previously saved Bookmark made it impossible to add a new bookmark because the "+BOOKMARK" button was disabled in the popup window. The issue has been fixed

• If the "Enable" dynamic option was enabled on a Label Object in conjunction with the "inverse" property, the chosen Label background was not displayed in Play mode. The visualization issue has been resolved

• Labels in Bar charts with the Combine mode option set to Stack 100 are now displayed only if their height fits into the corresponding percentage of the bar

• Nexel writeback functions with a very long name hid the ADD and DELETE buttons. The issue has been resolved

• Pictures shown in Card elements are now displayed in their entirety, without being cropped when resizing Card elements

• Dynamic chart titles using the @Entity substitution formula considered only the default view saved by Capsule developers and ignored selections made by users in Play mode. The issue has been fixed

• In some cases, sorting a Layout with the tooltip by option enabled on a Block so that only the first row is displayed on the associated Data View caused the tooltip to disappear. The issue has been fixed

• A Card Object with a large number of elements slowed down other Objects set on the same Entities (such as Selectors). The issue has been resolved with the improvements made to the Card Object

• Scrolling through Data Views with many rows using the arrow keys now works properly

• Entity codes and/or descriptions are not truncated anymore in Data Views with Entity grouping

• A display issue caused the sliding toolbar for various Objects to appear in Play mode even if it was empty. The issue has been resolved

• A display issue on Data Views with picture Algorithm Blocks in the Layout prevented triggering a Procedure set on the cells corresponding to those Blocks. The issue has been resolved

• An issue on Data Views with the linked scrollbars option caused the Screen to freeze. The issue has been resolved

• A display issue caused items of a Menu Object to appear incorrectly after hovering over them. The issue has been resolved 18560

• Color alerts are now working also on Blocks where the Detail By option has been set

• An issue caused the number of decimal digits set in Block settings to be ignored after applying and removing a Block format configuration. The issue has been resolved

• A visualization issue that caused some Entity members in the Select window to be hidden on an iPad has been resolved

• A visualization issue that caused the Select window to be truncated using Safari on an iPad has been resolved

Various

• Broadcasting. The @date substitution formula in the Print configuration page ignored the user's regional settings if the attached report was sent when the user was logged off Board. The issue has been resolved

• Calendar. A malfunction that caused selections on the week Entity to be shown on the Calendar object shifted by 1-day has been resolved

• Calendar. In some cases, selections made on a custom Time Entity via the Screen Selection or a Selector didn’t reflect on the Calendar Object. Those issues have been fixed

• Card. The Card Object is now able to show more than 100 Card elements

• Cube write-back. Data entry actions on Rolap Cubes connected with tables in Oracle databases using synonyms are now supported through a manual query configured in the corresponding Data reader

• Cube write-back. A specific scenario in which multiple concurrent write-backs on the same Cube slice caused the system to become unresponsive has been addressed

• Data entry. Procedures triggered by data entry actions on Data Views associated with a filtered Layout failed and resulted in an error message. The issue has been fixed

• Data entry. A malfunction that caused unsaved values to shift position in a Data View if the suggested values option was enabled on a separate Block and the Layout was filtered has been fixed

• Data entry. A data entry-triggered Procedure executed in the drill-down window wrongly considered all cells of a Data View instead of considering only cells in said drill-down window. The issue has been fixed

• Data entry. Data entry actions on BLOB Cubes performed using the Firefox browser are now working as expected

• Data entry. The Pattern based allocation feature is now working as expected, even if the Cube providing the data entry pattern is hidden

• Data entry. Performing a data entry action on a Date Cube now supports dates without year (i.e. 7/25), as Board will automatically fill in that information for you. All values entered are now retained in cells even if you click elsewhere (on another cell or outside the data entry-enabled Object)

• Data entry. Locking a data entry-enabled cell of a Data View associated with a Layout with an algorithm Block with a reverse algorithm resulted in an error message. The issue has been fixes

• Data entry. A malfunction caused text strings entered via Data entry actions on an unbalanced hierarchy to ignore row sorting applied by clicking on column headers of a Data View. The issue has been resolved

• Data entry. Data entry is now working as expected also on row totals of Data views with Entity Grouping by Column

• Data entry. In some cases, the "Cube Cells locked by" option slowed the commit of any manually entered value in a Data View. The issue has been resolved

• Data entry. Manually entered values on a Cube with the "Cube Cells locked by" option enabled were saved in the wrong cells if rows of the corresponding Block were custom sorted using filters in the Layout. The issue has been resolved

• Data entry. Data entry actions in Data views with more than 100 rows and the Freeze Panes feature enabled are now working properly

• Data Entry. For security reasons, special characters, such as “&” and “§”, were not saved during writeback operations in RDB (Rolap) Cubes. The issue has been resolved and the characters are now supported. This fix does not affect SQL Data readers, but only affects drill-throughs and writeback operations performed via data entry or Dataflows

• Data model. The 200 characters limit for the Entity code width has been removed when unloading and reloading a Data model

• Data model. A bug prevented access to the “Data reader” section of Board if an invalid special character had been entered in the Path field of a saved text Data reader. The Path field no longer accepts invalid special characters and a specific notification message appears

• Data model. A bug prevented access to the “CONTENT” page of Entities after clearing and reloading members via a Data reader when the “Sort by” property was set to Custom. The bug has been fixed

• Data model. A malfunction prevented administrators from changing the default time range of a Data model created in Board 2021 Summer release and newer. The issue has been fixed

• Data model. Custom sorted Entities associated with a Selector caused an error if the sorting file loaded with a Data reader didn't contain all members. The issue has been resolved and a new sorting process has been implemented 

• Data model. Searching for a member in the member list of a custom sorted unbalanced Entity resulted in an error message. The issue has been resolved and a new sorting process has been implemented 

• Data reader. Data readers on Cubes set with the "Replace time slice" option didn't replace data as expected, but added it to existing values. The issue has been fixed

• Data reader. Data readers on Cubes set with the "Replace time slice" option now load data as expected, even in case of multiple executions

• Data reader. Data readers on Entities set with the "Add new item" option and ETL enabled now load data as expected, also with null values

• Data View. A malfunction that prevented files other than images from being downloaded from BLOB Cubes has been resolved

• Data View. An issue with copying and pasting values from Excel into a Data view with Entity Grouping has been resolved

• Diagnostic Log. A new "DataModel" field has been added to all logged Data model requests, so that it's now easier to debug application errors related to Data model actions. The new information is included for all verbosity levels

• Dynamic Selection. A malfunction where Dynamic selections using Rolap Cubes resulted in an unexpected error message has been resolved

• Dynawrite. Links now open as expected (in a new tab) on Firefox and Edge browsers

• Dynawrite. Manually configured translations are now applied correctly also to text in the Dynawrite, provided said text has no HTML style applied

• Entity editor. Adding a new Entity member to a Data model with many Entities containing thousands of members caused browser timeout errors. The issue has been fixed

• Entity editor. Adding a new Entity member now properly triggers the associated Procedure (if any)

• Enrollment. If a direct or manual Enrollment process is enabled in the Subscription Hub and there are no more licenses available for new users, a specific error page is displayed at the end of the Enrollment process. New user accounts are still created, but they are disabled: to activate them, administrators or approvers will have to manually assign them an available license in the User profile panel or enable them by unchecking the "disabled" checkbox, provided a valid license is assigned those accounts  

• Export data to xlsx. Exporting a data entry-enabled Data View filtered using a Pager resulted in an error message. The issue has been fixed

• Export data to xlsx. Exporting data from a Drill-down window to a flat table in Excel now correctly exports the same values displayed in the source Data View

• Layout. In some cases, rules on a Data Block in a Layout prevented values from being written in another Data Block having dimensions on the same relationship tree. The issue has been resolved

• Layout. An issue where the Layout wasn't replicating values as expected when a Cube had a less granular structure compared to the Entities set by Row has been resolved

• Layout. Values weren't calculated correctly if the Layout included Blocks with an Unbalanced hierarchy and Rules along with Algorithm Blocks. The issue has been resolved

• Layout. A malfunction where the Layout didn't replicate data for missing dimensions as expected has been resolved

• Layout. A Layout with the Refer To function and a selection with the "TO" option didn't work as expected if a Pager on the same Entity as the Layout Select was in the Screen. The issue has been fixed

• Layout. In some cases, reopening and saving a Layout associated with an Object having a previously set default drill-down caused the loss of that drill-down. The issue has been resolved

• Layout. Down totals for Algorithm Blocks were not calculated correctly if at least two Entities were set by Column. The issue has been fixed

• Layout. The gt(column) formula now works as expected with Algorithm Blocks as well

• Layout. Data entry-enabled Block with Rules and the "Cube cells locked by" option enabled are now retaining entered values as expected

• Layout. A regression that caused the Layout execution to fail when Cubes contained null values has been fixed

• Nexel. In some cases, the Nexel writeback function didn’t write values in the target Block of a Data View with Entity Grouping. The issue has been resolved

• Nexel. Nexel formulas didn’t write expected values if they referred to Blocks with a two letter heading. The issue has been resolved

• Pager. In some cases a Pager that contained a long list of members behaved unexpectedly when the user clicked on the "next" icon. The issue has been resolved

• Panel Container. Objects added to a Panel Container were incorrectly moved out of the Container area, thus becoming invisible. The issue has been fixed

• Print configuration page. When exporting a Screen, the @User substitution formula in the print configuration page now works as expected

• Rules. If the result of a Rule is 0, totals in a Data View are now calculated correctly

• Rules. A reverse rule set to an unbalanced hierarchy was not calculating the correct values recursively along the tree on a parent two levels higher. The issue has been resolved

• Rules. If an Entity member referenced in a Rule ended with the dot (.) character, said Rule couldn't be saved. The issue has been fixed

• Rules. When a new order is manually applied to the member list of a custom sorted Entity, Rules configured on that Entity are updated as well

• Rules. Dataflows with Layouts containing Rules are now working as expected and are significantly faster

• Select. Reloading a Screen with the F5 key in some cases applied a wrong selection if two Selectors set on a parent and child Entity were used. The issue has been resolved

• Select. A malfunction where a Go to Screen action set on a Label Object didn't apply the Selection on the target Screen has been resolved

• Select. Resetting selections using the reset button on Selector also reset Dynamic Selections applied at the Screen level. The issue has been fixed

• Select. The Dynamic Selection function on custom Time Entities is now working properly

• Select. If a Data model name contained the ampersand character (&), the Dynamic Selection function could not be used and an error message was displayed. The issue has been fixed

• Select. Deleting a member of an Entity included in one or more selections prevented Layouts from being executed. The issue has been resolved

• Select. A selection applied using the Exclude option now considers all expected members, even if they have no children

• Select. Clicking on the Select icon  now opens the Select Bookmarks window without any error notification and selections applied in Play mode can also be saved using Select Bookmarks, even if the "Deny selection editor" option is enabled on the security profile associated with the active user

• Select. A selection made on an Entity less aggregate than one in the structure of a Cube caused the other versions of that Cube to be ignored. The issue has been resolved

• Select. In some cases and with Data models imported from Board 10.x, a selection using the Dynamic selection feature with the "Based on cube" option and the "Period <> 0" setting enabled did not work. The issue has been fixed

• Security. A malfunction that caused Data views to return an error if a security selection on an Entity was applied to the user and the Screen selection affected the same Entity has been resolved

• Security. The Enterprise security management (also known as "~databases") is now working properly on Cloud installations using the Subscription Hub. To have the Enterprise security management installed on Cloud Platforms, please raise a ticket through the Board Support Portal: the ticket must contain your Platform name (e.g. customer1-s1.board.com). The Board Cloud Operations team will then handle your request and update you on the process. You will also have to set up a Sync rule on the Subscription Hub as described here 

• Subscription Hub. An error that caused unexpected logouts from Platforms associated with the Subscription Hub has been fixed

• Substitution formulas. The new "ShowActive" parameter for the @Selection_Ex formula can be used in conjunction with the "Entity" parameter to always show the active members (i.e. members included in the selection) of the configured Entity or to show the formula if a selection is made on other aggregation levels of the same relationship tree.

  • When the "ShowActive" parameter is set to "False" (default value), the output is the formula itself regardless of any other selections made on other aggregation levels of the same relationship tree.
    Example
    The formula @Selection_ex(Entity="Month",ShowActive="False") is displayed as is also in Play mode, even if you apply a selection on the Year Entity that propagates to the Month Entity

  • When the "ShowActive" parameter is set to "True", the output is always a list of the current active members (i.e. members included in the selection). If all members of the Entity are selected, the output of the formula is "All".
    Example
    The formula @Selection_ex(Entity="Month",ShowActive="True") returns a list of all members of the Month Entity included in the current selection, even if it is made on other aggregation levels of the same relationship tree, such as the Week Entity

• System administration. A bug that disabled the "Dataflow Log events" option in the "Log settings" page when restarting the Board engine service has been fixed