New editing workflow!

In the very near future, the editing workflow for documents will change. This new workflow utilizes drafts, allowing you to make changes to documents before they’re published and iterate without commitment.

Drafts come with the ability to view and revert to individual changes, archiving, and more. Check out the docs or our demo to learn more. If you just can’t wait, reach out to Omni support (email or in your Slack channel) to take the beta for a spin!

Customizable column totals

You can now customize how totals are displayed for dimensions, measures, and calculated columns!

When column totals are enabled, Omni will automatically use the column's calculation as the default total. However, you can adjust this to suit your specific needs, giving you greater flexibility and control over your data summaries. Totals won’t display by default for dimensions, but you can opt to add one if needed. Check out the docs for more details.

Interactivity for SQL query results

Previously in SQL queries, sorting and calculations had to be done inside the query itself. With this update and just a few clicks, you can sort data or add calculated fields right in the Results table, just as you would with a non-SQL query.

Dynamic database connection switching

Switch between database connections on the fly with our latest connection enhancement. Using user attributes, you can specify which connection environment users will query against in Omni.

For example, you could:

• Simplify your development workflow. If you follow a development workflow such as dev-staging-production, connection switching enables you to effortlessly change environments with just a few clicks in Omni’s IDE.

• Support multi-tenant database setups. If you’re an embed customer that whitelabels Omni, connection switching can be used to dynamically point each company or user at their own database.

Inline validation in the IDE

Trying to find the cause of a mistake in your code can be time-consuming and frustrating. The built-in model validator in the IDE will highlight your mistakes, but it's not always obvious where in the code the issue is - especially if you have a particularly large model file.

This week, we added inline validation to the model IDE. This will make it easier to quickly find and fix issues without needing to scroll through the file or click into the validator.

And now, some honorable mentions

Over the Thanksgiving break in the US, our team focused on some quality of life projects. We were delighted by these small but meaningful enhancements, and hope you will be too!

• Easily resize panels by dragging the edges

• Drilling into dimension fields may not be brand new, but being able to drill right from a chart is!

• Calculated fields can now have descriptions, which will display as a tooltip in the column header in the Results table: