Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028422ModulesAnalyticspublic2014-12-16 12:562022-02-28 13:51
Reporterngarcia 
Assigned ToTriage Omni WMS 
PriorityimmediateSeveritymajorReproducibilityalways
StatusnewResolutionopen 
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
Summary0028422: Data could be seen in Dimensional Reports window although the role doesn't have access to the table
DescriptionData could be seen in Dimensional Reports window although the role doesn't have access to the table
Steps To ReproduceAs group admin role:
   Create an Advanced role
   Provide it with access to the OBANALY_SaikuView View Implementation
   Assign it to Openbravo User
   Go to OB Analytics window, create a report and save it
   GO to Analytics Queries window and publish it
   Check you could get the data in the Dimensional Report window
   Remove the access to the previously created role to the table the Cube is based on (Role Access window)
   Log in with that role
   Check you could get the data in the Dimensional Report window which is wrong
   Go to OB Analytics window and refresh the Cube combo, the Cube is not present any more
   Check you couldn't get the data in the Dimensional Report window getting the message "Error Loading Query"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0029303 new AugustoMauch It would be fine to be able to clean the cache of a saved query without needing to refresh the cubes in OB Analytics 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-12-16 12:56ngarciaNew Issue
2014-12-16 12:56ngarciaAssigned To => mtaal
2014-12-16 12:57ngarciaResolution time => 1418857200
2014-12-16 12:58ngarciaIssue Monitored: networkb
2014-12-23 13:39caristuPriorityurgent => immediate
2015-01-12 11:00caristuAssigned Tomtaal => AtulOpenbravo
2015-01-30 13:27SandrahuguetTypedefect => design defect
2015-01-30 13:32SandrahuguetNote Added: 0073946
2015-01-30 13:32SandrahuguetNote Edited: 0073946bug_revision_view_page.php?bugnote_id=0073946#r7569
2015-04-23 13:04ngarciaResolution time1418857200 =>
2015-06-03 11:06ngarciaRelationship addedrelated to 0029303
2017-06-07 09:27ngarciaAssigned ToAtulOpenbravo => Triage Finance
2022-02-28 13:51vmromanosAssigned ToTriage Finance => Triage Omni WMS

Notes
(0073946)
Sandrahuguet   
2015-01-30 13:32   
According to Martin and David Miguelez this issue should be moved to design defect.

Proposed solution:
The way to solve it is to create an event handler which listens to role/role access changes and then does this call:
MondrianSchemaHandler.getInstance().clearCache();