Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037323
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Analyticsmajorhave not tried2017-11-20 09:382017-12-12 17:07
ReportercaristuView Statuspublic 
Assigned Tocaristu 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision6edbfc13e4ef
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Regression introduced in release
Summary

0037323: Saiku generates slow queries in some cases when joining multiple dimensions

DescriptionAfter the upgrade to Saiku 3.7.4 (Analytics version 1.3.0), queries generated by using the Saiku UI that join several dimensions are taking much more time that in previous versions being in environments with big amount of data.

This seems to be caused because of the usage of the "asterisk" operator to join the dimensions within the generated query. For more information see https://github.com/OSBI/saiku/issues/606 [^]
Steps To ReproduceIn an environment with big amount of data:

1) Go to the [OB Analytics] window.
2) Select the "Sales Details Fact Cube"
3) Add a couple of measures
4) Add at last 3 dimensions into the "Rows" section (See attached image). Notice that execution of the query is lasting much more that in versions previous to the Analytics upgrade (1.3.0).
TagsNo tags attached.
Attached Filespng file icon queryAnalytics.png [^] (145,096 bytes) 2017-11-20 10:00

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0100612)
hgbot (developer)
2017-11-20 10:13

 Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 6edbfc13e4efe1f883f6ec7df93ed581fc40fcf0
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Nov 20 09:43:43 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/6edbfc13e4efe1f883f6ec7df93ed581fc40fcf0 [^]

fixes bug 37323: Saiku generates slow queries when joining multiple dimensions

  Updated the Saiku Query library with some changesets already present in the Saiku Query repository[1] which prevent the usage of the asterisk operator when joining multiple dimensions. These changesets were included in the Saiku Query repository after the update of the Saiku Query library in Analytics[2].

  The source code of this new library version can be found here[3].

[1] https://github.com/OSBI/saiku-query/commit/399e68c5e763521ce6ea15b7fdcfcc5adb47f3fd [^]
[2] https://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/2b218040d291 [^]
[3] https://github.com/caristu/saiku-query/releases/tag/1.4.600 [^]

---
A lib/runtime/saiku-query-0.1-ob-1.4.600.jar
R lib/runtime/saiku-query-0.1-20150605.103918-2.jar
---

- Issue History
Date Modified Username Field Change
2017-11-20 09:38 caristu New Issue
2017-11-20 09:38 caristu Assigned To => caristu
2017-11-20 10:00 caristu File Added: queryAnalytics.png
2017-11-20 10:13 hgbot Checkin
2017-11-20 10:13 hgbot Note Added: 0100612
2017-11-20 10:13 hgbot Status new => resolved
2017-11-20 10:13 hgbot Resolution open => fixed
2017-11-20 10:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/6edbfc13e4efe1f883f6ec7df93ed581fc40fcf0 [^]
2017-11-20 10:13 caristu Review Assigned To => alostale
2017-12-12 17:07 alostale Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker