BacklogΒΆ
This section lists features and improvements planned for development in 2026.
# |
Feature |
Description |
Status |
|---|---|---|---|
1 |
Jinja context variables |
Support for passing custom context variables into Jinja templates at query time, enabling dynamic parameterization of cube SQL scripts. |
Done (2.0.10) |
2 |
StarRocks connector |
Support for connecting XLTable to StarRocks as a data source. |
Done (2.0.10) |
3 |
Cube structure validation module |
A developer-facing tool that validates cube SQL scripts before deployment: checks tag syntax, alias uniqueness, mandatory block order, and relationship consistency. |
Done (2.0.11) |
4 |
Databricks connector |
Support for connecting XLTable to Databricks as a data source. |
Done (2.0.11) |
5 |
Windows 10 and 11 support |
Full support for running XLTable on Windows 10 and Windows 11. |
Done (2.0.11) |
6 |
Greenplum connector |
Support for connecting XLTable to Greenplum as a data source. |
Done (2.0.12) |
7 |
Drill-through |
Ability to view the underlying detail rows behind an aggregated cell value in Excel. |
Done (2.0.14) |
8 |
Collapse all |
Ability to collapse all expanded hierarchy levels in an Excel Pivot Table with a single action. |
Done (2.0.15) |
9 |
AI assistant for cube design |
An AI-powered assistant that helps developers design cube structure, suggest measure and dimension definitions, and detect common mistakes. |
Done (Beta) |
10 |
Semantic layer for AI agents |
Expose the XLTable semantic layer (measures, dimensions, hierarchies, access rules) as a structured interface consumable by AI agents and LLM-based tools. |
Done (Beta) |
11 |
Native data types in dimension attributes |
Currently all dimension attributes are cast to string. Planned support for integer and date types, allowing dimension values to be used in Excel with their native format. |
|
12 |
Sort by another field |
Ability to sort a dimension attribute by the values of a different field (for example, sort month names by month number). |
|
13 |
Slicers support |
Native support for Excel slicers connected to XLTable cube dimensions. |
|
14 |
DAX support |
Support for DAX query language alongside MDX for cube interaction. |
|
15 |
Power BI connection |
Support for connecting Power BI to XLTable as a data source. |
|
16 |
Free tier with limited functionality |
A free edition of XLTable with a restricted feature set for evaluation and small-scale use. |
|
17 |
Built-in Jinja functions |
A library of built-in Jinja functions available in cube SQL templates for common transformations, date handling, and formatting operations. |