Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042424ModulesAnalyticspublic2019-11-27 16:442019-12-09 17:10
Reporterlbressan 
Assigned Toplatform 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionopen 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tocaristu
Support ticket
OBNetwork customer
Regression introduced in release
Summary0042424: Subtotals are not properly shown for tree hierarchy based dimensions
DescriptionSubtotal sum is showed in incorrect column for organization dimension in tree mode.
Steps To ReproduceInstall Analytics module
Go to OB Analytics window
Select Sample Purchase/Sales Order Line Cube
Select Line Net amount as Measure, Organization and business partner category dimensions as rows, Year and month of order date as columns.
Set sum as subtotal in organization dimension.

When run this query, the result of sum is showed in incorrect columns as you can see in the video.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? OB Analytics.webm (4,203,933) 2019-11-27 16:44
https://issues.openbravo.com/file_download.php?file_id=13607&type=bug
png SumWithoutTreeHierarchy.png (248,370) 2019-12-09 17:08
https://issues.openbravo.com/file_download.php?file_id=13645&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2019-11-27 16:44lbressanNew Issue
2019-11-27 16:44lbressanAssigned To => platform
2019-11-27 16:44lbressanFile Added: OB Analytics.webm
2019-11-27 16:44lbressanResolution time => 1576623600
2019-12-09 17:08caristuReview Assigned To => caristu
2019-12-09 17:08caristuNote Added: 0116155
2019-12-09 17:08caristuStatusnew => closed
2019-12-09 17:08caristuFile Added: SumWithoutTreeHierarchy.png
2019-12-09 17:10caristuSummarySubtotal sum is showed in incorrect column for organization dimension in tree mode. => Subtotals are not properly shown for tree hierarchy based dimensions

Notes
(0116155)
caristu   
2019-12-09 17:08   
This in an issue in Saiku, it is not rendering properly the subtotals for the tree based dimension.

A workaround for this issue is not use a dimension not build as a hierarchy (this is done by selecting the "Ignore Tree Hierarchy checkbox, see[1])

See the attached image "SumWithoutTreeHierarchy.png" where we are using subtotals for the organization dimension which is not defined as a tree hierarchy.

[1] http://wiki.openbravo.com/wiki/Modules:Analytics_CubeDef#Dimensions [^]