This is a full list of new features, bug fixes, and other items for all versions of FlexIt Analytics. The version number is based on the year, month and number of release, such as 2018.09.001 (i.e. [Year].[Month].[Release] being the first release of September 2018).
2026.01.001 Snowflake Cortex Semantic Model
New Snowflake Cortex semantic model
Meltano Logging improvements
Grid UI improvements (header wrap, height)
Model migration improvements
2025.12.001 Column-level Lineage
dbt option to skip dependencies install
dbt Snowflake use private key
2025.11.001 dbt Enhancements and AI chat
Data migration improvements
New Semantic Layer generator and fixes
Improvements to data model caching
2025.10.001 Content Migration Improvements
Content migration improvements
New "object" data types for JSON arrays and objects
2025.09.003 Data Ingestion Enhancements
Semantic Layer enhancements
View schedules improvements
Ingestion engine enhancements
Data model migration improvements
2025.08.001 Snowflake and API Improvements
Add query tags to Snowflake queries
Enable broader usage of FlexIt API connectors
New "quoted identifiers" setting for database connectors
Oracle thick client option
2025.07.002 Semantic Layer Improvements
Enable dbt semantic layer metric calculations
Fixes and improved error handling
2025.07.001 Snowflake Key Pair Auth
Add Snowflake Key Pair authentication
2025.06.002 AI Service Integration
Integration with new AI service for text-to-sql and other AI functionality using Open AI or Anthropic
Setting for dbt "target" in local dbt job
Data dictionary tooltip improvements
Pass filters to reports/dashboards in URL
2025.06.001 Semantic Layer and dbt Improvements
dbt Local folder project build
Updates to semantic converter
Tableau semantic layer Windows Authentication connection
Feature to migrate reports between data models
Big Query fixes for SQL and dbt build
Improvements for dbt logging
Data transform destination as SFTP/SSH data source
2025.04.002 OpenAI Integration
OpenAI integration for text-to-SQL
Object level security on entities and columns
"Who has access?" security feature
Semantic layer improvements
SAML authentication improvements
dbt Cloud integration upgrades
Row transformer for data transformation
Orchestrate and build dbt Cloud and dbt-core jobs from FlexIt
Semantic Layer integration for Power BI, Tableau, AWS QuickSight and more
Major enhancements to ELT and data transformation engine
New API data source for data extraction and loading
2024.10.001 dbt Improvements and More
dbt Integration improvements
Dataset column swap feature
Datamodule role improvements
2024.08.001 Data Certification
Certification of data models, columns and metrics
Data lineage improvements
SAML2 Single-Sign-On enhancements
Visualization config improvements
2024.06.001 - dbt Semantic Layer
Integrate with dbt Semantic Layer
dbt multi-package support
2024.05.001 - Data models and ingestion
Incremental data ingestion
2024.03.001 - dbt Integration Enhancements
dbt Natural Language filters
Open dbt Cloud Explorer to column or model
New dbt Metric config in 'meta'
Metadata group labels (folder)
2024.01.001 - Data Transormation Improvements
Data transformation auto-DDL creation
Data transformation config retry attempts on fail
Grid spreadsheet new combine rows feature
2023.11.001 - dbt Column Lineage
Grid feature: frozen columns
2023.10.001 - Datasets, dbt Cloud, SAML
Datasets for lightning speed analytics
dbt integration improvements
SAML integration improvements
2023.08.001 - Snowflake and Row-level Security
Snowflake connector improvements
Row-level security improvements
2023.05.001 - Data Catalog and Natural Language Improvements
New: Data Catalog to explore metadata
New: Natural Language Query filters
New: Natural Language Query field groups
Bug fixes and minor enhancements
2023.04.001 - Data Masking and Rich Text Tooltips
New: create Rich Text tooltips
New: font/text style on all viz components
Conditional Logic improvements
Bug fixes and minor enhancements
2023.02.001 - Field Parameter, Windows Calculations
Field Parameter - feature to show a drop-down list of fields for users to pick from
Window Calculations - calculations for summary table data
Added conditional styling to more vizzes
Enhanced style control on grid/table settings
2023.01.001 - Row-level Security, Okta API Integration
Okta API Integration - manage Okta users from FlexIt
Support for dbt "derived" metrics
Other minor fixes and enhancements
2022.10.001 - dbt Semantic Layer
Added support for the dbt Semantic Layer
Show freshness warnings on reports and metadata
Show warnings for source and model failures in lineage graph
Added 'source freshness' action to alert if data not fresh
Added support for dbt Metrics filters
2022.09.001 - Viz Annotations and Marks, Content as Code
Feature to create annotation Line, Area, and Point marks on visualizations
Dashboards and analyses are code that can be import/exported for migration, source control, etc.
SQL Editor improvements (run snippets, better suggestions)
Improvements to performance of metadata and reports
Natural Language Query improvements
Time grain and other minor fixes
2022.06.001 - Single-sign On and Tableau Connector Improvements
Allow mapping of all FlexIt groups/roles to SAML groups
Improved Tableau Connector data type mappings
Modernized fonts and icons
2022.05.001 - dbt Integration
Time grain feature on date fields (day, week, month, quarter, year)
Synonym/alias on fields for improved Natural Language Query and searching
SAML authentication enhancements
2022.04.001 - BigQuery and Redshift Adapters
Added Google BigQuery connector
Added Amazon Redshift connector
Pivot table column totals
2022.01.001 - FlexIt Usage Reporting
Package FlexIt with reports and models to report on FlexIt usage
Improved query engine join logic
Minor Natural Language Query improvements
2021.12.001 - Global Filters
Natural Language Query improvements
Global Filters in metadata models
Dashboard performance enhancements
2021.11.001 - Natural Language Query
Added Natural Language Processing (NLP) to analyses
Snowflake Connector added
Rendering performance improvements
2021.10.001 - Visualization Overhaul
Complete visualization overhaul
Advanced viz configuration
6 new vizzes: Column and Line, Chord, Gantt, Stream, Waterfall, Histogram
Improved field drag-and-drop
Improved content backup and restore
2021.06.001 - Minor Security Enhancements
2021.05.001 - Scatterplot Timeline
Added scatterplot timeline and marker size
Enhancements to scatterplot, sankey, heatmap, word cloud
Enhancements to top/bottom filters
Oracle BI and PeopleSoft connector enhancements
2021.02.001 - Excel/CSV Upload, Highlight Grid
Upload Excel/CSV to database or instant analysis
Added Highlight/Heatmap feature to grid
Improved Sparkline bar chart on grid
Added column rotate feature
Added conditional icon (~500 icons) feature to grid
Added configuration for showNullAs and row alternateRowColor on grid
Added advanced color picker
2021.01.001 - FlexIt Public Improvements
UI enhancements for public users
Other minor UI enhancements
2020.12.002 – New Vizzes and Dashboard Improvements
Four new visualizations: bullet, parallel, tree, donut
KPI card improvements (multi-KPI, parameters, comparison)
Improved sample reports and dashboards
2020.12.001 – PDF Export and New Calculations
PDF and Image export for reports, dashboards and data portals
% of Total and Rank Calculations added
Dashboard Filter Panel improvements
Minor fixes to query engine
2020.11.001 – Linux and AWS Improvements
Improvements for running FlexIt on AWS
Minor fixes to Data Portals and SQL Editor
2020.10.001 – SQL Editor Improvements and MariaDB
Added Maria DB data source
SQL Editor improvements (syntax highlighting)
Updated REST api documentation
Require license for Oracle connectors
2020.09.002 – New Visualizations
Added Funnel, Gauge, Calendar, Boxplot
Improved viz auto-selection
Improved viz Top-N feature
Improved Samples data, reports, dashboards and data portals
2020.09.001 – Map and Geo Enhancements
Geo enhancements: new base layers and geoJSON sources
Map configuration and other enhancements
Allow Windows Authentication for SQL Server login
2020.08.001 – Data Portals
Data Portals - data portals allow you to create a custom portal web page with tiles to access FlexIt content
Strong password - Added requireStrongPassword option to FlexIt authentication
Search improvements - all search is now live in a smart dropdown
Visualization enhancements
SQL Engine filter improvements
2020.07.001 – Rich Text Editor
Big Number (KPI) viz enhancements
Rich Text editor improvements and use for all HTML tooltips
Sparkline bar chart for Grid percentage columns
ETL: get details of running job
use Rich Text editor for creating tooltip descriptions
ETL and connection improvements
improvements to scheduling reports
2020.06.004 – Minor Fixes and Enhancements
Fix for calculated fields
Impersonation applied to data models
Datasource connection management
2020.06.003 – Direct SQL
Introduction of direct sql, which allows reports to be created from SQL that is directly executed against the database rather than wrapped in sub-queries.
Improve suppress zeros logic
Email: allow "tls-min-v1.0"
External scheduler exit with 0=success and 1=failure, log details using -showMessages
2020.06.002 – Impersonation
Administrators can impersonate any FlexIt user or group, giving them the ability to see FlexIt exactly as that user/group does.
Improved viz axis sorting to allow sort by alpha or values
2020.06.001 – Bug Fixes
2020.05.003 – Data Flow Improvements
Added 'rows per batch' feature
Added 'retry on insert' feature
SQL Editor larger, fixed resizing, and default cols to no aggregate
Fixes to PeopleSoft Query and Oracle BI extracts
2020.05.002 – User and Group Management
Ability to email FlexIt groups
Improvements to nested groups/roles
2020.05.001 – ETL Improvements
Added ETL Actions for SQL or Data Flow tasks based on run results
Added ETL Parameters to use as variables in design flow
Added ETL External Job scheduler
PeopleSoft Query data extraction
2020.04.001 – Dashboard Enhancements
Dashboard share and embed improvements
Added dashboard 'Rich Text' card
Dashboard UI improvements
2020.03.001 – Visualization Improvements
Added visualizations to samples
2020.02.002 – Mapping Viz and Geo Data
Map Viz (GeoJSON and Lat/Lng)
Geo data for world countries (points, boundaries), world postal codes (points), US States (boundaries), and US Zip Codes (points)
Source Geo data from remote
Create Dashboard from New Analysis
Dashboard filter/prompt improvements
Sankey Viz legend control
Fix "Top/Bottom" viz menu
Fix ETL date conversion (Oracle)
Added conditional formatting feature
Added date filter improvement for next/last n days/weeks/months/years
Added text calculation "replace"
Advanced CSV/Excel export allowing selection of header/footer/groups and more
Ability to add query-based text to the bottom right of reports, e.g. "As of Jan 29, 2020 6:23am" based on datawarehouse refresh table query
2020.01.001 – ETL Column Mapping, SQL Server and Oracle upgrades
ETL column mapping and data type conversion improvements
Upgrade drivers for SQL Server and Oracle databases
Viz fixes, REST API accessibility, and other minor enhancements
2019.12.001 – Improved Viz
Start "New Analysis" in design-mode for ad-hoc reporting
Added "Viz" button when Grid-only
Added close button to Grid when Viz and Grid are shown
Enhanced metadata column search, select and add
Oracle BI: looper for logical SQL; allow GO Url for SQL
2019.11.005 – Minor Fixes
2019.11.004 – Minor Fixes
FlexIt server restart fix
2019.11.003 – ETL Column Mapping
ETL Column Mapping from source to destination table
Data conversion option in mapping
Add data sources on the fly
Admin: user management improvements
2019.11.002 – Admin Enhancements
Enhancements to administration portal
Minor fixes to ETL component
2019.11.001 – Oracle DB Improvements
Oracle Database improvements
2019.10.002 – ETL Enhancements
Looper for iterative data requests
ETL History and Job management (cancel, etc.)
2019.10.001 – Encryption Upgrade
Use latest encryption methodologies
2019.08.001 – SQL Engine Fixes
Fixes and enhancements to SQL engine
Oracle BI performance enhancements
2019.07.002 – Oracle BI Data Source
Additional features for pulling data from Oracle BI (OBIEE)
2019.07.001 – Docker Image
First release of FlexIt container image on Docker
2019.06.004 – Enhanced Drilling
Enhanced drilling capabilities to make them easier to set up and smarter when drilling between data sources that have no common metadata models
Improved text/string calculation functions
2019.06.003 – SQL Report Improvements
Improvements to SQL Report performance
Smarter SQL debugging options
Bug fixes for sorting, calculations, and aggregation
2019.06.002 – Filter Enhancements
Added more advanced filter expression capabilities
2019.06.001 – Dashboard Filter Panel
New dashboard filter panel connects all dashboard tiles for global interactive filtering
2019.05.003 – Excel Export
Excel export automatically sets data types as numeric, date, etc.
Improved webservice error handling
2019.05.002 – Minor Fixes
Minor fixes to aggregation and SQL reporting
2019.05.001 – SQL Report Enhancements
Enhancements to SQL reports for better query design and faster performance
2019.04.002 – Home Page Redesign
Redesigned home page to be more friendly with quick links to recent reports and folders
Fixes to calculations and client-side data caching for improved performance
2019.04.001 – SAML Authentication
Configure SAML Identity Providers (e.g. Okta, OneLogin) for authentication
2019.03.002 – Scheduling
Improvements on report scheduling
Use the new Data Transformation feature for Extract Transform Build (ETL) processes.
Added Oracle BI as a Data Source for extracting data via web service calls
2019.02.001 – Net Aggregation
Added/fixed ability to show and use different fields for display on rows or aggregations. Use case is Net Income Statement where you need to display Income and Expenses as positive numbers, but the Total shows Income minus Expenses.
2018.12.001 – Viz Plugin and FlexIt Library
Viz Plugin allows you to create any d3.js visualization.
FlexIt can be used as a client-side Javascript library
2018.11.001 – Visualization Overhaul
Major overhaul to FlexIt visualizations. New vizzes and fixes to existing viz:
Scatterplot with Regression
2018.10.001 – Minor Fixes
FLEX-111 Cannot use same field multiple times on a report
FLEX-233 Metadata error with filter on if..then calc when not saved
FLEX-237 Prompt page “Add Fields” improvements
FLEX-241 Tableau Web Data Connector
FLEX-266 Drill on pivot summary level has incorrect filters
FLEX-269 Error with If/Then/Else Calculation in Metadata
2018.09.001 – Initial Release
This the first official release of FlexIt Analytics to the public. Enjoy!
