What's New?

For bug fixes and developer-facing changes, refer to the changelog page.

4.2.12

2021-01-27

No user facing changes were introduced in this version.

4.2.11

2019-05-17

No user facing changes were introduced in this version.

4.2.10

2019-04-03

Improvements

  • Measures evaluated as Strings are now supported in the filter creation popup.
  • Searching is enabled on the Quick Filter single select mode's drop-down.

4.2.9

2019-02-25

New Features

  • Possibility to pre-define the expansion order via Pivot Tables.
  • A visual hint on the next expansion levels has been added to Pivot Tables headers.
  • Ability to exit a widget's full-screen mode by pressing Esc.
  • Context menu entry to compute the difference between two columns in a Tabular View.

Improvements

  • UX improvements in the date range filter widget.
  • The widget chooser displayed by the "add new widgets" button is a popup with improved styling. It is therefore possible to drag and resize it.
  • The Cell Style popup is now resizable.
  • Ability to make the MDX Editor full-screen.
  • The chart chooser has been redesigned to look like the widget chooser. Charts are now categorized.
  • All popups resize naturally.
  • Search terms are highlighted in search results when searching in members filter popup.
  • Markers in the MDX Editor are converted to raw MDX while the user has the editor selected.

4.2.8

2019-01-23

New Features

  • Search results are displayed as a flat list instead of a tree. Only actionable items are shown. Results are navigable with ↑ and ↓ keys. If a result is clickable, pressing Enter ⏎ while that result is highlighted will trigger its action.
  • Ability to resize any table column by double clicking on its header's right border.
  • Our MDX and JSON editors have an embedded search.
  • In tree and search results, levels now have an icon with a subscript indicating their index.
  • Ability to refresh the discovery from a cube in the data explorer.

Improvements

  • The documentation website is responsive and has on-page navigation to easily see and browse the different sections of each page.
  • Redesigned Featured Values widget.
  • Redesigned popups.
  • Date format for "Date range" and "Starting/Ending date" filters has been updated to YYYY-MM-DD to include the year.
  • The "No Data" and "Query Error" messages and buttons are correctly centered in Internet Explorer too.
  • Renaming a server changes the name of all servers with the same URL.

4.2.7

2018-12-07

New Features

  • Ability to filter on a selection containing multiple elements through the context menu of Charts, Tabular Views, and Pivot Tables.
  • Single Value is replaced with Featured Values widget.

Improvements

  • Wizard redesigned to have different look and feel. Buttons renamed to Reset and Submit. Clicking on Reset resets the MDX but does not disable Deferred Update. One can only disable Deferred Update if no changes were made.
  • Some Quick Filter changes:
    • New "All" checkbox displayed on top of all the other ones when no members are selected.
    • The first member will be selected when displayed as radio buttons and nothing was filtered.
    • The selection will be reduced to a single element when displayed as a select or radio buttons.
  • Added options to hide axis and define some padding on chart axes.

4.2.6

2018-11-02

New Features

  • Ability to cancel an MDX query for charts, tabular views, pivot tables, drillthroughs and single values that is taking more than 3 seconds to load.
  • The documentation is now public. https://docs.activeviam.com/products/atoti/ui redirects to the latest published version.

Improvements

  • Ability to delete multiple point values in one shot from the "Parameter List" widget via the context menu.
  • Hovering on bookmarks displays title.
  • Popups from the wizard for columns, rows, and measures are resizable.
  • Popup for adding a column on the tabular view is resizable.
  • If a bookmark does not unload properly, the user is not alerted and is directed to the container chooser.
  • Queries that failed to execute, returned no data, or were canceled as well as bookmarks that failed to load, will display a standard message with an option to exit (depending on the situation: clearing the view, retrying the query, or resetting the query.)
  • Dashboard filters and context values are applied to new widgets even when there are no Filters or Context Values widgets in the dashboard.
  • Widgets created by loading a bookmark within a dashboard inherit dashboard filters and context values.
  • Popup when expanding a level on a pivot table is resizable.
  • If a selected container has a specified cube, the data explorer will show only that cube expanded.

4.2.5

2018-10-03

New Features

Improvements

4.2.4

2018-09-13

New Features

  • Chart Selection: possibility to "select" and highlight chart elements.
  • "Filter on" action in charts context menu to filter the dashboard based on the selected chart element.
  • "Drillthrough" action in charts context menu to explore a specific chart element's underlying data.

Improvements

  • Ability to change the formatting for ticks in charts. Can format as percentage, scientific notation, or k/M/B suffixes for thousands/millions/billions (e.g. 10,000 -> 10k).

