Skip to main content

Changelog

5.1.8

2023-08-31

Added

  • Markdown tables in the Text editor widget have borders between rows.
  • Ability to display tooltips on tables.
  • Folder paths are displayed in the results of the dashboard and folder search at the top of the home page and in the Open dashboard modal.
  • KPI properties can be styled in the Style editor.
  • Tooltips on wizard tiles and table headers that are so narrow that a part of the text they contain is hidden, allowing users to view their full text by hovering over them.

Changed

  • In the KPI widget, values of measures are evenly spaced.
  • The About modal displays the version of each Atoti Server that the application is connected to, not just the first one.

Fixed

  • Unexpected "The page or dashboard filters were changed. If this is intentional, do it from the filters editor" error while editing the query of a widget in the Query editor.
  • Cannot submit valid MDX in the Query editor when it contains complex expanded members.
  • Chart legends sometimes fail to show the trace names.
  • CSV exports containing [object Object] for some cells.
  • The application freezes for a few seconds when the user opens the Edit filter popover on a level containing many members.
  • "Expression cannot be resolved as a member of cube" error when accessing a widget whose query contains a query-scoped named set.
  • When multiple KPI properties are added to a chart, only the first one actually appears on the chart.
  • Filters on date ranges saved in Atoti UI 4.3 unexpectedly appear as "custom" after migration.
  • Broken link to documentation in Help submenu.
  • Cell font colors don't work on the first few columns when the table containing them is resized and made so thin that the frozen columns become larger than the whole width of the table.
  • The order of the colors and labels of bar charts does not match the order of their corresponding bars when the chart is sorted and has a conditional style.
  • In the Style editor of table widgets, the inability to control the alignment of non numeric measures.
  • When conditional style is added to a measure in a table, its values become unexpectedly left-aligned.
  • The user is unexpectedly switched from Present to Edit mode when opening a dashboard which they are allowed to edit.
  • Editing pinned filters incorrectly removes non-pinned filters within the same section.

5.1.7

2023-08-03

Changed

  • The About modal displays the version of each Atoti Server that the application is connected to, not just the first one.

Fixed

  • Table scrolling out of sync between cells and row and column headers.

5.1.6

2023-08-01

Added

  • In the Style editor, ability to edit the date format of levels of type "TIME".
  • Ability to remove widgets with errors from dashboards.
  • Select all can be used on the search results in the Filter on hierarchy popover.
  • Exclude selected members checkbox in the Filters bar dropdown.

Changed

  • The login page, loading background and header are redesigned.
  • The light-activeviam and dark-activeviam themes are changed.

Fixed

  • ERR_MODULE_NOT_FOUND error thrown when importing @activeviam/activeui-sdk on Node.js.
  • Number formatting discrepancies for users with a browser locale different than "en-US" after they adjust the number of decimals of a measure through the Style editor.
  • Application submenus disappear when hovering on nested submenus.
  • When targeting a 5.11 Atoti server, clicking the Move button in the Move to modal on the home page fails, showing an infinite spinner on the button.
  • "No data model was found [...]" or "Cube not found [...]" error when the last cube used by the user is not available.
  • The Export to CSV menu item unexpectedly generates multiple rows for the header row, and treats cell values containing the CSV separator as multiple values.
  • "Error: contributors.COUNT cannot be used when smart filtering the query to fetch members of [dimension].[hierarchy], because it is a virtual hierarchy" error when attempting to edit a pinned virtual hierarchy filter.
  • Spaces in measure and level names sometimes disappear when using the search.
  • "Undefined widget state. This is not supported" error when rendering a <Widget /> outside a dashboard.
  • KPI widget values ignoring the color specified in the MDX query result.

5.1.5

2023-06-30

Added

  • Ability to move the selection in table widgets using the , , , , Home, End, Page Up, Page Down keyboard keys, also in combination with the Shift key to extend the selection.
  • The Inherit destination folder permissions checkbox in the Move modal to enable inheriting the permissions of its destination folder.

Fixed

  • Changing the target cube of a widget unexpectedly changes the target cube of drillthrough tables in the dashboard.
  • "TypeError: mp (the combination of letters can be different) is not a function or its return value is not iterable" error thrown by a widget that has been right-clicked.
  • The application crashes with a No plugin of type "widget" was found for the key ... error when the user accesses a dashboard containing a widget whose key is not registered.
  • The tooltip overlapping the context menu on pie and donut charts.

5.1.4

2023-05-31

Added

  • Ability to move a widget to another dashboard page by dragging and dropping it on top of it.
  • Pinned exclusion filters have an exclude icon.

Deprecated

  • pageKey argument of moveWidget. Use originPageKey and targetPageKey instead.

Fixed

  • "Module not found: Error: Can't resolve 'util'" error thrown when running yarn build in the starter source.
  • The label of some menu items is not displayed under some specific screen size and zoom settings.
  • Expand/collapse carets are unexpectedly shown in the search results tree of the Filter on hierarchy popover.

5.1.3

2023-04-27

Deprecated

Fixed

  • Creating a folder in the Saved filters panel causes the Back to Data Model button to become hidden.

5.1.2

2023-03-31

Added

  • Copy query to clipboard and Refresh query menu items to the Drillthrough widget.
  • smartFiltering.nonEmptyEvaluationMeasureName setting allowing to set the measure used to filter out empty members in the list presented to the user when creating or editing a filter. Members with no value for this measure are considered empty and are omitted from this list.
  • Make a copy menu item in the home page, allowing to make a copy of a dashboard.
  • configuration.routes, allowing to define custom URLs for your application and register the components that should be displayed when users visit these URLs.
  • lastUsedCube property in the user activity, keeping track of the cube that was last used by the user.

