Skip to main content
Community Admin
jcooleyCommunity Admin
Community Admin
Apr 17, 2026 1:00 PM UTC

Tech Talks After Hours: Dynamic Grid Components

Join Heather Upton and Tom Linton as they explore Dynamic Grid Components, breaking down how flexible grid design can simplify complex models and enhance the end‑user experience.

Key Topics Covered

  • Dynamic Grid component overview: displays data from Analytic Blend tables directly on a OneStream dashboard, within the workspace framework
  • Key differentiator from SQL Table Editor: Dynamic Grid loads data page by page rather than all at once, making it significantly faster for large datasets
  • Pagination: data is rendered per page; row count and page count are visible in the bottom-right corner of the grid
  • Server-side search and filtering: filters are applied at the server before data is returned, avoiding the need to load a full dataset to the client — critical for performance with large operational data sources
  • Use case: displaying operational data alongside financial data to enrich analysis, without pulling an entire external database to the user's machine
  • Formatting: basic properties set in the component settings; fine-tuned formatting (including conditional cell colors) applied via the assembly file — assembly file settings take precedence over component-level properties
  • Conditional color formatting: apply company colors, status indicators, or accessibility-friendly colors per column or cell value
  • Button controls: Edit, Add Row, and Delete buttons can be individually shown or hidden to control what end users are permitted to do — useful for enforcing data governance
  • Data retrieval: uses the GetDynamicData class to pull data from the blend source into the grid
  • Data writeback: uses the SaveDynamicData class to push changes back into the data source from within the grid
  • Change actions: inserting new rows, updating existing rows, and deleting rows — all configurable based on user permissions
  • Popup features: inline editing and detail views accessible directly from the grid
  • Integration with the workspace and assembly framework — see the Dynamic Dashboards Tech Talk series for deeper coverage of that layer
  • End-user experience: non-technical users can search, filter, and interact with large datasets through a friendly interface without needing coding knowledge
     

 

Terms & ConditionsAccessibility statement