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
anddark-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. UseoriginPageKey
andtargetPageKey
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
- getUserRoles. Use getUserFromJwt instead.
- FormRow. Use Ant Design's Form and Form.Item components instead.
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 tofalse
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 ofActivePivotClient
andContentClient
. - Support for nested measure folders in the Content editor.
createCalculatedMember
,createKPI
,deleteCalculatedMember
anddeleteKpi
methods inActivePivotClient
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:
activeDrawerKey
to activeToolKeyActiveDrawerChangedAction
to ActiveToolChangedActiondrawerStateEditor
to toolStateEditordrawerStyleEditor
to toolStyleEditordrawerQueryEditor
to toolQueryEditordrawerQueryContextEditor
to toolQueryContextEditorgetActiveDrawerKey
to getActiveToolKeygetDrawersTranslations
to getToolsTranslations- On the left of the application, the Data model and Tools (which among others includes the Content editor) can be independently resized and collapsed.
- The data model is indexed, allowing O(1) access to cube properties. For example:
- const hierarchy = cube.dimensions.find(dimension => dimension.name === myDimensionName)?.hierarchies.find(hierarchy => hierarchy.name === myHierarchyName);
+ const hierarchy = cube.dimensions[dimensionName].hierarchies[hierarchyName];
createActivePivotClient
andcreateContentClient
expect a newserverVersion
argument, and theirversion
argument is renamed toserviceVersion
:
createActivePivotClient({
url,
+ serverVersion: "6.0.0",
+ serviceVersion,
- version: serviceVersion,
requestInit,
}),
- The
Versions
type is renamedServicesVersions
. clients.contentClient
is renamedclients.content
.- Following up Ant Design's menu items API change, menu items must be retrieved through hooks rather than imported as Components:
- 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 roleROLE_SHARE
is no longer supported. - The key of the Save widget as menu item is changed from
save-as
tosave-widget-as
. ThepluginMenuItemSaveWidgetAs
must be explicitly added to each applicable widget's menu items. - The MeasuresFolderNode accepts both measures and measure folders as children.
addFormula
is renamedaddCalculatedMeasure
.- Minimum required version of the supported browsers.
pathToFolder
is renamedpathToParentFolder
in the arguments of the followingContentClient
methods:fetchThumbnails
,fetchThumbnail
,fetchFile
,createFile
,createFolder
,deleteFilesAndFolders
,updateFile
,updateFolder
,updateFilePermissions
andupdateFolderPermissions
.getMeasures
is renamedgetMeasureNames
and returns an array of strings.- Filters are no longer typed as
Mdx
. Instead, they are typed as:MdxExpression
in the MDX API.Filter
in the rest of the API. This includes saved filters as well as filters in widgets, dashboards and the user activity.
- Properties
canRead
,canWrite
,isDirectory
,lastEditor
, andtimestamp
are required in ContentEntry by default. If you want to type entries that are meant to be sent in PUT/POST requests, useContentEntry<"request">
instead. - Query context values used in
query.context
andqueryContextEntry.value
are typed as string. pluginWidgetPlotlyComboChart
is renamedpluginWidgetPlotlyColumnsAndLinesChart
. Its plugin keyplotly-clustered-column-and-line-chart
is renamedplotly-columns-and-lines-chart
.- The
cube
argument is mandatory ingetMeasure
. - The
name
property ofAMetaData
is mandatory. - Property
levelIndex
onFilterOnTopBottomMembers
is replaced withlevelName
. - The
key
property ofApplicationMenu
is mandatory. - The parameters of the
onTileMovedFromExtraSection
function inDataVisualizationContentEditorProps
:- The
item
parameter is renameddragItem
. - The
toSection
parameter is replaced withtoPosition
, of typeTilePositionWithinWizard
.
- The
- The
version
property ofWidgetMetaData
is mandatory.
Removed
activeui-scripts generate-css
. This is no longer needed with the drop ofless
in favor ofCSS-in-JS
inantd
5.- The Widgets ribbon. Use the Insert -> Widgets menu (shortcut W) in the application header instead.
withCube
higher-order component. Use theuseCube
hook instead.userFilters.areEnabled
setting. Use thecanUseUserFilters
permission instead.userQueryContext.isEnabled
setting. Use thecanUseUserQueryContext
permission instead.calculatedMeasures.areEnabled
setting. Use thecanUseCalculatedMeasures
permission instead.ContentClient.moveFile
method.ContentClient.moveFiles
'srequestOptions
option.getLastEdition
function. UsegetMetaDataRecord
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
andpluginMenuItemSortPivotTableAscendingly
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 theirCaption
. - 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
configuration.widgetLoadingOverlay
, allowing to add a custom widget loading overlay.
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
csvSeparator
setting allowing to configure the CSV separator used by the Export to CSV menu item.configuration.pathToHome
, allowing to set a custom path to the Atoti homepage.
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
ContentClient.moveFile
. UseContentClient.moveFiles
instead.- Relying on
ROLE_SHARE
to grant the sharing features. Use thecanShare
permission instead.
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
userFilters.areEnabled
setting. Use thecanUseUserFilters
permission instead.userQueryContext.isEnabled
setting. Use thecanUseUserQueryContext
permission instead.calculatedMeasures.areEnabled
setting. Use thecanUseCalculatedMeasures
permission instead.
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()
andRight()
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
- The Sort ascendingly and Sort descendingly context menu items apply a breaking sort when used on the Table widget. See explanation about breaking/non-breaking sort here.
Note: in order to benefit from this change, you must attach pluginMenuItemSortTableAscendingly and pluginMenuItemSortTableDescendingly to
pluginWidgetTable
in yourplugins.tsx
, as follows:
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
useWidgetQuery
. UseuseWidgetQueryResult
to run your query directly instead.
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 totrue
: - 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 athttps://localhost:3000
even if theHTTPS
environment variable has not been set totrue
. - 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 theWidgetPlugins
representing tables includes empty cells. - Client's
url
property ispublic
. - 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 theGENERATE_SOURCEMAP
environment variable totrue
. - 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
andactiveui-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
- Support for the
DatePart
MDX function. - Support for ActivePivot 5.7.
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, whenisExclusionFilter
is set totrue
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
andrightApplicationMenu
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:You can turn off lazy loading for a given widget by deletingpluginWidgetPivotTable.lazyLoading.chunkSizes = {
rows: 10000,
columns: 100
}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 totrue
. - Ability to save and reuse calculated measures.
Note that to see this feature, you must:
- Set the
calculatedMeasures.areEnabled
setting totrue
. - Add the
calculated_measures
folder and itscontent
andstructure
subfolders on the content server, under/ui
. See how to initialize your content server.
- Set the
- 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.