Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028422
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Modules] Analyticsmajoralways2014-12-16 12:562022-02-28 13:51
ReporterngarciaView Statuspublic 
Assigned ToTriage Omni WMS 
PriorityimmediateResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0028422: 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"
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0029303 newAugustoMauch It would be fine to be able to clean the cache of a saved query without needing to refresh the cubes in OB Analytics 

-  Notes
(0073946)
Sandrahuguet (developer)
2015-01-30 13:32
edited on: 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();


- Issue History
Date Modified Username Field Change
2014-12-16 12:56 ngarcia New Issue
2014-12-16 12:56 ngarcia Assigned To => mtaal
2014-12-16 12:57 ngarcia Resolution time => 1418857200
2014-12-16 12:58 ngarcia Issue Monitored: networkb
2014-12-23 13:39 caristu Priority urgent => immediate
2015-01-12 11:00 caristu Assigned To mtaal => AtulOpenbravo
2015-01-30 13:27 Sandrahuguet Type defect => design defect
2015-01-30 13:32 Sandrahuguet Note Added: 0073946
2015-01-30 13:32 Sandrahuguet Note Edited: 0073946 View Revisions
2015-04-23 13:04 ngarcia Resolution time 1418857200 =>
2015-06-03 11:06 ngarcia Relationship added related to 0029303
2017-06-07 09:27 ngarcia Assigned To AtulOpenbravo => Triage Finance
2022-02-28 13:51 vmromanos Assigned To Triage Finance => Triage Omni WMS


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker