Question

Thank you so much for developing this tool.

We are testing Saiku 2.0 GA on CentOS with Pentaho EE 3.8.0.GA.45229 against mainly Oracle 11g with some nice success when compared to Pentaho Analyzer.

The UI is much more responsive and in general more liked by our testers for getting the answers they need, however there are a couple of shortfalls.

Our testers (and our DBA) especially appreciated the simple messages that the system was processing which also removed any ability to click on other screen elements. This prevented the rather annoying Analyzer trait of executing unintentional mouse clicks.

The screen layout matches the report authoring process better in the sense that everything was left-to-right.

On the downside, Saiku does not provide the same formatting abilities, totals and (the already mentioned) inability to have the same dimension in filters and columns. Should we expect to see these items addressed in up-coming releases?

Accepted Answer

Okay lets see then,

totals have been asked for by a number of people, but adding subtotals to an product like Saiku is very non standard, what I am hoping Paul will be able to add very soon is support for VisualTotals() which basically adjusts the All Member level to display the total for the values on displayed in the table instead of All the members, I believe this will cover an awful lot of use cases.

Column formatting will arrive that is for sure, but when I'm not so sure about, probably 2.2 onwards depending on complexity.

Lastly it is physically impossible to put a level or dimension on both filters and rows/columns, but that said if you put it on the rows and column axis and double click on it like you would in the filters to select individual members, you will get exactly the same result. The UX for this isn't as good as we would like and its something we are working on, but again that will come in time.

Cheers

Tom

Answer 2

0	For people related to data analysis totals is vital even an old tool like jpivot allows total. Better yet. % per rows and columns would be great. link answered 25 Jan, 09:48 collazosc 1 accept rate: 0%

Answer 3

0	yeh we will have it again, dont you worry :) % per rows and columns?? whats that supposed to mean? link answered 26 Jan, 07:12 pstoellberger ♦♦ 897●2●7 accept rate: 5%

Answer 4

0	i think he means percentage of total of a column link answered 07 Feb, 09:16 mgiepz 1 accept rate: 0%

Answer 5

0	I'm switching from JPivot to Saiku and the only feature that I miss is the totals from the "All Members". I hope that this feature will be released soon in Saiku too. Great Job, link answered 10 Mar, 09:08 DavideGEP 1 accept rate: 0%

Answer 6

it will reappear again as configuration

in the mean time you can edit one file to get it:

if you're using the plugin: saiku/ui/js/saiku/models/Result.js

change that line:

    return encodeURI(this.query.url() + "/result/flattened");

to

    return encodeURI(this.query.url() + "/result/hierarchical");

the hierarchical formatting has some layouting issues, but once thats fixed it will be an option that you can choose

Are totals and column fomatting planned?

Follow this question

Related questions