4.2.3

2018-08-10

New Features

Improvements

  • The "Copy data to clipboard" and "Export to CSV file" actions respect the columns ordering, when used on pivot tables and tabular views.
  • Global filters display one row of filters per cube when widgets in the dashboard are connected to different cubes.
  • The "Add filter" popup remembers the last MDX filter type used per hierarchy and will default to this mode the next time a filter is created.
  • The Charts user documentation includes an overview of chart and axis options.

4.2.2

2018-07-11

New Features

Improvements

  • The original changelog has been split into two pages:
    • For user-facing changes, refer to the What's new? page.
    • For bug fixes and developer-facing changes, refer to the changelog page.
  • ActiveMonitor features have been documented.
  • It is not possible anymore to publish a formula depending on measures defined only locally (i.e. not published in the cube).
  • The "Edit Filter" popup can be resized.
  • The "Query Editor" popup can be resized.
  • The selection statistics style has been improved. Texts are smaller, values are aligned and can be compared more easily, negative values appear in red.
  • Resizable popups remember their sizes.
  • Numerical sorting icons were introduced in order to make sorting more intuitive on tables.

4.2.1

2018-06-01

New Features

  • Support for multiple role permissions in Content Server entries. Bookmarks, KPIs, and calculated measures can have multiple owner and reader roles.
  • Period input for Monitor creation in "Scheduled monitoring" mode.

4.2.0

2018-05-23

New Features

Improvements

  • "Return to charts" button when choosing mandatory chart attributes (usually X and Y). It will bring the user back to the chart type chooser.
  • Possibility to edit the name of an existing KPI.
  • Improved widget title edition: a text cursor is displayed on hover and only a single click is required to enter the edit mode.
  • Prefix default widget title with "Untitled" and remove random number suffix.
  • Display title bar for all widgets by default.
  • Improved search placeholders by making them context specific.
  • Renamed the “Query Editor” widget to “MDX Editor” to distinguish it from the “Query Editor” popup, which contains both MDX Editor and Context Values widgets.
  • Disable Login popup submit button if username or password is undefined.
  • Added an error message in the Login popup for failed logins.
  • Default MDX for Pivot Table and Tabular Widget includes the following cell properties by default: VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR and FONT_FLAGS.
  • Break long captions in table headers more intuitively, by first trying to break between words and if not enough resorting to break between letters inside a word.
  • Error messages only display the relevant error message and are displayed as notifications. The error stack trace is still accessible via the console.

Notes

  • New look and feel based on Ant Design design system.
  • Rebranded the library from ActiveUI to ActiveUI SDK.

4.1.13

2018-03-16

New Features

  • "Recent date members" date filter. This filter allows users to select and filter on a desired number of the most-recent date members existing in the data.
  • "Quarter/month/day of week" date filter. This filter allows users to filter on specific weekdays (e.g. Monday and Wednesday), or specific months (e.g. March, April, June, etc.), or specific quarters (e.g. second and third quarters).

Improvements

  • Ability to define a new container category when marking a bookmark as favorite.
  • Made a distinction between imposed widgets from user favorites. The action "Restore default widgets" is replaced by "Show all default widgets".
  • Simplified row-action plugin with methods like getIconKey and onClick that will render an icon button, instead of having to write the render method.
  • Improved legend docking control with a button for each 3 states instead of one looping through them.
  • Bookmark popup enables the submit button only if the bookmark content is valid and, in case of edition, only if the bookmark has changed.
  • Removed some useless elements from chart legends. They can still be accessed from the "Options" popup.
  • Removed the "by" keyword in the chart legend that lists the mapping of each attribute.
  • Search in data explorer tree only applies to the focused cube.

4.1.12

2018-02-12

New Features

  • Undo/redo keyboard shortcuts and actions.
  • Reset to default view action on dashboards.
  • Automatic restore of the last view the user was working on.
  • Copy table to clipboard.
  • Parameter list widget.
  • "Starting/Ending date" filter.
  • "Relative dates" filter.
  • Dock action to restore the SDK default widget tiles in the dashboard.

Improvements

  • Global filters and global context values are automatically applied to new widgets.
  • Empty chart legends display "No legend" when empty instead of displaying nothing, for clarity.
  • Error messages for server errors with no included description are clearer.
  • Chart legends now display only the first 10 members of each attribute section. The next ones can be seen by clicking on "More".
  • Chart legends show the color first, then the other attributes and finally the "Split by" section.

4.1.11

2018-01-09

New Features

  • New "Combo chart" implementation. This replaces the old multi-layer chart implementation.

