Releases self-hosted SeekTable

2019 Dec 12
  • New XMLA OLAP connector for SSAS/Azure Analysis Services.
  • Flat tables: added pagination option (2 modes: prev/next and "show more")
  • Exports: added "Export All Data" option (download all report data, disregard web-view limits/pager position)
  • Backup: indent cubes/reports JSON configuration in the XML file
  • Team Sharing: fixed issue when in shared report "Apply" button is visible without tabs
  • New formatting specifiers: month number (1-12) to month name {0:MMM}/{0:MMMM}, shorten large numbers with k/M/B suffix {0:0.#|kMB}
  • Fixed UI issue with web-combo when many-many columns are selected for the report
  • White-label mode: now it is possible to change 'base' (green) color with a simple CSS rule
  • Starting from this version PivotData microservice license key can be a part of SeekTable subscriptions
  • Reporting engine: see PivotData microservice v.1.6.0 changes log
2019 Oct 25
  • Public reports: added ability to embed reports in a secure way with JWT authorization. JWT may include report parameters for row-level security rules.
  • Public reports: added CSS-animated preloader if report rendering takes more than 300ms.
  • Usability: sync report/cube config when SeekTable is opened in several tabs (share the same login session).
  • Usability: show 'confirm overwrite' dialog on cube save if configuration was changed during edit
2019 Oct 02
  • Team sharing: added Groups to simplify management of large teams. You can create any number of user groups and configure access to cubes/reports for these groups.
  • DB cubes: added Apply pivot table filter as condition parameter that enables translation of user-defined table filter into database query condition. This option unlocks any-level drill-down even for large databases.
  • SQL cubes: added Use "GROUP BY CUBE" option that enables totals/sub-totals calculation for custom-SQL measures (Type=FirstValue)
  • ElasticSearch: now it is possible to configure custom ES bucket or metric aggregation ("histogram", "extended_stats" etc)
  • Charts: use integer-labels for axis labels with numbers
  • Charts: if line/area/scatter axis contains a lot of labels display only some of them (by interval)
  • Public reports: more memory-efficent rendering (affects huge reports)
  • Public reports: when auto-refresh is enabled do not refresh if page is not visible (document.visibilityState is 'hidden')
  • Public reports: use webcombo instead of dropdown for parameters with Editor=Dropdown and if number of items > threshold (20 by default, configurable)
  • Public reports: warning is displayed when report parameters passed in URL are ignored because of incorrect format
  • Other minor improvements and fixes (including vertical page scroll issue)
  • Reporting engine: see PivotData microservice v.1.5.5 changes log
2019 Jul 18
  • Added WS-Federation single sign-on (SSO) for Azure Active Directory or Azure Directory FS
  • White-label mode new settings: ability to specify custom favicon, signup button text, get started content. Now colors for charts may be customized with CSS rules (including legend colors in the table).
  • Fixed issue with CSV file upload if JWT for API is not configured
  • CSV cube: added "Variance" measure type that can be used for calculation of [sample] variance/standard deviation
  • Expressions: added math functions like Math.Round, Math.Pow, Math.Sqrt (unlocks possibility to calculate standard error by standard deviation)
  • More convinient validation of 'Dropdown (dynamic)' editor of report parameters
  • Other minor improvements and fixes
  • Reporting engine: see PivotData microservice v.1.5.3 changes log
2019 Jun 17
  • CSV connector: now it is possible to use report parameters and specify filtering expression for rows
  • Cube parameters: added ability to populate dropdown values dynamically
  • Calculated members: added Html.Raw function that accepts 2 arguments to specify different value for non-HTML exports
  • Published report: fixed UI issue with input=date (inside ST app datepicker is also replaced with native input=date that used browser's settings for date format)
  • Published report: fixed issue with incorrect chart tooltips (on mouse over)
  • Minor UI fixes and usability improvements
  • Reporting engine: PivotData microservice v.1.5.2 changes log
2019 Apr 02
  • CSV connector: now it is possible to use report parameters and specify filtering expression for rows
  • MongoDb connector: added possibility to specify custom stages (before/after $group)
  • Report parameters: added ability to choose an editor (textbox, dropdown or multivalue dropdown, checkbox) and specify custom expression to evaluate parameter value
  • White-label mode new options: "Custom Public Report CSS", "Custom Public Report footer HTML", "Custom Signup Page HTML"
  • Added API key generation that may be used with Zapier or MS Flow
  • Share by email: if chart is enabled it is also included into email body as image
  • When there is no saved reports for the cube SeekTable tries to suggest several reports (by date, by location etc).
  • Pivot table report type: quick links to change "expand/collapse" mode if several dimensions are selected for rows or columns.
  • Set of minor UI fixes and usability improvements
  • Reporting engine: PivotData microservice v.1.5.1 changes log
2019 Feb 22
  • New feature: expand/collapse mode for pivot tables (can be enabled in "Format" tab)
  • New feature: "show rows" in drill-down menu (appears on value-cell click in pivot tables)
  • Expressions: now Html.Raw and Html.Link are supported in pivot tables
  • Reporting engine: PivotData microservice v.1.5.0 changes log
2019 Feb 01
  • Added ability to enable "Clone" for CSV cubes (with variable in 'docker-compose.seektable.env')
  • Added new option for "Restore" dialog (available for self-hosted SeekTable admins): "Generate new record IDs" which restores cubes/reports with new IDs. This mode is useful for 'mass-clone' when backup is restored in the same account, or to re-create the some sample cubes in another account(s).
2019 Jan 22
  • New feature: white label mode (available only for self-hosted SeekTable with paid subscription): use your company logo/brand instead of SeekTable, hide "Generated by" and "Powered by" notices in app/exports/shared reports, hide links to website, set custom footer content for emails and PDF export, customize SeekTable app visual styles by adding your own CSS.
  • Added ability to override saved report options with 'cfg' URL parameter
  • A lot of minor improvements / bugfixes
  • Reporting engine: PivotData microservice v.1.4.4 changes log
2018 Nov 29
  • New feature: Configure Published Report form (UI for public link options)
  • New feature: Backup cubes/reports configuration (XML) that can be restored by self-hosted admin
  • Fix: filter autcomplete positioning issue
  • Expressions: added Html.SetReportParameters function (sets report parameter(s) on click), Html.Link and Html.Raw (for 'flat table' reports only)
  • Public report: when parameters are changed this is reflected in URL, browser back can be used as 'undo'
  • ElasticSearch data source: now parameters are supported and may be used in special filtering condition
  • Reporting engine: PivotData microservice v.1.4.3 changes
2018 Oct 23
  • New feature: self-hosted administration (available only for self-hosted SeekTable with paid subscription)
  • New feature: team sharing when cubes/reports may be shared to other SeekTable users with access control (paid subscription)
  • New feature: advanced publishing/embedding options for reports published to web (paid subscription)
  • New data source: Oracle
  • Flat tables optimization: supported up to 50k rows, this limit can be increased in self-hosted SeekTable
  • Reporting engine: PivotData microservice v.1.4.1 changes
  • SeekTable web application migrated to .NET Core 2.1 (better performance and stability)
  • Now report parameters may be specified in public report URLs (reports published to web)
  • A lot of minor enhancements and bugfixes
  • Reporting engine: PivotData microservice v.1.4.0
  • First release of docker images for self-hosted SeekTable
  • Self-hosted version offers exactly the same functionality as cloud version
  • Based on reporting engine PivotData microservice v.1.3.2