How to show all members (Total) in your Saiku´s analysis

This question is very common and simple to be solved.

Let’s do an analysis on the cube SteelWheels: “What is the amount of sales per year and in periods of four months?”

SELECT
NON EMPTY {Hierarchize({[Measures].[Quantity]})} ON COLUMNS,
NON EMPTY {Hierarchize({{[Time].[Years].Members}, {[Time].[Quarters].Members}})} ON ROWS
FROM [SteelWheelsSales]

By default, Saiku comes with Hide Parents button enabled. If you want a vision of the total, just disable it:

You can make it disabled by default. To do this, edit the following file:

biserver-ce\pentaho-solutions\system\saiku\ui\js\saiku\Settings.js

Search for:

CELLSET_FORMATTER: "flattened"

And change it to:

CELLSET_FORMATTER: "flat"

 

Reference: http://ask.analytical-labs.com/questions/1819/hide-parent-how-to-activatedeactivate-by-default