Changed

  • When a new widget is added to a dashboard, it connects by default to the cube that the user used last, instead of connecting to the first cube of the first server.
  • The cube selector shows the cube's caption instead of name.

Removed

  • Unexpected Copy link button in the Share modal when sharing filters or widgets.

Fixed

  • The Select all checkbox in the Filter on hierarchy popover does not work when the hierarchy is virtual.
  • The vertical scrollbar in the Saved filters and the Saved widgets panel does not allow to access the elements at the bottom of the list.
  • White screen and No data model was found error in console when a dashboard is opened before the data model has finished loading.
  • After sharing a saved widget with another user as a reader, this user is unexpectedly allowed to rename, share and delete this widget. The same applies to saved filters.

5.1.1

2023-03-02

Added

  • "Switch widget type" menu item, allowing to open the widgets panel from a widget's context menu.
  • Share menu item added to the File application menu.
  • New dashboard menu item added to the File application menu, allowing to create a new dashboard without needing to navigate back to the home page first.

Changed

  • In the Data model, measure folders can be opened by clicking on their names, not only on the carets on their left.
  • Users with the canManageContent permission set to false can create ad-hoc dashboards, but are still not allowed to save them.
  • In the Advanced tab of the Filter on hierarchy popover, when searching for a measure the results are sorted alphabetically.

Fixed

  • The File > Save menu item is unexpectedly disabled when users create a dashboard.
  • Rows with an index bigger than the lazy loading chunk size not loading in tables with a wide row header.
  • Tables unexpectedly scroll all the way back left when users click a cell.
  • Extra padding at the right of table widgets vertical scrollbar.

5.1.0

2023-02-02

Added

  • Ability to pin filters to display them in a Filters bar over a widget or dashboard. It allows to edit a filter outside of the Filters editor, even in Present mode.
  • Ability to configure cross-hierarchies expansion chains for tables from the Content editor. Each level in the expansion chain is displayed as a subtile and can be moved or deleted individually.
  • widgets permission, allowing to control what widgets the user has access to.
  • widgetMenuItems permission, allowing to control what menu items the user has access to in the widget's context menus.
  • widgetTitleBarButtons permission, allowing to control what buttons the user has access to in the widgets' title bars.
  • applicationMenus permission, allowing to control what menus the user has access to in the application header.
  • tools permission, allowing to control what tools (previously called "drawers") the user has access to in the application left panel.
  • Ability to show values as text on charts. This can be done using the Data labels switch in the Style editor.
  • WidgetPlugin.attributesDrivingColors: indicates which mapping attributes can be used to apply custom colors using the Colors editor.
  • Ability to pass an AbortSignal to asynchronous operations which do not have side effects. This includes many methods of ActivePivotClient and ContentClient.
  • Support for nested measure folders in the Content editor.
  • createCalculatedMember, createKPI, deleteCalculatedMember and deleteKpi methods in ActivePivotClient

Changed

  • New widgets and saved widgets can be added by opening the Insert -> Widgets menu in the application header (shortcut W), then selecting them from the panel that appears over the Data model.

  • Saved filters can be added by opening the Insert -> Filters menu in the application header (shortcut F), then selecting them from the panel that appears over the Data model.

  • Saved calculated measures are persisted to the cube instead of the /ui folder on the Content Server. This has the following implications:

    • Saved calculated measures appear directly in the Data model.
    • They can be renamed/deleted only globally from the Data model, as opposed to locally on a widget.
    • Calculated measures saved with Atoti UI 5.0 are not usable out of the box in Atoti UI 5.1, but you can migrate them using atoti-ui-migration.
    • Calculated measures created and saved with Atoti UI 5.1 are usable in Excel.
  • The Drawers previously located on the left of the dashboards are renamed Tools and moved to the right of the Data model.

- import { Drawer, drawerQueryEditor } from "@activeviam/activeui-sdk";
- const myDrawer: Drawer = {};
- configuration.drawers.push(drawerQueryEditor, myDrawer);
+ import { Tool, toolQueryEditor } from "@activeviam/activeui-sdk";
+ const myTool: Tool = {};
+ configuration.tools.push(toolQueryEditor, myTool);

The following exports are also renamed:

- const hierarchy = cube.dimensions.find(dimension => dimension.name === myDimensionName)?.hierarchies.find(hierarchy => hierarchy.name === myHierarchyName);
+ const hierarchy = cube.dimensions[dimensionName].hierarchies[hierarchyName];
  createActivePivotClient({
url,
+ serverVersion: "6.0.0",
+ serviceVersion,
- version: serviceVersion,
requestInit,
}),
-  import { MenuItemCreateFolder } from "@activeviam/activeui-sdk"

- <Menu {...menuProps} onClick={props.onClick}>
- <MenuItemCreateFolder {...menuItemProps}>
- </Menu>

+ import { useMenuItemCreateFolder } from "@activeviam/activeui-sdk"

+ const menuItemCreateFolder = useMenuItemCreateFolder(menuItemProps)
+ <Menu {...menuProps}
+ onClick={props.onClick}
+ items={[menuItemCreateFolder]}
+ />

The API to define your own menu items is changed accordingly:

