Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037323ModulesAnalyticspublic2017-11-20 09:382017-12-12 17:07
Reportercaristu 
Assigned Tocaristu 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Support ticket
OBNetwork customer
Regression introduced in release
Summary0037323: 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).
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng queryAnalytics.png (145,096) 2017-11-20 10:00
https://issues.openbravo.com/file_download.php?file_id=11302&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2017-11-20 09:38caristuNew Issue
2017-11-20 09:38caristuAssigned To => caristu
2017-11-20 10:00caristuFile Added: queryAnalytics.png
2017-11-20 10:13hgbotCheckin
2017-11-20 10:13hgbotNote Added: 0100612
2017-11-20 10:13hgbotStatusnew => resolved
2017-11-20 10:13hgbotResolutionopen => fixed
2017-11-20 10:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/6edbfc13e4efe1f883f6ec7df93ed581fc40fcf0 [^]
2017-11-20 10:13caristuReview Assigned To => alostale
2017-12-12 17:07alostaleStatusresolved => closed

Notes
(0100612)
hgbot   
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
---