> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# May 3, 2024

> XLOOKUP, Embedded Workbooks, Dynamic Fields / Select Fields From Filters, & more

<Note>
  **Stay in the loop!** Subscribe to the [demo RSS feed](/demos/rss.xml) to be notified when we post new demos.

  Demos highlight what we are working on or experimenting with, but are not a guarantee of release. Let us know your thoughts at [support@omni.co](mailto:support@omni.co).
</Note>

## XLOOKUP (Launched behind a flag)

*Cathy Lennon · `calcs` `workbook`*

The launch of xlookup, bringing cross-tab analysis to any user. Now time series joins across tabs, fact lookups, etc are trivial in the workbook - continuing the strategy of bringing the best of spreadsheets into Omni.

<Frame>
  <iframe src="https://www.youtube.com/embed/gm2DgezlREY" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Embedded workbooks (launched)

*Gustav Staprans · `embed` `workbook`*

A first look at the embedded workbook experience; now customers can share full analytical experiences with their customers alongside curated dashboards in embedded use cases

<Frame>
  <iframe src="https://www.youtube.com/embed/0GX8knqb-BQ" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Dynamic fields / select fields from filters (launched)

*Jamie Davidson · `workbook` `modeling`*

The launch of dynamic fields in Omni, allowing tables columns to be controlled by filters entirely in the front-end - timegrain swappers, dimension swappers, and measure swappers are now available for flexible analysis workflows (dashboard support coming soon)

<Frame>
  <iframe src="https://www.youtube.com/embed/C7D_AxlXUjo" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Parameters / filter passing into fields (launched)

*Steven Talbot · `workbook` `modeling` `analysis-pattern`*

Filters can now be injected into fields for parameterized reporting - opening up use cases like dynamic formatting, forecasting, or simply filters that can pass to calcs in the UI

<Frame>
  <iframe src="https://www.youtube.com/embed/Y0Yq6lW-Cbo" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Filter passing between dashboards (launched)

*Steven Talbot · `dashboard` `modeling` `analysis-pattern`*

Now model urls arguments can accept dashboard filters for complete context on cross-drilling experiences (passing the full filter context from one dashboard to another)

<Frame>
  <iframe src="https://www.youtube.com/embed/HGt8jTbhNU0" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## dbt dynamic schema migration (launched)

*`dbt` `modeling` `administration`*

New tooling to migrate a data model to dynamic schemas. This opens up the ability to test dbt changes on test schemas across the full app.

<Frame>
  <iframe src="https://www.youtube.com/embed/NJR-P-Tb3ow" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## More tables - descriptions, conditional formatting bars (launched)

*Richard Czechowski · `table` `visualization` `workbook` `dashboard`*

Lots of work on tables: optional field descriptions in the table; touch-up to allow conditional formatting on table bar charts, and a bunch of polish across the table experience

<Frame>
  <iframe src="https://www.youtube.com/embed/6-Zu4_ey62o" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Period-over-period clean-up (launched)

*Steven Talbot · `workbook` `analysis-pattern`*

Some touch-ups to the period-over-period experience to clearly explain the time slices

<Frame>
  <iframe src="https://www.youtube.com/embed/Gat0nU8Fbo4" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>