- const MenuItemFoo = (props) => {
- return (
- <MenuItem onClick={props.onClick}>
- <div>
- <FooIcon />
- Foo
- </div>
- </MenuItem>
- );
- };

+ function useMenuItemFoo(props) {
+ return {
+ onClick: props.onClick,
+ icon: <FooIcon />,
+ label: <div>Foo</div>,
+ };
+ }

To use in a plugin:

  const pluginMenuItemFoo = {
key: "foo",
- Component: MenuItemFoo,
+ useMenuItem: useMenuItemFoo,
};
  • Node.js >= 18.12.1 is required to use @activeviam/activeui-scripts and @activeviam/content-server-initialization.
  • UserGroupNamesProvider is renamed UserRolesProvider.
  • The canShare permission controls the ability to share content. The user role ROLE_SHARE is no longer supported.
  • The key of the Save widget as menu item is changed from save-as to save-widget-as. The pluginMenuItemSaveWidgetAs must be explicitly added to each applicable widget's menu items.
  • The MeasuresFolderNode accepts both measures and measure folders as children.
  • addFormula is renamed addCalculatedMeasure.
  • Minimum required version of the supported browsers.
  • pathToFolder is renamed pathToParentFolder in the arguments of the following ContentClient methods: fetchThumbnails, fetchThumbnail, fetchFile, createFile, createFolder, deleteFilesAndFolders, updateFile, updateFolder, updateFilePermissions and updateFolderPermissions.
  • getMeasures is renamed getMeasureNames and returns an array of strings.
  • Filters are no longer typed as Mdx. Instead, they are typed as:
  • Properties canRead, canWrite, isDirectory, lastEditor, and timestamp are required in ContentEntry by default. If you want to type entries that are meant to be sent in PUT/POST requests, use ContentEntry<"request"> instead.
  • Query context values used in query.context and queryContextEntry.value are typed as string.
  • pluginWidgetPlotlyComboChart is renamed pluginWidgetPlotlyColumnsAndLinesChart. Its plugin key plotly-clustered-column-and-line-chart is renamed plotly-columns-and-lines-chart.
  • The cube argument is mandatory in getMeasure.
  • The name property of AMetaData is mandatory.
  • Property levelIndex on FilterOnTopBottomMembers is replaced with levelName.
  • The key property of ApplicationMenu is mandatory.
  • The parameters of the onTileMovedFromExtraSection function in DataVisualizationContentEditorProps:
    • The item parameter is renamed dragItem.
    • The toSection parameter is replaced with toPosition, of type TilePositionWithinWizard.
  • The version property of WidgetMetaData is mandatory.

Removed

  • activeui-scripts generate-css. This is no longer needed with the drop of less in favor of CSS-in-JS in antd 5.
  • The Widgets ribbon. Use the Insert -> Widgets menu (shortcut W) in the application header instead.
  • withCube higher-order component. Use the useCube hook instead.
  • userFilters.areEnabled setting. Use the canUseUserFilters permission instead.
  • userQueryContext.isEnabled setting. Use the canUseUserQueryContext permission instead.
  • calculatedMeasures.areEnabled setting. Use the canUseCalculatedMeasures permission instead.
  • ContentClient.moveFile method.
  • ContentClient.moveFiles's requestOptions option.
  • getLastEdition function. Use getMetaDataRecord instead.
  • LeafProps.isDeferred property.
  • useMenuItemMoveFileOrFolder hook.
  • useWidgetQuery hook.
  • header <Tree /> prop.
  • fetchAvailableDrillthroughColumns method.
  • authenticate function.
  • PopoverPositionWithinWizard type.
  • RootTilePositionWithinWizard type.
  • SubtilePositionWithinWizard type.
  • WizardProps type.
  • WizardSection type.
  • WizardTile type.
  • WizardTileWithChildren type.
  • LazyLoadedCellSetTableProps type.
  • TableProps type.
  • SelectionAnchor type.
  • GridKey type.
  • SelectionRange type.
  • FieldDraggedFromDataModelTree type.
  • MeasureDraggedFromDataModelTree type.
  • LevelDraggedFromDataModelTree type.
  • HierarchyDraggedFromDataModelTree type.
  • DimensionDraggedFromDataModelTree type.
  • KpiPropertyDraggedFromDataModelTree type.
  • DraggedWidget type.
  • LeafProps type.
  • CellIndices type.
  • Hash type.
  • Locale type.
  • TranslationParameter type.
  • TranslationParameters type.
  • useDrillthroughColumns hook.
  • useMultiSelection hook.
  • getPathToFolder function.
  • isDimensionNode function.
  • isHierarchyNode function.
  • isMeasureNode function.
  • isFieldDraggedFromDataModelTree function.
  • isDraggedDimension function.
  • isDraggedHierarchy function.
  • isDraggedLevel function.
  • isDraggedMeasure function.
  • isMdxCompoundIdentifier function.
  • isMdxFunction function.
  • getMeasuresAxisName function.
  • deriveMappingFromMdx function.
  • sortTreeAlphabeticallyAndFoldersFirst function.
  • LazyLoadedCellSetTable component.
  • FileExplorer component.
  • Table component.
  • Wizard component.
  • activeUIOverlayRootId.
- import { activeUIOverlayRootId } from "@activeviam/activeui-sdk";
- const getPopupContainer = () => document.getElementById(activeUIOverlayRootId);
+ import { useContext } from "react";
+ import { ConfigProvider } from "antd";
+ const { getPopupContainer } = useContext(ConfigProvider.ConfigContext);
  • SelectionListenerPlugin type.
  • pluginSelectionListenerFilterOtherWidgets plugin.

