EnhancedBI Release V8.3.1.1

The latest version of EBI has been released. The changes are listed below.

there are a lot of small incremental updates as well as some quite major new features.

New Features

– AlmostMeasures in visuals – AlmostMeasures columns can now be used in Table, Gauge, Chart (Value section only), Map (Size section only), Heat Map (Value section only), KPI (Indicator and Target sections only) and Matrix (Values section only) visuals.

– Find where an LP is used – LP Properties now has a “Check where this LP is used” option that lists the Dynamic Views using the selected LP.

– Copy a calculated-column value – In Dynamic Views, double-click a calculated-column cell to open a read-only box with its value, pre-selected for quick copying to the clipboard.

– Self-service Two-Factor Auth – A “Set up Two-Factor Auth” link has been added to the Dynamic View and HomeScreen user menus (previously available only from the Admin, Designer, User Process and ML pages).

– Subtotals on more column types – Subtotals can now total text and whole-number columns, not just decimals.

Improvements

General (all pages)

– Redesigned the page header: the page/object title now appears in the centre of the header bar, reclaiming vertical workspace.

Dynamic Views

– Faster Dynamic Views tables: the Totals row now loads together with the table instead of after it, so large tables appear noticeably quicker.

– Reports that use AlmostMeasures now load faster.

– Gauge labels now read cleanly (e.g. “Target”) instead of awkward wording like “Max of Target”.

– Newly completed notifications (those counted in the bell badge) are now highlighted when you open the Notifications popup.

– Dynamic View Designer: newly-added Smart Table columns now appear in the Fields/Visuals and Relations panes after a full page reload.

– Data update details: added click-to-sort on all columns (Smart Table, Owner, Last updated) – the Last updated column sorts in true date order.

Report Preview

– The total record count now appears as soon as row counting finishes, so you can read it and stop without waiting for the preview rows to load.

– Column headers (Excel column letters and field names) now stay frozen at the top of the grid while scrolling.

– You can cancel a slow “Counting all rows” step and still get the preview (without the total record count). The abort (×) responds immediately, even when a row count is stuck.

LP runs & scheduling

– Running LP page now shows the number of records exported so far for the currently-processing step.

– LP Schedule Output: the EP success line now reports the number of exported rows.

– Maintain Schedules: “View Output” is now enabled for in-progress runs and shows the current step, including records exported so far.

– Scheduler: cancelled LP runs now show the steps that completed before the cancel in the Output dialog (previously only “Cancelled” was shown).

– The scheduled daily restart now always runs at night (2 AM) instead of drifting into working hours.

LP & EP design

– LP Designer: moving and removing steps no longer reloads the page, so the list stays in place while you work.

– LP Designer: you can now remove several cross-referencing steps in a single action instead of one batch at a time.

– “Check where this EP is used” now lists every place an EP is referenced – including other EPs and Views that use it, not just LPs.

– Deleting an LP now accounts for Dynamic Views that use it: the LP Designer blocks the delete, while the Delete Objects wizard lists and removes the dependent DVs alongside the LP.

User Processes & Runtime Variables

– User Processes: the parameters grid no longer paginates and now supports reordering via Up/Down buttons.

– The Runtime Variables picker now shows up to 100 variables per page with internal scrolling, instead of paging through 10 at a time.

– One-time LP runs launched from a DV or the HomeScreen no longer count as scheduled usage, so they no longer get in the way of editing a variable – only genuine, saved Scheduled LPs are considered.

– You can now add to or edit a list-based Runtime Variable’s values even when it’s used in a scheduled LP – only removing a value a schedule actually relies on is blocked (and the message now names the value and LP).

– “Last Value from ST” criteria: the Value Field and Group Field dropdowns now include Smart Table Calculated Columns, not just columns output by the EP.

Data sources & connections

– SQL Server export settings now open instantly, and you can cancel server/database lookups instead of waiting.

– The Database dropdown on the SQL Server export tab now has its own reload button (replacing the old “next” button), so you can refresh the list on demand.

– FTP file LP steps: the server connection Test can now be cancelled and no longer locks up the step editor while it runs, with a refreshed “Please wait” dialog.

– Add/Remove Tables: the Available and Selected Tables lists now scroll (large page) instead of using numbered paging, and search/filter without a page reload.

Dictionaries

