0042275: OB Analytics doesn’t show all Product Category having some hierarchy levels with product categories

Description

Having 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).

Tags

No tags attached.

Attached Files

Img 01 - Product Category Hierarchy.png [^] (109,740 bytes) 2019-11-14 10:26

Img 02 .- Hierarchy not fully shown.png [^] (148,556 bytes) 2019-11-14 10:27

DoNotHideParents.png [^] (106,693 bytes) 2019-12-09 17:51

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
(0116157) caristu (manager) 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 [^]

Issue History
Date Modified	Username	Field	Change
2019-11-14 10:26	santi_lozano	New Issue
2019-11-14 10:26	santi_lozano	Assigned To	=> Retail
2019-11-14 10:26	santi_lozano	File Added: Img 01 - Product Category Hierarchy.png
2019-11-14 10:26	santi_lozano	Resolution time	=> 1575500400
2019-11-14 10:26	santi_lozano	Triggers an Emergency Pack	=> No
2019-11-14 10:27	santi_lozano	File Added: Img 02 .- Hierarchy not fully shown.png
2019-12-02 08:23	marvintm	Assigned To	Retail => platform
2019-12-09 17:47	caristu	Relationship added	related to 0035570
2019-12-09 17:51	caristu	Review Assigned To	=> caristu
2019-12-09 17:51	caristu	Note Added: 0116157
2019-12-09 17:51	caristu	Status	new => closed
2019-12-09 17:51	caristu	Resolution	open => no change required
2019-12-09 17:51	caristu	File Added: DoNotHideParents.png