Fixed

  • Member unexpectedly expanded down to its children in its own hierarchy when the user expands it down to a different hierarchy, collapses it and then re-expands it.
  • Missing tooltips on corrupted tiles (highlighted in red) in wizards.

5.0.28

2023-08-31

Added

  • Markdown tables in the Text editor widget have borders between rows.
  • Ability to display tooltips on tables.
  • Folder paths are displayed in the results of the dashboard and folder search at the top of the home page and in the Open dashboard modal.
  • KPI properties can be styled in the Style editor.

Changed

  • When a dashboard is shared with a user as reader, they have access to the Data model and Tools on this dashboard (reverts a change made in 5.0.22).
  • In the KPI widget, values of measures are evenly spaced.
  • The About modal displays the version of each Atoti Server that the application is connected to, not just the first one.

Fixed

  • Unexpected "The page or dashboard filters were changed. If this is intentional, do it from the filters editor" error while editing the query of a widget in the Query editor.
  • Cannot submit valid MDX in the Query editor when it contains complex expanded members.
  • Chart legends sometimes fail to show the trace names.
  • CSV exports containing [object Object] for some cells.
  • The application freezes for a few seconds when the user opens the Edit filter popover on a level containing many members.
  • "Expression cannot be resolved as a member of cube" error when accessing a widget whose query contains a query-scoped named set.
  • When multiple KPI properties are added to a chart, only the first one actually appears on the chart.
  • Filters on date ranges saved in Atoti UI 4.3 unexpectedly appear as "custom" after migration.
  • Broken link to documentation in Help submenu.
  • Cell font colors don't work on the first few columns when the table containing them is resized and made so thin that the frozen columns become larger than the whole width of the table.
  • The order of the colors and labels of bar charts does not match the order of their corresponding bars when the chart is sorted and has a conditional style.

5.0.26

2023-08-01

Fixed

  • Charts sometimes not resizing.
  • Number formatting discrepancies for users with a browser locale different than "en-US" after they adjust the number of decimals of a measure through the Style editor.
  • KPI widget values ignoring the color specified in the MDX query result.
  • The Export to CSV menu item unexpectedly generates multiple rows for the header row, and treats cell values containing the CSV separator as multiple values.

5.0.25

2023-06-30

Added

  • When searching for a hierarchy in the data model, its child levels are displayed among the results.

5.0.24

2023-05-31

Added

  • Share context menu item allowing to share saved widgets.

Changed

  • Drillthrough tables dragged and dropped from the widgets ribbon into a dashboard do not have any columns, until the user selects some.

Fixed

  • Errors such as "The level index 5 is greater than the number of levels in the hierarchy [Booking].[Desk] (5) in cube EquityDerivativesCube." when pasting custom MDX in the query editor.
  • Translations for the sorting menu items in the context menu of table widgets are not properly displayed unless the pluginMenuItemSortPivotTableDescendingly and pluginMenuItemSortPivotTableAscendingly plugins are registered.
  • Expand/collapse carets are unexpectedly shown in the search results tree of the Filter on hierarchy popover.

5.0.23

2023-04-27

Added

  • The Tree table widget supports lazy loading.
  • Table size option in the Style editor of the Pivot table, Tree table, and Table widgets, allowing to make these widgets more compact.
  • table.defaultSize setting, allowing to control the default value of the table size for a user or a group of users.
  • table.animations.areEnabled setting to toggle whether or not to animate changes in tables.
  • table.animations.duration setting to set how long animations for changes in tables take place.
  • table.animations.threshold setting to set the threshold per measure before animating changes in tables.
  • Non contiguous ranges of cells can be selected in tables by holding Ctrl / Cmd or Shift while clicking or dragging.
  • Show all totals menu item under the Totals submenu of the table widgets context menus, allowing to show or hide all totals at once.

Changed

  • The Export to CSV menu item generates a CSV table that corresponds exactly to the table on screen instead of pivoting the hierarchies it has on columns onto its rows.
  • The Export to CSV menu item allows to export full tables, even when they are lazy-loaded.
  • The items in the Totals submenu in the context menu of table widgets are accessible on the whole table, with no condition on the cell from which the menu was opened.

Fixed

  • Unable to remove all decimals from a measure in the Style editor.
  • The Filter on popover loads for a long time when it is opened on a hierarchy containing many members.
  • Saving dashboards in a folder with edit rights sometimes does not work if the folder was created by a different user.

5.0.22

2023-03-31

Added

  • Ability to add named sets to a widget by clicking on them in the Data model.

Fixed

  • When a dashboard is shared with a user as reader, they unexpectedly have access to the Data model and Tools on this dashboard.

5.0.21

2023-03-01

Fixed

  • Rows with an index bigger than the lazy loading chunk size not loading in tables with a wide row header.
  • Drillthrough table widgets lack columns when their MDX query is custom and contains the MemberValue for these columns but not their Caption.
  • Tooltips are in the wrong order on line chart points.
  • "Cannot read properties of undefined" error thrown after deselecting a member using the Select all checkbox of the Filter on popover when the hierarchy is virtual.
  • Nothing happens when clicking on the Try again button after a query error in a widget.

5.0.20

2023-01-11

Fixed

  • Switching widgets to a Donut chart results in the measure name unexpectedly being shown in legend.

