Excel add-in
Velixo is happy to announce a powerful new feature available in private preview: Velixo Intelligence. It brings in-context AI inside Excel to help you get answers fast, and help you with tasks such as:
-
composing formulas (including complex queries),
-
analyzing report figures, including advanced inspection with drilldown,
-
troubleshooting formula errors,
-
reporting a support case,
-
designing an entire report (functionality coming soon).
If you’re interested in participating in the private preview of Velixo Intelligence, reach out to your Customer Success Manager. We are only accepting a limited number of pilot customers at this stage.
In another highlight, the SI.EXPANDGLHISTORY function received a major performance improvement, significantly reducing loading times for large data expansions. (RD-2089)
🚀 New
-
We’re introducing a set of 10 new functions that let you return lists of dimension group names according to their type: (RD-8638)
-
SI.EXPANDCLASSGROUPRANGE – returns Class group names,
-
SI.EXPANDCONTRACTGROUPRANGE – returns Contract group names,
-
SI.EXPANDCUSTOMERGROUPRANGE – returns Customer group names,
-
SI.EXPANDDEPARTMENTGROUPRANGE – returns Department group names,
-
SI.EXPANDEMPLOYEEGROUPRANGE – returns Employee group names,
-
SI.EXPANDITEMGROUPRANGE – returns Item group names,
-
SI.EXPANDLOCATIONGROUPRANGE – returns Location group names,
-
SI.EXPANDPROJECTGROUPRANGE – returns Project group names,
-
SI.EXPANDVENDORGROUPRANGE – returns Vendor group names,
-
SI.EXPANDWAREHOUSEGROUPRANGE – returns Warehouse group names.
-
✨ Improved
-
Query Builder can now split query expressions to work around Excel cell character limits, making it easier to build complex queries without hitting technical barriers. (RD-8589)
-
Worksheets are now automatically unprotected before table mirroring and re-protected after, streamlining the mirroring process for protected sheets. (RD-8396)
-
The SI.WRITEBACKJOURNAL function now supports writeback of selected cells, even within dynamic arrays. (RD-4534)
-
If an SI.WRITEBACK function has a linked parent SI.WRITEBACK function (the
ParentRecordReferenceargument is not empty), theParentRecordGroupNameargument becomes optional if the parent object has only one parent group. (RD-8670) -
We modified the way the SI.QUERYFILTER function builds filters to mitigate errors caused by Sage Intacct’s expression length limit. (RD-7855)