Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042474ModulesAnalyticspublic2019-12-04 12:422022-02-01 08:07
Reportersanti_lozano 
Assigned ToTriage Platform Base 
PriorityhighSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket12649
OBNetwork customerOBPS
Regression introduced in release
Summary0042474: Drill Through is showing fields by its id instead of by its name
DescriptionOB Analytics button drill through, shows the data by its id instead of showing its name (see image attached)
Steps To Reproduce*go to Openbravo livebuilds, section Retail with module click on link pgsql backend, change role to F&B International Group Admin
*check if Analytics Sales Details View window is empty, if so go to Process Request window and create a new one: Client = F&B International Group, Organization = *, Process = Forward Update Analytics Fact Tables, Timing = Run Immediately. Click on button Schedule Process, wait for it to be on status Success (with the process selected go to Process Monitor tab to see its status). Now Analytics Sales Details View window should have content
*go to OB Analytics window select cube Sales Details Fact Cube, add into Measures “Sales” and “Discounts”, add into Columns Organization, add into Rows Month of Year (drag them from left to the right, note that for dimensions you must expand the menu).
*from the upper menu of OB Analytics (where you have buttons like Save query or Run query), click on button Drill through on cell, then select a cell of sales and january (or other cell)
*in the Drill-Through popup select product as dimension and sales as measure, click ok
*the output is displayed as in the image, showing id (where it was expected a name here)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0042179 closed caristu OB Analytics Drill through error 
Attached Filespng ob analytics - drill through id.png (216,917) 2019-12-04 12:42
https://issues.openbravo.com/file_download.php?file_id=13627&type=bug
png

png drillThrough-names.png (73,113) 2020-02-11 16:32
https://issues.openbravo.com/file_download.php?file_id=14016&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2019-12-04 12:42santi_lozanoNew Issue
2019-12-04 12:42santi_lozanoAssigned To => Retail
2019-12-04 12:42santi_lozanoFile Added: ob analytics - drill through id.png
2019-12-04 12:42santi_lozanoOBNetwork customer => OBPS
2019-12-04 12:42santi_lozanoSupport ticket => 12649
2019-12-04 12:42santi_lozanoResolution time => 1577228400
2019-12-04 12:42santi_lozanoTriggers an Emergency Pack => No
2019-12-04 12:43santi_lozanoDescription Updatedbug_revision_view_page.php?rev_id=19858#r19858
2020-01-27 12:13maiteTypedesign defect => defect
2020-01-27 12:13maiteProjectRetail Modules => Modules
2020-01-27 12:14maiteResolution time1577228400 => 1581894000
2020-01-27 12:14maiteCategoryRetail Analytics => Analytics
2020-01-27 12:15maiteRelationship addedrelated to 0042179
2020-02-11 16:31caristuNote Added: 0117647
2020-02-11 16:32caristuFile Added: drillThrough-names.png
2020-02-11 16:33caristuAssigned ToRetail => maite
2020-02-11 16:33caristuStatusnew => feedback
2020-02-13 09:37caristuAssigned Tomaite => platform
2020-02-13 09:38caristuStatusfeedback => new
2020-02-13 09:38caristuTypedefect => design defect
2020-02-13 09:38caristuStatusnew => acknowledged
2020-02-13 09:41caristuResolution time1581894000 =>
2022-02-01 08:07alostaleAssigned Toplatform => Triage Platform Base

Notes
(0117647)
caristu   
2020-02-11 16:31   
This issue can be workarounded by adding a new dimension to display the names, ie:

1- Go to the Cube Definition window
2- Create a new record in the Cube Dimension tab:
   - Model element: product.name
   - Name: Product Name
3- Repeat the steps to reproduce but select the newly created dimension in the "Drill-Through" popup

The product names should be displayed (see attached drillThrough-names.png image)