– Dictionary Wizard: creating or updating a dictionary now shows a progress bar with the percentage of tables processed while columns are being fetched, instead of an indeterminate “Please Wait…” spinner.

– Editing a Dictionary now shows all blocking conflicts at once in a clearer, more concise list.

Administration & updates

– Improved automatic cleanup of old activity logs so the database no longer grows excessively over time.

– Auto Update: you can now check for and download a newer version right away, even when an update is already scheduled to install.

– Installer: the “refresh server list” search on the database setup screen can now be cancelled instead of leaving you waiting.

Bug Fixes

Dynamic Views & HomeScreen

– The “Data update details” dialog now lists each Smart Table once, instead of one row per Smart Table instance in the DV.

– Searching for text containing apostrophes (e.g. “O’Brien”) in Dynamic Views no longer errors.

– Resizing a chart visual while a tooltip was showing no longer triggers a script error or leaves subsequent tooltips blank or stretched across the chart.

– Duplicating or cloning a Map visual no longer crashes.

– Heat Map and KPI visual data download/export no longer fails with “There was a problem generating your report”.

– Matrix side-bar icons (Maximize, Move, Options) now appear only when the Matrix is selected, instead of on hover where they would disappear before the cursor could reach them.

– Static Text and Image visuals no longer clip their contents or the “…” menu button’s borders when hovered or selected (the menu button now sits outside the title bar, like the Matrix visual).

– The Change Function dialog no longer overlaps the Side Bar on the Home Screen.

– Being kicked out by another sign-in while on the HomeScreen or Dynamic Views now redirects to Login with the “session taken over” message instead of a blank login screen.

Smart Tables, Dictionaries & SQL

– Modify SQL no longer crashes after adding a column to a Dictionary (stale dictionary-column cache).

– Dictionary Wizard: clicking Change Credentials then Cancel no longer loses the dictionary name and detected database type (e.g. AS400 no longer falls back to Access).

– Smart Tables/Columns with very long names no longer fail with a SQL “identifier is too long” error – names are now limited to 128 characters (shown truncated in the designer).

– Importing Smart Tables that contain long, multi-line text no longer fails.

– Running an EP no longer unexpectedly empties its target Smart Table or SQL Server table – the existing data is kept and a warning is shown instead.

– Deleting a Smart Table used by ML Models no longer fails with a database error – Administration -> Delete now removes the dependent ML Models too (and lists ML Models as deletable objects in their own right).

– Import, Export and Delete Objects pages no longer hang when listing objects while a Smart Table export is running (object listings now read without waiting on database locks).

LP, EP & scheduling

– The “LPs using Process” page no longer shows duplicate rows – each LP appears only once, even if it references the Process from multiple lines or parameters.

– The EP Name typed on the Save As screen is no longer cleared after browsing for a destination folder or workbook file.

– LP Schedule save now reports the configured impersonation account and current machine name when Windows Task Scheduler rejects the credentials, instead of a cryptic error.

– A runtime variable set to copy its value from another step is now correctly prompted for when that other step has been removed.

– Scheduled runs that were cut short by a server or process restart now show correctly as failed in Maintain Schedules, instead of appearing as though they never ran.

– FTP download steps no longer hang on slow server connections, and cancelling a running LP now immediately stops an in-progress FTP download.

Email / SMTP steps

– Clicking “Attach a file” (or Browse/Remove) on an SMTP mail step no longer triggers “Recipient cannot be empty” / “SMTP Port cannot be empty” – those validations now fire only on Save.

– Adding or removing an attachment on the “Send mail through SMTP” step no longer reloads the page or discards an unsaved Message body.

– Validating email settings now shows an error when the mail server is slow or unreachable, instead of appearing to hang with no message.

Users & administration

– Renaming a user with 2FA records no longer fails with a foreign key conflict.

– The “Currently Logged-In Users” admin page no longer shows negative values in the “Logged-In For” column when the server clock has been adjusted backward.

– Long user and user-group names no longer overflow the Notifications grids on the LP Scheduler Details page – names now wrap within the column instead of breaking the layout.

– The admin date-tag calendar now sorts day/week/month tags in the correct order.

Installation & updates

– Installation Mode now shows a clear message about the required database permissions instead of a technical error.

– The manual update download page no longer shows “File not found” and now opens normally.