Improvements

  • Removed the chart type chooser for charts which do not need it anymore.
  • When the user chooses the folder to save a bookmark in, show an error if they don’t have permissions to save in that folder.

4.1.10

2017-12-07

New Features

  • With the Deferred Update checkbox in the Wizard, you can prevent changes in the wizard from updating the query until you are ready to commit them. This helps you avoid running an expensive query while you are still editing it.
  • MDX "date range" filter.

Improvements

  • Add activation/expiration editing in the ParameterList.

4.1.9

2017-11-25

New Features

  • Lazy loading is enabled by default on new tabular widget and pivot table.
  • Publish calculated measures to a cube, and delete published measures.

Improvements

  • Optimize communication with the content server concerning the bookmarks.
  • Bookmarks ID is displayed in bookmark’s tooltip.
  • Server version is displayed in server’s tooltip.
  • Add some regular actions (like sort, etc) on alert list/message list widgets.
  • Enable “Filter On” for pivot table tree cells.
  • Filter on measures now displays the list of measures inside the filter UI instead of an extra popup.

4.1.8

2017-10-27

New Features

  • Edit a monitor from a monitor view.
  • Now all the actions for docks are hidden in a hamburger button. The attribute quickActions was introduced in the bookmark head in order to force some actions to be outside of the menu.

Improvements

  • The Delete KPI popup now displays a warning when the assisted deletion of parameters and monitors would also affect some other KPIs.
  • Enable context menu on tabular and single value even if the widget cannot render (no data, server exception, ...).
  • Update Drillthrough context menu to have the same update query mode actions than other widgets.
  • Possibility to drillthrough from a MonitorView.
  • Some popups are resizable.
  • Hitting Escape closes popups, context menus and error messages.
  • Focus bookmark name field on opening.
  • Never show a popup for warning issues.

4.1.7

2017-09-28

New Features

  • Add Calendar filter support for dates.
  • Add filters by copy/pasting a list of members (aka "split text to members").
  • Add auto-resizing of tabular headers height, when double-clicking on the lower bar of the tabular header.
  • Bring the ability to format a formula while creating it.

Improvements

  • Ability to apply a global filter from a table cell.
  • Simplified the interface for editing attributes and mappings of charts by replacing the Add button with a tab within Options.
  • Made the formatting visible on the first screen in the conditional formatting popup, instead of being in 'default condition'.
  • Restrict exclude filter checkbox when non applicable.
  • Prevent tooltip from overflowing when data is too long.
  • Improve filter popup layout to better support translations having long texts.

4.1.6

2017-09-01

New Features

  • Bring the ability to delete ActiveMonitor attributes (parameters and monitors) related to a KPI while deleting that KPI.
  • Add 'Filter on...' context menu entry in tabular headers.
  • Add 'Refresh' and 'Refresh periodically' actions in context menus.
  • Bring back the ability to filter on a member when right-clicking on it (the old keep-only feature of ActivePivot Live 3) in tabulars.

Improvements

  • Added the possibility to remove sorting on a column in Tabulars & Pivot Tables using MDX data sources.
  • Increase the size of the '+' icon in the Wizard & Charts, and of the down arrow in tabulars & Pivot Tables.

4.1.5

2017-07-25

New Features

  • Ability to add bookmark favorites in the tiles of the dock, to remove tiles of the dock.
  • Ability to exclude members from the UI.

Improvements

  • Improved resizing of tiles in the dock.
  • When wanting to drag and drop a bookmark somewhere, tuned the threshold which switches between using the full size of the dock, or splitting it horizontally/vertically to be more forgiving to users wanting to use the full size of the dock.

4.1.4

2017-06-29

Improvements

  • Pivot table, Tabular view, Drillthrough, Chart, Single Value... displays a loading sign when query is running.
  • Query error message are displayed inside the associated widget.
  • Color highlighting on cell update is applied between queries (even when changing context values, drill down...).
  • Auto-fill folder name when doing "Save As" on a bookmark located in a folder.
  • Disable search bar while members are loading in the Members filter section.
  • Improve layout of the ActiveMonitor message popup, when the content gets huge, by adding scrollbars vertically and horizontally when needed.
  • Hamburger buttons in the dashboard have tooltips.
  • The TreeMap chart makes the color mapping mandatory, since users rarely want to see only one colored area (just like they rarely want to see a Pie Chart with just one area).
  • Reword the button labels in the “Open drillthrough” popup so they are clearer.
  • Improve the popup to add new widgets, by changing the cursor to a grabbing hand and increasing the font size.

4.1.3

2017-05-17

