> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.omni.co/feedback

```json
{
  "path": "/demos/2024/20240913",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

# September 13, 2024

> Global color palettes, cross-tab spreadsheet references  and 12 (?!) 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>

## Global color palettes

*Gustav Staprans · `Visualization` `Administration`*

A first look at global color palette controls - now manage palettes for the Omni environment including diverging and gradient palettes with a full admin UI

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

## Cross tab cell references

*Cathy Lennon · `Calcs` `Workbook`*

Why isn't calling data from another query as easy as Excel or Sheets?  Just reference the field and put data next to each other.  Now you can with simple cross-sheet cell references to bring queries next to each other without joins or models or lookups, just "="

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

## Smarter, stickier vis config

*Nate Agrin · `Visualization`*

The launch of sticky vis config over a huge number of user actions in the UI.  Smarter, better visualization as you refine queries in the app - sticky colors, retaining changes between different vis types, smarter retention of facets on new fields.

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

## Branches for external Git pull requests

*Conrad Slimmer · `Modeling`*

New settings for git to create branches for pull requests created outside of Omni, for more robust change management in product for folks using git outside the app

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

## Dynamic schemas in dbt

*Buck Ryan · `dbt` `Modeling`*

New dynamic schema controls with dbt

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

## Better branch creation

*Conrad Slimmer · `Modeling` `Workbook`*

Smarter branch creation - adding existing changes on save to the new branches

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

## Download for hidden columns

*Conrad Slimmer · `Export` `Workbook` `Dashboards`*

Controls to download hidden columns for curated data tables

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

## Embed user management API

*Chris Merrick · `Embed` `Adminstration`*

A new API to manage embed users (list, delete), in order to manage privacy deletion in bulk

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

## TEXT() pushdown for numerics and dates

*Cathy Lennon · `Calcs` `Workbook`*

The ability to push down more TEXT() metrics to the model - for both numeric formats like percent or decimal, and datetime formats

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

## Content owner re-assignment

*Eli Cohen · `Workbook` `Dashboards`*

New controls to re-assign ownership for content

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

## Better model join validation

*Steven Talbot · `Modeling`*

Better validation for joins through the context of topics

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

## Grouping measures outside pivots

*Steven Talbot · `Workbook`*

Grouping measures inside pivots to cluster metrics instead of dimensions

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

## IDE folding

*Jared Hardy · `Modeling`*

Folding in the IDE to open up quicker, easier navigation in large topics or view files

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

## Aliased joins and renamed metrics inside topics (design pattern)

*Colin Zima · `Workbook` `Modeling`*

A quick design pattern for aliased joins inside topics, including renaming metrics specific to the topic (instead of globally)

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