04 Oct Omniscope ROCK build – 2020.3
Another quarter, another rock. We’re pleased to announce the latest quarterly Omniscope production-ready “rock” build. The Visokio development cycle marches onwards and upwards, despite these unprecedented times!
NOTABLE NEW FEATURES:
Easily break down your data, with Hierarchies
Hierarchies let you group and collapse/expand your data by successive levels of detail. Date and number fields have implicit hierarchies (year, quarter, month…), and you can define your own custom hierarchies (product category, sub-category…). When you drag on fields which are part of a hierarchy, a +/- button inside the “pill” lets you easily add/remove further levels. And within your dashboard, +/- buttons let users expand and collapse for themselves.
Recycle, Reuse – save time with Bookmarks
With Bookmarks, Omniscope now lets you easily save a block configuration for reuse elsewhere within the same Omniscope installation. Let’s say you’ve configured the perfect Field Organiser block, entered some tricky connection details or SQL query in a Database source block, developed a Custom block using your own handwritten Python or R, or finished a Report block that needs to become a company dashboard template. Bookmark it, and reuse it from the Add Block menu on another project, available to other users (if it’s a shared server).
Data Table block – edit/snapshot the data in the workflow or report
This new block represents an editable and persistent store of data (it’s simply a table of data, hence the name), large or small. You can put data into it (“refreshing” from the input, if connected, as a persistent snapshot of the incoming data), pull data out of it (by connecting blocks downstream), consume directly as live data in the report (no need to execute), and edit it (in the workflow, directly in your reports, and via APIs, if permissioned and enabled, with immediate effect). See introduction and use with workflow execution API.
Salesforce input and output blocks
We’ve added Salesforce source and output blocks, so you can now consume tables from Salesforce in your Omniscope workflows, enrich and correct the data, then publish back.
Categorical axis in Scatter
You can now create scatter views using categorical (text) fields as either axis.
As usual, tons of lesser features and fixes have been added since the previous rock build, including:
- Workflow APIs now let you execute and set parameter values
- Much improved performance with large (e.g. 200+ block) workflows
- Deployment on Windows and Linux VMs from all major clouds (MS Azure, GCE, AWS EC2) fully supported (see advisory)
- Easily consume JSON data from REST endpoints using the new “JSON HTTP API” block
- Send emails with data attached using the new Email Output block, and automate sending such emails with batch publishing actions using the Batch Output block.
- Perform better automatic checks on your data, and consume problem metadata, using the latest enhancements to the Validate Data block.
- Improved robustness of Storage Block, and workflow execution in general, in high concurrency servers.
Over the same time period, a number of notable new community blocks have been shared on our Github repository. These are open-source add-ons which use open APIs within Omniscope to add functionality, and can be found within the Add Block menu:
- Sharepoint Online Downloader block
- ForEach block
- Etherscan block
- SFTP Downloader block
- Report to PDF batch output block
- Web Image PDF output block
Any Omniscope cloud installation (on Microsoft Azure Compute, Google Compute Engine or Amazon EC2) must be deactivated/reactivated before/after upgrading to 2020.3. See details.
What’s next? Your features!
We’re busy developing OpenID Connect integration for better identity and authentication management, expanded formulas, drill-down, dashboard filters as URL parameters, and smarter defaults for filters.
But we’d love to hear what you want added to Omniscope. Please contact us to get access and join the discussion at our new public Trello board!