2022.12 » New Features and Enhancements
New Cube Settings Dialog NEW FEATURE
Version 2022.12 introduces a major change in Cube Settings. Users will be able to benefit from a brand new dialog, which significantly speeds up the creation of new reports by giving users the ability to reuse existing views as the template for row, column and filter assignments. View objects can simply be clicked to assign the view layout to the cube settings canvas which will read the view configuration and automatically dock dimensions/hierarchies to the correct predefined locations. All subsequent changes can be easily made using the subset editor, advanced options panel and drag & drop functionality.
Note: the definition of cube settings in Apliqo UX via dragging of existing views is a once-off process on object creation. After the object is created there is no link back to the original public view and changes in the original public view used as the "template" will not be synced to the widget or view in Apliqo UX.
IMPORTANT
After the installation of 2022.12 version on first page visit the structure of the json of the view object is automatically updated to a new format. If the app is reverted back to a previous version this may cause errors in the configuration and rendering of existing views. It is recommended to create a backup of the existing contentstore before installation or create a new one for testing prior to rollout of the 2022.12 version.
» Cube settings dialog overview
The new cube settings dialog is similar to the cube viewer widget, with a list of available cubes and views located on its left side. It can be accessed as before by clicking the cube icon.
Show Control objects toggle
List of available Instances, Cubes and Views
View Definition
Table preview
Launch Advanced Options GUI (to set individual dimension/hierarchy properties)
The selected Instance and Cube will be dependent on the initial widget configuration. Both can be changed using the list of available Instances, Cubes & Views.
» Configuration
Users can edit a view further using:
drag and drop functionality to move the dimensions
Advanced Options GUI to configure individual hierarchy properties
subset editor to change the selection or attributes of the dimensions’ elements.
Global filters as well as column and row dimensions are automatically configured to match the settings from the selected view. All the changes will be visible in the table preview.
User can delete / reset the dimension using the trash can icon. New dimensions are added with the + icon as in the legacy cube settings dialog.
» Configuration with advanced options GUI
Other configuration options are available in the advanced options panel:
View settings: change the row master setting and enable spreading.
SubView settings: enable zero suppression and use Full MDX option.
Dimension settings: customize the dimension settings to match your requirements.
» Configure a fixed element value
A significant change introduced by the new format is the removal of the technical distinction between "filter" dimensions vs. "fixed" dimensions. All context dimensions/hierarchies are now filters and there is an additional property of filters which defines if the dimension should be fixed (non-selectable) and optionally hidden from the Filterbar.
To set a given dimension/hierarchy as a fixed value, use the Fix toggle (available for global filters) to disable the element selection.
» Full MDX option
At any time users can check the current MDX by pressing the edit MDX button.
When the Full MDX option is enabled, the same window will be used to enter and edit the MDX code. After saving the changes (Save & Apply button), table preview will be updated to reflect the edited MDX query.
Undo Changes NEW FEATURE
The next new feature in the 2022.12 version is the Undo functionality, which allows users to view data entry changes made to values in a screen and to undo them if needed.
A new button has been added to the toolbar on each page to allow user who made the data adjustments to undo changes. It will not be active until a change is detected.
To revert to the previous value, the user must select the change in the popup and press the UNDO button. (See screen recording below.)
» Review multiple changes in a batch
In addition, when many changes are made at once (e.g. via a copy/paste action), these are stored in the change log in a summarized form. The user can view the changes via a "show details" dialog and see changes cell by cell. For such changes users have the ability to undo all off them in one action, or cell by cell.
Subset editor improvements improvements
The latest UX version also brings a number of improvements to the Subset Editor:
» Expand Above
Enabling this option reverses the order in which child elements are displayed under (or above) their parent consolidations.
» Alias dropdown
Selecting a display alias now changes the display name in the left most column, rather than adding the attribute field to the attributes area. If the default alias attribute is set for a named public subset then it will be automatically selected in the dropdown list.
» Subset changes (private, static & dynamic)
Subsets in the subset dropdown will now be visually marked to easily identify static, dynamic and private subsets. As users have the ability to create private subsets with the same names as public subsets. Any private subsets specific to the logged on user will be listed first at the beginning of the list.
When saving a subset it's now possible to save it as static and/or private.
» Current MDX
Current MDX toggle allows to see live preview of MDX statement defining the current set of displayed elements.
» Undo MDX amends
New button allowing users to undo actions in the subset editor and roll back to the previous set.
» All Ancestors button
New button located in the subset editor toolbar that allows users to view all ancestors of the selected element(s) (Option also available in the context menu after right clicking on the selected element)
» New context menu options
After right clicking on the element, set of new options in context menu will be available for the users including:
Views / Grid widgets improvements improvements
» View configuration
2022.12 version also introduces several improvements to view configuration.
When creating reports with multiple sub-views, users can join tables with different row dimensions, as long as the selected elements are the same principal name or alias (it works on a similar basis to creating connected widgets).
In addition, users can configure the view to include same dimensions in the report's global filters as well as rows, which was not possible in previous versions.
» Expand Above
New Expand Above option available in the subset editor, which reverses the order in which child elements are displayed under (or above) their parent consolidations, can be also applied in all views and grid widgets.
» New context menu options
Copy and paste options available in non edit mode:
Copy data - used to copy the cell / columns values
Copy element(s) - copies selected element which then can be used in Paste before or after function
Paste before and after - select where the copied element(s) should be placed
Selection - (previously "Elements") can be used to dynamically change the row selection without launching the subset editor (e.g. Selection > Keep + descendants)
All modifications made to the view related to collapsing or expanding consolidated elements are treated as changes to the configuration and can be saved.
New Reset context menu option that allows users to e.g. close the Drill elements and revert to the original configuration.
Copy and paste options available in edit mode:
Copy data - used to copy the cell / columns values
Copy element(s) - copies selected element which then can be used in Paste before or after function
Paste before and after - select where the copied element(s) should be placed
When working in edit mode, all changes made to the view can be saved.
Modifications made to the view with the use of the subset editors shortcuts provided in the context menu will also be treated as configuration changes and the option to save them will be available.
TI Process improvements improvements
» TI process creation from the toolbar action menu
The Add menu (located in the toolbar) now contains a new option: TI button Choosing this option will open up a create dialog for the TI process button. User can specify:
Title
Instance
Process
Location of button, by default it will be located in toolbar, but by enabling Widget PopUp it can be placed in a selected widgets' header instead.
After initial setup, additional configuration can be done as before from the advanced option GUI.
This makes creating TI action buttons much easier than previously.
» Run TI process without confirmation directly from toolbar
New advanced option Run On-Click has been added to the Process Configuration to enable users to run the process with predefined parameter values without the need to open the popup dialog.
After setting this option to true, the process will start with the button click and run in the background. For this process configuration the Drawer Enabled option will be by default turned on so that the user can track the process status in the Notifications window.
Notification improvements improvements
The latest addition in this release is an improvement to the way public messages can be sent.
Users may now set a Start and End date as Today in order to send a message that is only valid for one day.