5.0.19

2022-11-25

Added

Deprecated

Fixed

  • Unexpected warning when using the ActiveMeasure function in the Query editor.
  • The search of the Edit filter popover does not work when the target hierarchy is part of the smartFiltering.ignoredHierarchies setting.
  • Missing scrollbar in the Content editor and the Filters editor.
  • Widgets fail to call their onLoaded prop when their query fails.
  • Leave the page? prompt displayed when saving a dashboard.
  • Navigating from an unsaved dashboard to a saved one does not work.
  • "Cannot destructure property 'hierarchyIndex'" error sometimes thrown when scrolling a pivot table horizontally.

5.0.18

2022-10-28

Added

Changed

  • Empty dashboards are not saved automatically when users click the Create new dashboard button.

Fixed

  • Context menus containing long dashboard names extending to full screen width.
  • The Query editor sometimes does not recognize valid MDX generated by expanding a member in a pivot table.

5.0.17

2022-10-06

Added

  • Support for virtual hierarchies.
  • Ability to open an existing dashboard via a new Open Dashboard menu item under the File application menu.
  • Ability to type/paste members to filter upon through a text area in the Filter on hierarchy popover.

Changed

  • The initial UI folder in the content server is updated in order to grant the permission to share content to all users with the role ROLE_USER.
  • In Tree table widgets, the header above the tree displays the name of the last level, instead of the names of all levels.

Deprecated

Fixed

  • Calculated measures can be styled under Measures in the Style editor drawer.
  • Calculated measures are unexpectedly interpreted as corrupt tiles in the Content Editor when the "Measures" identifier in their name is not capitalized (e.g. [measures].[myMeasures]).
  • The loading overlay is not shown when updating a table which had no data to display.
  • KPI widgets with no data to display don't notify the user.

5.0.16

2022-08-31

Added

  • Ability to filter hierarchies of type "TIME" on Month to date, Quarter to date and Year to date in the Calendar tab in the Filter on hierarchy popover.
  • Conditional styles section in the Style editor, allowing to control the colors of charts. The styling can be applied conditionally, based on the measure's numerical value.
  • Ability to apply background colors to a KPI widget's values through the query editor, thanks to the MDX BACK_COLOR property.

Deprecated

Fixed

  • Clicking on an application menu sometimes opens two menus at the same time.
  • Using the Export to PDF item under the application File menu when the dashboard contains a Text Editor does not trigger the browser's print prompt.
  • Dashboard search may run slowly when there are thousands of dashboards.
  • When a user follows a link to a missing dashboard, this useless link is unexpectedly added to the list of recently visited dashboards in their home page, still leading to a missing dashboard.
  • "Expression is not a compound identifier representing a member" error when using MDX with custom sorting logic.
  • "The 2 objects do not have the same dimensionality" error when expanding a member down to a different hierarchy, if it has already expanded siblings.
  • Tiles cannot be removed from the Filters editor any more after a tile was removed while the Edit filter popover was open.

5.0.15

2022-07-29

Added

  • Tooltips indicating how to add measures, hierarchies, and filters to a wizard section.
  • Hide columns menu item, allowing to hide columns in a table widget.

Deprecated

Fixed

  • In the Filter on hierarchy popover, the user can not select more than one search result.
  • Members of multilevel slicing hierarchies cannot be expanded in the Pivot table and Tree table widgets, because they are missing their expand carets.
  • Adding a calculated measure to an empty pivot table has no effect.

5.0.14

2022-07-04

Added

  • Permissions, allowing to control what users can see and do in Atoti.
  • unsavedChangesPopup.isEnabled setting, controlling whether a warning popup is displayed when users leave a dashboard with unsaved changes. It is set to true by default, but setting it to false will prevent this popup from appearing.

Changed

  • The dashboard title is displayed in the center of the Header on dashboard pages.
  • Left application menus defined by configuration are displayed in the home page.
  • When the user navigates from the home page into a dashboard and then back to the home page, the folders they had expanded in the tree on the left remain expanded.
  • Context menu items on the home page have been rearranged so that Share is at the top and Delete is at the bottom.

Fixed

  • The user is unexpectedly allowed to edit the style of a non-numeric measure, under Measures in the Style editor drawer if this measure was the first one added to the widget.
  • In Firefox and Safari, unexpected error when one of the target ActivePivot servers is down.
  • Missing dashboard thumbnails in the Recent view on the home page.
  • Unexpected horizontal scrollbar at the bottom of the dashboard when it contains multiple widgets and the user resizes a drawer.
  • Resizing a table column unexpectedly highlights its text in Firefox.
  • "Uncaught TypeError: Cannot read properties of null (reading 'elementType')" error when trying to collapse a table cell that had been expanded several times.
  • Using the Export to PDF item under the application File menu sometimes prompts multiple print dialogs.
  • Using the Export to PDF item under the application File menu sometimes does not trigger the export if the dashboard contains an empty chart.
  • Widgets from inactive dashboard pages are not rendered when using the Export to PDF item under the application File menu.
  • Users can unexpectedly increase the size of an empty left drawer when no drawer is open.
  • In tables, the values for measures which are selected as filters are sometimes not displayed.

Removed

  • Measures tree from the Filters editor.

5.0.13

2022-06-10

Added

  • Synchronize widget menu item, allowing to synchronize a widget with the latest version of the saved widget it is based on.
  • Save widget menu item, allowing to update a saved widget on the Content Server.
  • Support for ActivePivot 6.0.

