Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0042424 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Analytics | major | always | 2019-11-27 16:44 | 2019-12-09 17:10 | |||
| Reporter | lbressan | View Status | public | |||||
| Assigned To | platform | |||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50 | SCM revision | ||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | caristu | |||||||
| Regression introduced in release | ||||||||
| Summary | 0042424: Subtotals are not properly shown for tree hierarchy based dimensions | |||||||
| Description | Subtotal sum is showed in incorrect column for organization dimension in tree mode. | |||||||
| Steps To Reproduce | Install 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  OB Analytics.webm [^] (4,203,933 bytes) 2019-11-27 16:44 SumWithoutTreeHierarchy.png [^] (248,370 bytes) 2019-12-09 17:08
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0116155) caristu (manager) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2019-11-27 16:44 | lbressan | New Issue | |
| 2019-11-27 16:44 | lbressan | Assigned To | => platform |
| 2019-11-27 16:44 | lbressan | File Added: OB Analytics.webm | |
| 2019-11-27 16:44 | lbressan | Resolution time | => 1576623600 |
| 2019-12-09 17:08 | caristu | Review Assigned To | => caristu |
| 2019-12-09 17:08 | caristu | Note Added: 0116155 | |
| 2019-12-09 17:08 | caristu | Status | new => closed |
| 2019-12-09 17:08 | caristu | File Added: SumWithoutTreeHierarchy.png | |
| 2019-12-09 17:10 | caristu | Summary | Subtotal sum is showed in incorrect column for organization dimension in tree mode. => Subtotals are not properly shown for tree hierarchy based dimensions |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |