OSBI / saiku

Saiku Analytics - The Worlds Greatest Open Source OLAP Browser
http://community.meteorite.bi
Apache License 2.0
1.3k stars 664 forks source link

Incorrect Sort Order #725

Open fabianosandi opened 4 years ago

fabianosandi commented 4 years ago

Is this a bug report?

Yes

Environment

  1. Operating system: Ubuntu
  2. Browser and version (if relevant):
  3. Saiku plugin to Pentaho or Saiku Standalone:
  4. Saiku CE or Saiku EE: CE
  5. Saiku version: 3.8.8

Steps to Reproduce

I have the exacly behavior described in this link: https://forums.pentaho.com/threads/230779-Saiku-analytics-plugin-incorrect-sorting-order/

First I show customer in line and year in columns. My measure is orders count. I put a Grand Total column to summary the period(In my case 2 years).

When I sort (DESC) by orders everthing ends up well.

image

But when I filter year 2020 I get the same result.

Expected Behavior

I expect this output: image

Actual Behavior

image

It's ordering ignoring the filtered year