5.0.12

2022-06-01

Added

  • Support for Left() and Right() functions in the Query editor.
  • Spinner when a drillthrough query takes a long time to resolve.
  • The theme setting supports custom themes.
  • Ability to drag a tile from the Comparison section to another section of the Content editor drawer of the KPI widget.

Changed

pluginWidgetTable.contextMenuItems = [
pluginMenuItemSortTableAscendingly.key,
pluginMenuItemSortTableDescendingly.key,
];
  • When the user searches for measures, hierarchies or levels, the results are presented as a tree instead of a list. This makes them more useful, especially when several hierarchies contain a level with the same name.

Deprecated

Fixed

  • Switching to a Bullet or Gauge chart is unexpectedly disabled when the origin widget contains 2 hierarchies.
  • "The dimension [dimension] was not found in the data model of cube" error thrown in the Filters editor if a dashboard or page filter impacts a widget targeting a cube which does not contain the hierarchy of this filter.
  • Adding a dashboard or page filter with the Exclude selected members checkbox checked in the Filter on popover unexpectedly impacts KPI comparisons.
  • Widgets in dashboard pages that are not on screen unexpectedly send queries to ActivePivot when dashboard filters are updated.
  • When resizing the Query editor or State editor, the action buttons can sometimes become unreachable.
  • When switching from a KPI widget containing measures to another type of widget, a duplicate Measures tiles unexpectedly appears in the wizard.
  • The tooltip for the widget ribbon sometimes displays incorrect information regarding the selected widget.

5.0.11

2022-05-02

Added

  • The KPI widget supports the Show/hide totals, Drillthrough, Filter on and Exclude menu items.
  • Ability to see the full name of measures and hierarchies on mouse over, when it is too long to be entirely visible otherwise.
  • Axis titles switch in the Style editor drawer of charts with axes, allowing to control the visibility of the axis titles.
  • Saved filters menu item under the File menu, allowing to add saved filters to the selected widget.
  • Saved measures menu item under the File menu, allowing to add saved calculated measures to the selected widget.

Fixed

  • Logging out sometimes does not work correctly.
  • "Cannot read property captionPath of undefined" error thrown by tables with measures on rows and a filter on a single member of a hierarchy which is not displayed in the table.
  • Switching back and forth between a chart and a table results in a chart with a single remaining point.
  • Hierarchies flagged as invisible in Atoti Server are unexpectedly visible in Atoti UI.
  • The Drillthrough widget always targets the first cube, even when opened from a widget targeting a different cube.
  • In the Content editor of the Drillthrough widget, the user can only choose from the columns defined in drillthrough.defaultSelectedColumns when this setting is set.
  • The Select all checkbox in the Filter on hierarchy popover does not enable the Apply filter button.

Removed

  • "+" icon from all filters sections in the Content editor and the Filters editor, replaced by the Saved filters menu item (see above).
  • "+" icon from all numeric sections in the Content editor, replaced by the Saved measures menu item (see above).

5.0.10

2022-04-07

Fixed

  • Closing a drawer in the application does not work. The drawer becomes empty and remains open.

5.0.9

2022-04-01

Added

  • Widget filters section added to Content editor of the Drillthrough widget.
  • The Turn on real-time titlebar button can be used on quick filter widgets.
  • Ability to move several dashboards and folders from one folder location to another on the home page.
  • Support for HTTPS when running the Atoti UI starter in dev mode. To enable it, set the HTTPS environment variable to true:
  • Calendar mode added to the Quick filter widget, accessible under the Display as item in the top-right menu of this widget. This new mode allows users to quickly filter a dashboard page on levels of type "TIME".
HTTPS=true yarn start

Changed

  • The amount of whitespace below charts is reduced.
  • Support for connecting to a prerelease version of ActivePivot.

Fixed

  • Running yarn start in the starter opens Atoti at https://localhost:3000 even if the HTTPS environment variable has not been set to true.
  • Folders with long names overflow, in the left bar of the homepage.
  • In the Content Editor, selecting a cube in a catalog other than the first one does not show that cube's content.
  • When opening a dashboard, the initial active page is sometimes not the first one.

5.0.8

2022-03-01

Added

  • configuration.storeEnhancers, allowing extensions to hook into the state of Atoti UI.

  • Ability to move dashboard folders. To move a folder, right click it in the homepage and click Move.

  • Ability to create a secondary Y axis on Line chart, Area chart and Columns and lines chart widgets. To create a secondary Y axis, drag and drop a measure into Secondary values or Line values, in the Content Editor drawer.

  • moveFiles method on ContentClient, allowing to move several files at a time into a different folder on the content server.

  • advanced-extension, an Atoti UI extension, published alongside Atoti and containing all plugins developed by us but not part of the application by default. Namely:

    To activate it, edit the extensions.json file as follows:

      "@activeviam/starter": "extensions\\@activeviam\\starter\\@activeviam\\starter.js",
    + "@activeviam/advanced-extension": "extensions\\@activeviam\\advanced-extension\\@activeviam\\advanced-extension.js"
  • Conditional styles section in the Style editor, allowing to control the background color of cells within table widgets. The styling can be applied conditionally, based on the measure's numerical value.

  • Tooltip containing a selection summary at the top of the Filter on hierarchy popover allowing to quickly view (and deselect) selected members without needing to scroll to them.

  • Calendar tab in the Filter on hierarchy popover, providing filter controls specific to levels of type "TIME".

