Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038609ModulesAnalyticspublic2018-05-23 18:482022-02-01 08:08
Reporterngarcia 
Assigned ToTriage Platform Base 
PriorityurgentSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0038609: Filter is showing different records depending on how the dimension is built
DescriptionFilter is showing different records depending on how the dimension is built. If a dimension is defined as a property navigation, only the available records are shown
Steps To ReproduceAs System Admin role:
   In Process Request window schedule 'Update Time Dimension Refs + Tree Closure Table' to be run immediately

As group admin role:
   Go to Cube Definition window
   Add the following dimension to 'Sample Purchase/Sales Order Line Cube':
      salesOrder.salesRepresentative
   Create a Sales Order with 'POS Order' document type and today's date
   Add a sales representative to it
   Add a product with stock and book it

   Create a record in Analytics Process Configuration window:
      Forward Start Date: today

   In Process Request window schedule 'Clear Analytics Fact Table' to be run immediately
   In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately

   Go to Analytics Sales Detail View and check only one record is shown (only one sales rep is in OBANALY_FACT_ORDER table)

   Go to OB Analytics window and select 'Sales Details Fact Cube'
   Add Sales Representative in Filter
   Check all the users of the client are shown

   Select 'Sample Purchase/Sales Order Line' cube
   Add Sales Representative in Filter
   Check that only the sales representatives assigned to orders are shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038688 closed caristu Filter is showing more records than expected for some dimensions 
Attached Filespng FilterByPath.png (119,923) 2018-05-23 18:48
https://issues.openbravo.com/file_download.php?file_id=11811&type=bug
png

png FilterByColumn.png (142,394) 2018-05-23 18:48
https://issues.openbravo.com/file_download.php?file_id=11812&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2018-05-23 18:48ngarciaNew Issue
2018-05-23 18:48ngarciaAssigned To => platform
2018-05-23 18:48ngarciaFile Added: FilterByPath.png
2018-05-23 18:48ngarciaResolution time => 1528840800
2018-05-23 18:48ngarciaFile Added: FilterByColumn.png
2018-05-23 18:49ngarciaIssue Monitored: networkb
2018-06-01 14:27caristuIssue cloned0038688
2018-06-01 14:27caristuRelationship addedrelated to 0038688
2018-06-01 14:27caristuResolution time1528840800 =>
2018-06-01 14:27caristuTypedefect => design defect
2018-06-01 14:30caristuNote Added: 0104880
2018-06-01 14:30caristuStatusnew => acknowledged
2018-06-01 14:31caristuSummaryFilter is showing all the records available in the instance instead of only the ones available in the table the cube is based on => Filter is showing different records depending on how the dimension is built
2018-06-01 14:31caristuDescription Updatedbug_revision_view_page.php?rev_id=17238#r17238
2018-06-01 14:31caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17240#r17240
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0104880)
caristu   
2018-06-01 14:30   
Moved to design defect. This behavior is happening because of how the cubes are being generated by the Mondrian4SchemaGenerator.

For derived properties the dimension is built by joining the properties, causing to show just the records present in the source table.

This change implies a refactor in the cube generation that should be handled as a project instead of a regular issue.