Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042275Retail ModulesRetail Analyticspublic2019-11-14 10:262019-12-09 17:51
Reportersanti_lozano 
Assigned Toplatform 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042275: OB Analytics doesn’t show all Product Category having some hierarchy levels with product categories
DescriptionHaving product categories grouped into some hierarchy levels and some of them at the last level and others at the one before, OB Analytics only shows the last level product categories (two images provided of the hierarchy and the analytics result)
Steps To Reproduce*go to Openbravo livebuilds section Retail with Modules link pgsql backend
*change role to System Administrator, go to Cube Definition window. Select Sales Details Fact Cube, go to its tab Cube Dimensions. Search row with productCategory as Model Element, change the field of Ignore Tree Hierarchy to not selected for that row
*change role to F&B International Group Admin. Go to Product Category window. Create a hierarchy like in the attached image (Img 01 - Product Category Hierarchy.png). To make this create a new record with: Organization = *, Search Key = Product Grandpa, Name = Product Grandpa, Summary Level = selected, Seq. No = 01. Create a new record with: Organization = *, Search Key = Product Father, Name = Product Father, Summary Level = selected, Seq. No = 03. create a new record with: Organization = *, Search Key = Product Grouped, Name = Product Grouped, Summary Level = selected, Seq. No = 05. Then click on button Toggle Tree Grid Visibility, to see the hierarchy, move the products to the folders in order to have the hierarchy as seen in the image. Product Grandpa is the root, which contains Product Father, …
*Go to Process Request window, create a new process: Client = F&B International Group, Organization = *, Process = Forward Update Analytics Fact Tables, Timing = Run Immediately (the rest the default values). Then click on button Schedule Process. Wait until it’s on Success Status (on tab Process Monitor, you should refresh the window to see it)
*go to OB Analytics windows, select cube Sales Details Fact Cube. Add Sales on Measures (drag it from the left Measures menu to the one on the right), add Product Category on Rows (the Product Category which is inside Product Category > Product Category Hierarchy > Product Category). Then you can see the result as in the attached image (Img 02 .- Hierarchy not fully shown.png).
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0035570 new Triage Platform Base Modules Trees without a common parent node are shown in different order in OB Analytics window than in tree view of its window 
Attached Filespng Img 01 - Product Category Hierarchy.png (109,740) 2019-11-14 10:26
https://issues.openbravo.com/file_download.php?file_id=13531&type=bug
png

png Img 02 .- Hierarchy not fully shown.png (148,556) 2019-11-14 10:27
https://issues.openbravo.com/file_download.php?file_id=13532&type=bug
png

png DoNotHideParents.png (106,693) 2019-12-09 17:51
https://issues.openbravo.com/file_download.php?file_id=13647&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2019-11-14 10:26santi_lozanoNew Issue
2019-11-14 10:26santi_lozanoAssigned To => Retail
2019-11-14 10:26santi_lozanoFile Added: Img 01 - Product Category Hierarchy.png
2019-11-14 10:26santi_lozanoResolution time => 1575500400
2019-11-14 10:26santi_lozanoTriggers an Emergency Pack => No
2019-11-14 10:27santi_lozanoFile Added: Img 02 .- Hierarchy not fully shown.png
2019-12-02 08:23marvintmAssigned ToRetail => platform
2019-12-09 17:47caristuRelationship addedrelated to 0035570
2019-12-09 17:51caristuReview Assigned To => caristu
2019-12-09 17:51caristuNote Added: 0116157
2019-12-09 17:51caristuStatusnew => closed
2019-12-09 17:51caristuResolutionopen => no change required
2019-12-09 17:51caristuFile Added: DoNotHideParents.png

Notes
(0116157)
caristu   
2019-12-09 17:51   
Please note that by default the "Hide Parents"[1] option is enabled by default when launching the query.

If the corresponding toolbar button is pressed this option is disabled and the complete hierarchy is shown. See attached "DoNotHideParents" screenshot.


[1] http://wiki.openbravo.com/wiki/Modules:OB_Analytics_View#Toolbar [^]