Changed

  • In the Filter on hierarchy popover, selected nodes are not deselected when the user collapses their parent. This is also the case in the Quick filter widget (when it is in Tree mode).
  • The CellSetSelection that is passed to any MenuItemPlugin for the WidgetPlugins representing tables includes empty cells.
  • Client's url property is public.
  • Data visualization widgets that refer to an unknown ActivePivot server display a list of known servers to switch to.

Fixed

  • Selection of files and folders on the homepage is not cleared when browsing to another folder.
  • The locale is ignored when adjusting the number of decimals of a measure through the Style editor.
  • Lower or greater value filters rounding decimal numbers to the nearest integer.
  • The Content editor fails to recover from errors: if it displays an error at a point in time, then it never stops doing so until the page is reloaded, even when the cause of this error is fixed (for instance when the data model is reloaded or the user selects a different widget).
  • The source map is not generated when running yarn start in the Atoti UI starter after setting the GENERATE_SOURCEMAP environment variable to true.
  • In a single server setup where the first catalog has a single cube, the cubes from the other catalogs are not shown in the cube selector.
  • Hovering on a Radar chart sometimes displays an empty tooltip.

5.0.7

2022-01-21

Changed

  • Search results are displayed as a tree of checkboxes in the Filter on hierarchy popover and in the Quick filter widget (when it is in Tree mode).

Fixed

  • Potential security vulnerability in activeui-scripts build and activeui-sdk-scripts build:host-application.

5.0.6

2021-12-29

Added

  • userQueryContext.isEnabled setting. When set to true, users can create a global query context, which applies to all dashboards they visit.
  • Style Editor drawer, allowing to control the number formatting for the selected widget.
  • Tree mode added to the Quick filter widget, accessible under the Display as item in the top-right menu of this widget.

Fixed

  • The homepage is inaccessible because replaced by a "JSON.parse: unexpected character..." error message, in case of malformed thumbnails.
  • In the homepage, dashboards that were just edited are mistakenly subtitled "You edited 0".
  • Warning icons are not displayed in table cells representing KPI statuses when they should be.
  • Boolean query context entries cannot be removed in the Query context editor.
  • The Filter on hierarchy popover becomes unusable when another hierarchy or level is dropped while it is open.
  • Infinite "Loading data model" error message, in the case of a slow server response.

5.0.5

2021-12-01

Added

Changed

  • Improved loading view for the home page.

Fixed

  • Chart tooltips are sometimes in an incorrect position.
  • After displaying the dashboards as a list in the home page and sorting it, right-clicking in the list opens a context menu targeting the wrong item.
  • In the home page, dashboards selected within a given folder unexpectedly remain selected when browsing into another folder.
  • Error thrown when selected cells are being removed from a table, e.g. when removing a hierarchy.
  • Error thrown when copying and pasting the "Measures" table header cell, when measures are set on rows.
  • MDX errors thrown when calling setFilters with several filters on the same hierarchy.
  • Widget filters in the Content Editor cannot be re-ordered.
  • The Show/Hide totals menu items are unexpectedly unavailable for slicing hierarchies followed by non-slicing ones.
  • The default measure is unexpectedly visible when a pivot table has hierarchies on columns and no measure selected.
  • Some points in radar charts have empty tooltips.
  • Sorted bar charts have unhelpful error message Cannot read properties of undefined (reading 'y') when given an empty query.
  • Rgb and Abs functions unexpectedly marked as invalid in MDX editor.
  • Drillthrough wizard will repeatedly fetch drillthroughHeaders on the ActivePivot server until a change is made to the drillthrough columns.
  • The widget top-right menu fails to close itself when the Duplicate widget menu item is clicked.
  • The "Measures" tile is sometimes missing when the user adds KPI properties to a widget, preventing them from moving them to other sections of the widget's content editor.

5.0.4

2021-10-22

Added

  • The AFilter type accepts an isExclusionFilter property allowing to create filters that "invert" inclusion logic. e.g. If a filter shows the top 3 values, when isExclusionFilter is set to true the filter will show everything except the top 3 values.
  • Support for multiple filters on a same hierarchy.
  • Ability to configure the initial set of columns used when opening a drillthrough table. This can be done with the drillthrough.defaultSelectedColumns setting.
  • pluginMenuItemFilterOnEverythingButSelection, a menu-item plugin allowing to filter a widget and/or its siblings by showing everything except what is selected.

Changed

  • The Edit/Present button at the top right of the application when on a dashboard is renamed to always read "Present" and is highlighted when presenting.
  • Copies of dashboards saved using the Save as... popup are only accessible to the current user by default. If the user has the role ROLE_SHARE, then a "Share" button allows to share this copy and an "Include destination folder permissions" checkbox allows to easily share it with all users with access to the folder in which the copy is being saved.

Fixed

  • Blank screen and "Missing theme. Remember to add <ThemeProvider /> at the top of your application." error in the console when an unhandled rejection occurs.
  • "Hide subtotals" table context menu item incorrectly present on columns representing a member of the last level of the last non-measure hierarchy expressed in the table, when this hierarchy is followed by measures.
  • The "Last editor" and "Last edited" columns in the home page sometimes show incorrect values.
  • Sometimes unable to remove a hierarchy from the content editor if the tile representing all the measures had been removed.
  • A "No plugin of type "widget" was found" error replaces the whole dashboard in case it contains a widget referring to an unregistered widget plugin. With this fix, the error message only replaces the problematic widget while the rest of the dashboard remains usable.

