Changelog all (matrix)
2021.4.0
Improvements
added a new concept called hyper charts allowing multidimensional in cell charts
added the first hyper chart type: a basic sparklines in-cell chart
added some overlay UI as the start of an ongoing effort to configure simple settings and common use cases without opening a properties sheet in the matrix for SAC, Power BI and Tableau
added a comprehensive compound unit number formatting option that can be used to display time and other complex formats
improved the deviation chart label placement to not overflow in adjacent cell when label doesn’t fit next to the bar/pin, into the bar/pin and in the space on the other side of the axis
improved wording consistency in the UI
improved the order of properties in dialog boxes to reflect common workflows
added dropdowns to all properties used to select scenario ids
improved the UI of properties default column width and width per column
improved clarity of basic properties sheet in the matrix for Power BI by removing complex properties which need a mor sophisticated UI
made importance of filters more clear by removing the (optional) suffix in the UI
improved UI of in-cell charts by combining some properties and making specificity of some properties more clear
added a settings button to the matrix for Power BI
added an enable property to all filerable configurations
improved consistency between appearance of data headers and crosstab dimension name headers
improved consistency between scripting methods of charts and matrix for SAC
improved the UI for calculating deviations
improved default values of some properties to reflect common workflows (including Width Per Column, Default Column Width, Deviation Label Size, Scenarios in Column Headers, Collapsible on Whole Cell, and Scaling Properties of Pin Charts)
enabled the matrix for SAC to be displayed on mobile devices
added scripting method setSelectedData in matrix for SAC
improved sort configuration UI
added property Line Break to configure header text wrapping characters
added geometric mean as a new aggregation type
added Column Header Align property to configure the text align of column headers
added the display of dimension member attributes in the matrix for Lumira Designer and other environments supporting attributes in data sources
Bugfixes
fixed several expanse and collapse issues
fixed an issue in the matrix for SAC that lead to the calculated membername not being displayed in the matrix header
fixed an issue that prevented the aggregation configuration from being applied
fixed an issue in the matrix for Lumira Designer that lead to synchronized scenarios not being displayed in the Additional Properties Sheet
fixed an issue in the matrix for Power BI that occasionally lead to crashes
fixed an issue that lead to crashes when specific color settings were used
fixed an issue in the matrix for tableau that excluded month and quarter dimensions from filters
fixed an issue that lead to infinity deviation values being included in the scaling
fixed an issue that lead to a JavaScript error when using cfl method getAddress()
fixed an issue that lead to data not being displayed in the matrix, displaying row and column headers only
fixed an issue that lead to intial row expand level not working correctly when user has previously clicked and filtered
fixed an issue in the matrix for Power BI that lead to cell background color not being changeable using css
fixed misalignment of Scenario Bars
fixed an issue that lead to automatic Locale in number formatting options not being applied according to browser language
fixed an isue that lead the matrix disappear when an error occurs in CFL
fixed an issue that made it impossible to change the opacity in steps smaller than 1
fixed an issue that lead to editable cells not being focusable after deleting all characters from the input field
fixed an issue that prevented input of some characters in editable cells in firefox
fixed property initial expand level not working for some specific hierarchy levels
fixed sorting of columns descending/ascending not working sometimes
fixed an issue that lead to scenarios not being imported correctly when using css import in matrix for Lumira Designer
fixed dimension selection UI not working in matrix for Lumira Designer in some cases
fixed an issue that made cells overlapping with header cells when scrolling when some cells were highlighted by a data selection
fixed an issue that prevented the matrix for SAC from resizing correctly when changing the widget’s width or height
fixed an issue that lead to an incorrect suggestion of members or dimensions in the filter UI
fixed an issue that lead to unnecassary space beneath header cells with long header texts
2021.2.1
Bugfixes
fixed an issue that lead to misaligned scenario bars
fixed an issue in PowerBI that lead to newly added properties falling back to their default values after a reload
fixed an issue that made some versions of the graphomate matrix for SAC not render anything
fixed an issue that made the graphomate matrix for SAC not render anything when the visibility of a surrounding container component was toggled
fixed an issue that lead to the class attribute in html injected into the title text not being applied
fixed an issue that made the graphomate matrix for Lumira Designer not render anything when used in some nested container components
fixed an issue that lead to incorrect ranking of rows when using the Top N + Rest Feature in Internet Explorer
Improvements
added the same scenario import/export UI to the Additional Properties Sheet of the graphomate matrix for Lumira Designer as used in our charts component
added a tooltip to the info section of the GPS to show the exact versions of latest or staging release channel builds of the graphomate matrix for PowerBI
added scripting methods
setResultCellSet
,getResultCellSet
,setResultCellSetJsonString
,getResultCellSetJsonString
to the graphomate matrix for Lumira Designer
2021.2
Bugfixes
prevented cells to overflow the matrix and shine through the header cells when scrolling while browser zoom is active
fixed an issue that prevented background bars from being displayed when they were activated in more than one column and there was a column completely displaying outliers
fixed an issue that caused child node row headers to not be indented correctly when displaying explicit hierarchies
fixed an issue that caused the graphomate matrix icon in the header of the Graphomate Properties Sheet to be displayed way too large
fixed an issue that prevented the members of a sort configuration from being draggable
fixed an issue that caused a grey pin head or bar to be displayed for null values when using in-cell charts instead of displaying nothing
fixed an issue that crashed the matrix when it displayed an explicit hierarchy and the root node was filtered
fixed an issue in the cfl editor that lead to suggestions of methods not being inserted with a pair of braces leading to unintended behavior of cfl rules written using the cfl editor
fixed some crashes when using the Internet Explorer, however, we recommend using a modern browser due to various performance and rendering issues of outdated browsers
fixed an issue that caused calculated deviations to show ‘NaN’ instead of 'null' when the input values were 'null'
fixed an issue that caused calculated deviations to not being displayed despite no input value was 'null'
fixed an issue that caused labels of bar charts to not being displayed when they should being displayed in the bar due to not fitting next to it
fixed an issue that caused the matrix to incorrectly display hierarchies consisting of multiple explicit hierarchies
fixed an issue that caused empty columns being created when filters were set for column dimensions in deviation calculations
fixed some issues which were causing in-cell chart elements to overflow their cell
fixed an issue that caused the property initial row expand level to behave differently between hierarchies with one or multiple root nodes
fixed an issue that caused the search field in the Graphomate Properties Sheet to not show some properties
fixed an issue that caused the Graphomate Properteies Sheet to not apply changes made in search result view
fixed an issue of the matrix for Power BI that caused the graphomate Properties Sheet to be visible even when not in edit mode
fixed an issue of the matrix for Tableau online that prevented the matrix from being displayed correctly after reloading a dashboard when crosstab-like row headers were used
fixed an issue that prevented the matrix for SAC from being displayed when the scripting method openNavigationPanel from a standard visual was called
fixed an issue of the matrix for SAC that caused a newly created matrix widget to being inserted at the dashboard’s top left corner instead of being inserted where it fits in
fixed an issue of the matrix for SAC that caused in-cell chart font color to be gray instead of black
fixed an issue of the matrix for SAC that caused labels of pin charts to unnecessarily take too much space off the pin line when being displayed in the pin due to not fitting next to it
fixed an issue in the matrix for Lumira Designer that caused scenarios to not synchronize correctly with a matrix when changes were made in a graphomate chart
fixed an issue in the matrix for Tableau that caused the matrix to not apply changes of parameters, when displaying data bound to parameters
Improvements
improved the cfl editor to be way more convenient and include many templates
added aggregation type mean
added the aggregation type none
added calculated aggregations making it possible to configure aggregations for different rows, columns or hierarchy levels in implicit hierarchies
added property collapsibel on whole cell to configure the row header behavior when clicking on it
added property pin line on top for pin charts to conveniently create IBCS charts
added the possibility to configure the behavior of selecting cells by changing the property selection mode
added the property editability assignment to configure cells that should be editable
implemented automatic column width which can be achieved by setting a width of -1 for the properties default width or width per column
improved de-collision logic of chart labels to prevent them from overflowing the cell or overlaying the chart elements
implemented fixed row headers
added property custom css to inject your own CSS snippets for complex manipulations of the visual appearance
added cfl variables which can be configured in the Graphomate Properties Sheet and which can be accessed in Cell Formatting Language Rules to write reusable CFL scripts
added property calculated members to add custom calculated members
improved crosstab view to include dimension names of implicit hierarchies in the column headers
improved column headers to show only one occurrence of adjacently repeating header texts
implemented a live sorting feature that can be used by clicking on the sort signs which appear when hovering over a column header using the mouse
added Top/Bottom N + Rest calculations to display remainder columns or rows
added the property extra row padding to visually group parent and child nodes when using following result nodes
added property following result nodes to change the order of appearance of result nodes and their children
changed default values of outlier thresholds of charts to make common use cases (like the usage of pin charts for relative and bar charts for absolute data) more convenient
aligned cfl style 'root' with css class by changing the css class ‘cellRoot' of cell root elements to 'root’
added the property text ellipsis to cut header instead of wrapping them
added pin chart property Apply Scenario Color to Pin Head
added suggestions of JavaScript literal properties like array.length to the cfl editor
added properties good color, bad color and opacity to allow them getting configured differently for individual chart configurations
improved the selection of members for filter properties in the Graphomate Properties Sheet
added the option to select all members of dimension filter properties in the Graphomate Properties Sheet
added property background bar opacity
improved the usability and presentation of properties in the Graphomate Properties Sheet
implemented sorting of entries in lists by drag and drop in the Graphomate Properties Sheet
added duplicate functionality for list entries in the Graphomate Properties Sheet
improved lists to be resizable in the Graphomate Properties Sheet
added filter export and import for quick settings in the Graphomate Properties Sheet
improved tooltip values in the matrix for Power BI to now show formatted values
improved the scripting documentation of the matrix for SAP Lumira Designer and SAC
added the matrix for Power BI and Tableau to the respective shop sites
enabled the matrix component to expand nodes of an explicit hierarchy which were initially collapsed in the initial view of SAP Lumira Designer
added missing scripting methods and improved existing ones for SAP Lumira Designer and SAC
improved property initial row expand level to be changeable via scripting languages in SAP Lumira Designer and SAC