New Features

  • Add a login popup for the Cloud, when the session expires, to redirect the user to the Keycloak login screen.
  • Load dashboard bookmarks by clicking on them.
  • KPIs can now be put inside folders.
  • Tabular view and pivot table headers can now be resized vertically.

Improvements

  • Bookmark location/path can now be edited from the bookmark context menu.
  • Conditional Formatting now supports and understands IIF(...) conditions in the MDX, in addition to CASE statements.
  • The Goal can now be any number in the Gauge Chart – it was limited to 100.
  • Display measure name with KPI attributes in the discovery if relevant.
  • Wizard, tabular view and filter support KPI functions.
  • Clearer indentation of tree elements.
  • Display name instead of unique name while loading list of members in filter popup.
  • Improve default color set for Pivot Table tree cells + making it configurable.

4.1.2

2017-04-07

New Features

  • Add a line y = mx + b on scatter plot charts through the UI.
  • Add a constant line y = b on all charts with x and y axes, through the UI.
  • Allow starting and stopping applications (VMs) from the UI by right-clicking on an application node.

Improvements

  • Increase drop area size in wizard sections + add padding on the left of the wizard when it is next to a pivot-table.
  • Improve the usage of screen space in trees: Do not reserve space on the right when no scrollbar is displayed.
  • Improve the Submit button of the MdxEditor, which now displays a tooltip when hovered explaining the reason why the button is disabled.

4.1.1

2017-03-22

New Features

  • Select / drag-and-drop dimensions and hierarchies from the data-explorer, field choosers, etc., everywhere in ActiveUI!
  • Table and chart tooltip displays custom MDX cell and member properties
  • Add regression overlay for charts, available for scatter plots and charts with a time axis.
  • Ability to select/unselect all drillthrough columns.
  • Display cell and member properties on hover.

Improvements

  • Add server popup now displays server version and validates the server type.
  • Add support for KPI lookup in the '+' feature of the Wizard.
  • Improved bookmark loading time, mainly at startup.
  • Preserve cursor position in the Formula Editor, and when clicking on a tabular/pivot table header, insert this header at the current cursor position.

4.1.0

2017-02-10

New Features

  • Add 'plus' buttons in the wizard widget to be able to add filters / rows / columns / measures directly from it.
  • Add support of calculated measures in the PivotTable.
  • Add renaming of a bookmark by double-clicking on its title.

Improvements

  • Support non-breaking sort in pivot tables. Added parameter to control default sorting mode in tabular / pivot-table.
  • Improve MDX validation on unknown cube name.
  • Add autocompletion for cube name.
  • Improve chart usability with high cardinalities by avoiding some un-needed expensive operations on hover/resizing.
  • Prevent KPI submission if value nor status are defined, or when one of the MDX formula forming the KPI is invalid.
  • Improved the way filter names are displayed in the wizard, especially when they are long.
  • Add server versions in report.
  • Change cursor as grabbing on draggable items.
  • Display a small icon when a member of a KPI is syntactically invalid.
  • Supports formula as KPI value.
  • Improve the 'Add Filter' flow / popup to be more intuitive, and require less clicks. Change the icon of filter bookmarks to a filter icon.
  • Improve mouse hovering behavior, most notably on charts and dashboard docks.
  • Support formulas already declared in the MDX when writing a new formula (validation + auto-completion).

Notes

  • Since QuartetFS has been rebranded into ActiveViam, renamed ActivePivot Live into ActiveUI

4.0.12

2016-10-11

New Features

  • Ability to export charts to PNG. (Does not work on IE, Edge or maps).
  • Ability to remove a server from the UI (and from the settings stored in the content server).

Improvements

  • Allow named sets to be dragged into pivot wizard.
  • Add a cross to clear entry in search bars.
  • Allow to clear or remove a container where bookmark failed to load.

4.0.11

2016-09-15

New Features

  • Global Context Values.

Improvements

  • Rules Editor performance with one parameter.
  • Improve parameters pseudo-real-time update by fetching only changes and not submitting unmodified values.
  • Add action in discovery tree to show/edit a KPI directly.
  • Provide UI option for forcing min and max range on a chart numerical axis.
  • MdxEditor does not send anymore automatically the MDX. Buttons allow user to send or remove query.
  • Always display a cross in the upper right corner to close a popup, even for autoclose popups.

4.0.10

2016-08-12

New Features

  • Add row actions and context menu actions to Monitor List.
  • Add view to see details of a single monitor.
  • Added an 'About' button available on dashboards.

Improvements

  • Improve alert list to offer a real interface to browse alerts.
  • Chart mapping dialog options are now located in a separate tab.

4.0.9