5.0.3

2021-10-05

Added

  • The application menu can be configured by modifying the values of the leftApplicationMenu and rightApplicationMenu attributes in the configuration.
  • The name input is automatically focused when the user creates a new folder from the home page.
  • The "Rename" menu item was added to the folders visible in the home page (in both list and grid layout). It used to only be accessible in the tree on the left of the home page.
  • smartFiltering.ignoredHierarchies setting allowing to ignore some hierarchies from the smart filtering context. It can be used to produce a more user-friendly behavior when the default list of members shown when adding a filter appears as empty or incomplete. This can typically be needed when analysis hierarchies or factless hierarchies are involved in the filtering.
  • setDrillthroughColumns function, allowing to set the columns in an MdxDrillthrough.

Changed

  • When the user adds a new drillthrough table widget plugin to a dashboard, all columns are initially selected instead of none.

Fixed

  • Sorting a stacked charts alphabetically based on the captions on the axis unexpectedly sorts numerically instead.
  • Sorting charts on a time dimension does not work.
  • Smart filtering does not work when the user expands members in the Filter on hierarchy popover.
  • The context menu fails to appear when the user right clicks on a widget. This bug only occurred on widgets displayed outside of a dashboard (for instance in an atoti notebook).
  • An infinite "Loading your dashboard…" message is displayed instead of an error message, when the user:
    • clicks a link to an inexistent dashboard,
    • tries to access a folder she is not allowed to see.
  • A different folder is unexpectedly displayed instead of an error message when the user clicks a link to an inexistent folder.
  • The Content Editor throws when a dimension, hierarchy, or measure is not found in the cube: "The hierarchy was not found in the data model of cube." This is frequently due to them being renamed on the server side.
  • The word "Total" fails to be copied when the user presses Ctrl+C on a pivot table.
  • Widget error message persists even though the error has been fixed.
  • Table static headers show the technical name of the corresponding level instead of its caption.
  • Copying and pasting a table static header yields the corresponding hierarchy name instead of the level caption.
  • The All dashboards section of the Filters Editor is unexpectedly visible when the setting userFilters.areEnabled is not set, or turned to false.

5.0.2

2021-09-03

Added

  • Confirmation message after using the Copy query to clipboard menu item.
  • The application name can be set in the configuration.
  • traverseMdx, a function useful to iterate over an Mdx AST.
  • Multiple folders and dashboards can be selected and deleted at the same time on the home page.

Changed

  • pluginWidgetPivotTable and pluginWidgetTable are lazy-loaded. Only a small chunk of data corresponding to the top-left corner of the table is initially loaded into the client. New chunks of data are then loaded as the user scrolls. You can configure the size of these chunks by updating pluginWidget.lazyLoading.chunkSize, as follows:
    pluginWidgetPivotTable.lazyLoading.chunkSizes = {
    rows: 10000,
    columns: 100
    }
    You can turn off lazy loading for a given widget by deleting pluginWidget.lazyLoading.

Fixed

  • Selecting a folder from the home page search fails to expand this folder's ancestors in the tree on the left.
  • Inability to collapse nested expanded members in a table, logging error: "Uncaught Error: The compound identifier does not represent a member".
  • Inability to collapse an expanded member in a table after expanding another one, logging error: "Uncaught TypeError: Cannot read property elementType of undefined".
  • Nothing happens when clicking the Retry with 30s button, displayed when widgets queries timeout.
  • Endless flooding of ping endpoint when the server is down.
  • Incorrect links in the API documentation when the URL contains a trailing slash.
  • Deleting the current folder in the home page throws an error.
  • Unexpected usage error thrown when using the State Editor drawer.
  • Sorting a pivot table column from a non-leaf header yields a wrong order.

5.0.1

2021-08-04

Added

  • Smart filtering: in the Filter on hierarchy popover, only the members contributing to the view are displayed for selection.
  • Ability to easily create calculated measures. Note that to see this feature, you must set the calculatedMeasures.areEnabled setting to true.
  • Ability to save and reuse calculated measures. Note that to see this feature, you must:
    • Set the calculatedMeasures.areEnabled setting to true.
    • Add the calculated_measures folder and its content and structure subfolders on the content server, under /ui. See how to initialize your content server.
  • State Editor drawer, allowing to view and edit the state of the selected widget. In particular, this drawer can be handy in order to manually update the configuration of charts. Note that this drawer is not part of the Atoti UI starter. To see it, you must add the following to your activate function:
    configuration.drawers.push(drawerStateEditor);

Changed

  • More specific icons in the Widgets drawer.
  • Menu icon on the top left corner of dashboard cards in the home page, hinting that these cards have a context menu.

Fixed

  • Using wrong permissions when creating a thumbnail while updating an existing dashboard.
  • Button to create a dashboard sometimes does not appear on empty folders.
  • Tooltip for disabled move action has incorrect caption.
  • Useless expansion carets are unexpectedly displayed on grand totals in pivot tables after users use the Expand by menu item.
  • Error: [409] An entry already exists at /ui/dashboards/thumbnails/[dashboard-id] when saving a dashboard.
  • The Create new dashboard button sometimes does not appear on empty folders, in the home page.
  • Users are unexpectedly able to create folders under saved widgets.
  • The Copy link button wrongly produces a link to an unexisting dashboard, when the user attempts to share a folder.
  • Empty folders in trees are not sorted correctly.