Saiku Changelog

What's new in Saiku 3.7

Dec 30, 2015
  • NEW FEATURES:
  • Standalone:
  • For standalone server users we have tweaked the save and load dialogs so they will go back to wherever you were last in the directory tree, this may seem minor, but it is a welcome tweak for those of us who save a lot of queries and don’t want to navigate to our home directory every time.
  • There was also an issue caused by a Spring update that meant that if users had no role they were denied access to the platform. To offset this we now make ROLE_USER mandatory (this can be altered in the security configuration) which means your users should always be able to login. Saiku CE has seen a lot of community contributed improvements to its experimental XMLA support, this will be migrated across to EE once we are happy with its stability.
  • The Saiku XMLA server allows users to connect to Saiku data sources from Excel which gives power users the ability to perform analysis on the same data sets but from an Excel pivot table instead of the Saiku UI.
  • We’ve also tidied up some of the errors that were getting thrown in the logs, this were not an issue but did worry people who’s logs were being cluttered up with false error messages.
  • Pentaho Plugin:
  • For those of you who use the BI server, there are some changes there too thanks to the guys at Stonegate we have updated the Open/Close dialog here to support Lazy Loading, the Pentaho repo lookup was sluggish and for those of you with massive repositories, unusable, so we have added lazy loading to the dialogs to speed up the rendering of the directory structure.
  • Also in the performance bracket, we have updated the data source lookup code to stop it re-initializing the data sources multiple times on login, this was slowing down the plugin and making load times much longer than required. It will still load the data sources once, but after that it will load them from cache which will make the performance much snappier.
  • We have also accepted a couple of contributions from the community and applied some of our own to the new audit code in the plugin which allows Saiku to make use of the BI server audit framework to let administrators track user actions in the BI server over time.
  • We have added support for the Pentaho BI Server 6, which means those of you who like to run bleeding edge, can.
  • On both platforms we have also added a lot more i18n tags to the UI which means that those of you who work in a non English browser can submit improved translations for Saiku to us and we can provide much improved internationalization support.
  • Anyway for those of you who use Saiku Server you can find it over on our website, and those of you who use the Pentaho BI server you will find it in the marketplace.

New in Saiku 2.5 (Jul 18, 2014)

  • What's new:
  • charts: new chart types (heatgrid, area, dot, ..) , improved settings, upgrade to ccc2, improved result, basic chart export
  • spark lines / spark bars
  • top count (and other limit functions), sorting, filter methods in DnD query model
  • improved parent child hierarchy support (fixed major bugs, show children)
  • repository improvements (search, sorting, permissions?)
  • direct export endpoints to xls, csv, json (including parameters - all with 1 http call)
  • improved encoding (use caption, but works with name attribute now as well)
  • improved i18n - fix chrome issues, more options, languages: croatian, hungarian, german, ...
  • experimental PDF export
  • use last result for selections if possible (e.g. filter on 2003 and select all months, month dialog will show only months for 2003)
  • mdx editor now uses ACE (run query with cmd + enter / ctrl + enter), prepare for auto completion / mdx syntax highlighting
  • open / save dialog for queries
  • performance tuning
  • save chart / table options (persist viz)
  • Standalone:
  • datasource processor (modify datasource definition before connection establishing, e.g. role access to datasource), connection processor (modify the existing connection object. e.g. programmatic role)
  • Plugin:
  • improved mondrian sharing, plugin path conventions (drop into solutions/saiku/plugins and it will be picked up by UI, easily update plugin without loosing extra plugins)
  • run saiku query in pentaho scheduler to generate xls

New in Saiku 2.4 (Feb 26, 2013)

  • Apache License Version 2.0
  • Folders and Permissions in Repository - You can now create folders and set permissions on files/folders in the repository (saiku standalone version).
  • New Result Option (Hide Parents) - This feature lets you decide if you want to show parent members or not.
  • Conditional Formatting (from schema.xml and MDX) - Use conditional formatting options as part of the Mondrian Schema Definition or within a MDX query.
  • Examples: https://gist.github.com/3899805
  • New Excel Export - The Excel Export has been reworked and is now much faster and includes more useful information.
  • Navigational Context Menu - A new context menu for the result table in saiku's DnD mode allows you to quickly navigate through your data.
  • Other small improvements - Explain plan for queries, respect visibility flags of OLAP objects, select multiple measures in drillthrough ...

New in Saiku 2.3 (Feb 26, 2013)

  • Sorting - You can sort your results now by name or measure.
  • Tags - With this new feature you can create new tags (some might call them named filter sets) based on one or serveral cells in your resultset. Saiku will then take the tuples that make up this result and you can apply them to any new query on this cube.
  • Example: You can tag a cell "Male / Year 2003" and name the Tag "Tag1"; then create a completely new query and select products on columns vs. customers on rows and apply "Tag1". Saiku will then show you only products and customers which are Male and where there is data for 2003.
  • MDX Editor - Long promised, and finally implemented. The MDX Editor is back in saiku. You can now switch to mdx mode and run any arbitrary MDX you like and then save it.
  • Tighter integration of the Saiku Biserver Plugin - Picks up mondrian.properties from system/mondrian/mondrian.properties now.
  • Improved datasource management - There were some issues where refreshing connections and applying roles didn't work. Both should work fine now!
  • Improved SSAS Compatibility - We improved various areas in saiku to make sure its perfectly compatible with SSAS.
  • Reworked Drillthrough - You can now choose the columns (levels and measures) that you want to see in your drillthrough result.

New in Saiku 2.2 (Feb 26, 2013)

  • Speed Boost - Query execution received a massive speed improvement.
  • SSAS, Palo, SAP BW Compatibility - We made sure that saiku works perfectly with other OLAP engines.
  • Mondrian Roles - Apply role-based security to your Mondrian OLAP cubes.
  • Query Scenarios - Change cell values on your resultset and perform basic What-If Analysis.
  • Drill-Through - Display or export all fact rows that make up a specific cell in your OLAP resultset.
  • Refresh Datasources / Clear Cache - Reload your datasources configuration and clear the cache from within the UI.
  • Faster and more robust UI - The user interface was completely rewritten for 2.2 and includes lots of speed improvements and bug fixes.
  • Charts - Saiku is now capable to produce some basic charts using CCC by Webdetails.
  • Basic Statistics - You can now view some basic statistics (avg, min, max, std. dev, .etc) of your OLAP query.

New in Saiku 0.8 (Dec 14, 2010)

  • New Query Design workflow
  • Drill Up (opposite of Drill Replace)
  • Major improvements of drill support
  • Fix saving queries (especially on mondrian connections)
  • Inline schema editor
  • Re-Save queries
  • Basic Role support
  • Multiple Hierarchies