Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038688ModulesAnalyticspublic2018-06-01 14:272018-06-08 12:55
Reportercaristu 
Assigned Tocaristu 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Support ticket
OBNetwork customer
Regression introduced in release
Summary0038688: Filter is showing more records than expected for some dimensions
DescriptionFilter is showing more records than expected for some dimensions
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:
   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 OB Analytics window and select 'Sales Details Fact Cube'
   Add Sales Representative in Filter
   Check that more records than expected are shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0038609 acknowledged Triage Platform Base Filter is showing different records depending on how the dimension is built 
causes defect 0039148 closed caristu Data is not shown in report. An error is raised 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-06-01 14:27caristuNew Issue
2018-06-01 14:27caristuAssigned To => caristu
2018-06-01 14:27caristuResolution time => 1528840800
2018-06-01 14:27caristuIssue generated from0038609
2018-06-01 14:27caristuRelationship addedrelated to 0038609
2018-06-01 14:33caristuSummaryFilter is showing more records that expected for some dimensions => Filter is showing more records than expected for some dimensions
2018-06-01 14:33caristuDescription Updatedbug_revision_view_page.php?rev_id=17242#r17242
2018-06-01 14:44hgbotCheckin
2018-06-01 14:44hgbotNote Added: 0104881
2018-06-01 14:44hgbotStatusnew => resolved
2018-06-01 14:44hgbotResolutionopen => fixed
2018-06-01 14:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/179ac60fc8a4d998b0d77807f25dabb014ecdc5a [^]
2018-06-01 14:44caristuReview Assigned To => alostale
2018-06-08 12:55alostaleNote Added: 0105036
2018-06-08 12:55alostaleStatusresolved => closed
2018-08-22 12:00ngarciaRelationship addedcauses 0039148

Notes
(0104881)
hgbot   
2018-06-01 14:44   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 179ac60fc8a4d998b0d77807f25dabb014ecdc5a
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Jun 01 14:34:15 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/179ac60fc8a4d998b0d77807f25dabb014ecdc5a [^]

fixes bug 38688: Filter shows more records than expected for some dimensions

  Note that even if the source table of a dimension has the access level ALL, the client filter must be added.

---
M src/org/openbravo/client/analytics/mondrian/Mondrian4SchemaGenerator.java
---
(0105036)
alostale   
2018-06-08 12:55   
reviewed