Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029988ModulesAnalyticspublic2015-05-22 16:232015-06-29 12:48
Reporterngarcia 
Assigned Tongarcia 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
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
Summary0029988: Tree structure is not shown in OB Analytics window although Ignore Tree Hierarchy is not selected
DescriptionTree structure is not shown in OB Analytics window although Ignore Tree Hierarchy is not selected
Steps To ReproduceAs group admin role:
   Create a new Product Category and set it as Summary Level
   Drag and drop two product categories inside of it
As system admin role:
   Launch the Update Time Dimension Refs + Tree Closure Table process from Process Request window
As group admin role:
   Launch the Update Analytics Fact Tables process from Process Request window
   Go to OB Analytics Cube, refresh the cubes and select the Sales Details Fact Cube
   Add Product Category dimension in Columns and Quantity measure in Rows
   Check tree structure is not displayed, all the product categories are shown in the same row
   If you click the Non-empty button in the toolbar you will see the newly created category with a 0 value
   Remove the Product Category dimension and add the Organization one and check you see it as a tree
   
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0029989 closed mtaal It would be fine if Analytics supported more entities with tree structure 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-22 16:23ngarciaNew Issue
2015-05-22 16:23ngarciaAssigned To => platform
2015-05-22 16:24ngarciaIssue Monitored: networkb
2015-05-22 16:24ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8649#r8649
2015-05-22 17:01ngarciaRelationship addedrelated to 0029989
2015-05-25 12:57ngarciaResolution time => 1433800800
2015-06-03 11:23alostaleStatusnew => scheduled
2015-06-03 11:23alostaleAssigned Toplatform => caristu
2015-06-03 18:00caristuStatusscheduled => feedback
2015-06-03 18:04caristuNote Added: 0078033
2015-06-03 18:04caristuNote Edited: 0078033bug_revision_view_page.php?bugnote_id=0078033#r8741
2015-06-03 18:04caristuNote Edited: 0078033bug_revision_view_page.php?bugnote_id=0078033#r8742
2015-06-09 09:05caristuAssigned Tocaristu => ngarcia
2015-06-29 12:48caristuReview Assigned To => caristu
2015-06-29 12:48caristuNote Added: 0078554
2015-06-29 12:48caristuStatusfeedback => closed
2015-06-29 12:48caristuResolutionopen => no change required
2015-06-29 12:49caristuNote Edited: 0078554bug_revision_view_page.php?bugnote_id=0078554#r8924

Notes
(0078033)
caristu   
2015-06-03 18:04   
It could be a configuration problem. The product category dimension has the "Ignore Tree Hierarchy" set to true by default.

If this flag is deactivated and after that we run the "Update Analytics Fact Tables" process from Process Request window, the Product Category dimension can be displayed in tree view in the OB Analytics window.
(0078554)
caristu   
2015-06-29 12:48   
(edited on: 2015-06-29 12:49)
Confirmed that this is a configuration issue. By configuring the dimension as explained in note https://issues.openbravo.com/view.php?id=29988#c78033 [^] it can be shown as a tree structure.