2016-07-27

Improvements

  • Update support for expand and collapse in treecell.
  • Improve chart creation by always starting with an empty configuration and ask users to specify what they want for the mandatory attributes, so that there is no unexpected result.

4.0.8

2016-07-06

New Features

  • Global filters and filters inside a dock that can be shown using a dock action.

Improvements

  • In the rules viewer (where we enter the rule values), the wildcard fields now register the value when hitting enter or tab, or even clicking outside (hit escape to cancel). Same thing for the cell editors in the tabular view above.
  • When opening a Drillthrough from a Tabular View or Pivot Table the user can now choose where to open it. Previously it could only be opened in a popup now it can be open in the dashboard, similar to ActivePivot Live 3 behavior.

4.0.7

2016-06-25

New Features

  • Add quick filtering.
  • Introduction of mdx bookmarks that are draggable to filter sections.

Improvements

  • Improve drag/drop by removing a dock from the dashboard as soon as we start dragging it. This provides a better preview of how it is going to look after dropping.

4.0.6

2016-06-17

New Features

  • Add a container to display lists of monitors.

Improvements

  • Login popup is modal, non cancellable.
  • Popups are now correctly centered.
  • MDX Editor autocompletion: Add MDX calculated members and namedsets.
  • MDX Editor autocompletion: Add cube namedsets.
  • MDX editor validation: check MDX type, reject unknown compound ids, measures or functions.
  • Sever error message are displayed as regular stacktrace and most relevant message is shown.
  • Add reporting tool for debug in case of error.
  • Be able to change theme on different components.

4.0.5

2016-06-03

Improvements

  • Add context values widget.
  • Add delete KPI context menu.
  • Skip cube selection tree when creating a widget and there is only one cube available.
  • Display a stepper in the create KPI Popup, that allows returning to the previous step too.
  • Display the chart switcher when creating a new chart container instead of directly showing a scatter plot.
  • Allow the modification of the SingleValue through a context menu (edit the measure, title and description).
  • The rules editor now allows the user to work with worflows instead of monitors.
  • Improved Tabs look and feel (used for now only in the KPI Editor under custom edition).
  • New Chart UI to see multiple measures on the same line or bar chart by clicking on the '+' button of the Y axis.

4.0.4

2016-05-11

Improvements

  • Add tooltip on wizard tiles.
  • Add tooltip on filter tiles.
  • Add tooltip on tabular header and cell.
  • Display clearer error message when ActivePivot server is unreachable.
  • Use tree layout for measures rather than tabular tree in member selection popup.
  • Improve wording for dock actions from "Change type" and "Close" to "Clear" and "Remove".
  • Improve Rules Editor user experience by providing KPI information at the top (type and measure used as the KPI value, as well as a read-only popup with all the information when clicking on the type icon).
  • Add an "export to CSV" feature available on charts, pivot tables and tabular views.
  • Mdx formulas editors in the KPI popup are now bigger (we only display one at a time using tabs).

4.0.3

2016-05-02

Improvements

  • By default on the new tabular views/pivot tables, the measures KPI start and expiry will be grouped together in a column that displays progress bars.
  • Leave some time (1s) before loading an existing KPI while typing a KPI name in the KPI editor.
  • Clicking on "remove" in the context menu of a drillthrough table header removes the corresponding columns from the MDX query.
  • The rules editor refreshes the parameters automatically thanks to a polling.
  • Chart global context menu for multi-layered chart shows option for state (dataSource options are still specific to each layer).
  • Log the user out after a configurable period of inactivity (disabled by default).
  • Multi-layered charts mapping can be changed via the UI.
  • JSON can be folded in the state editor.
  • The style of the sparkline column is maintained when adding colors to the sparklines.
  • Measure pickers allow to choose KPI attributes.
  • Don't display add button for pivot tables.

4.0.2

2016-04-25

Improvements

  • Charts
    • Charts display missing axes in the legend so that they can be mapped easily from the UI.
    • Prevent mapping an field from the data explorer to a chart attribute when the types are not compatible.
    • Support multi-layer charts.
    • Allow removal of automatic mappings in charts.
  • Containers (Dashboard)
    • A selected container is only highlighted when another container is reading information from it.
    • Containers define their icon and category so that it's simpler to add another one.
  • Miscellaneous
    • Make the color and size of KPI icons more consistent.
    • Lookup columns in tabular views are editable directly by changing the cell value.

4.0.1

2016-04-15

Improvements

  • Drillthrough improved query execution by allow user to select columns before starting.

4.0.0

2016-04-08

  • First official release
← Getting StartedFrequently Asked Questions →