Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029303ModulesAnalyticspublic2015-03-16 18:552015-03-16 20:23
Reporterngarcia 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
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
Summary0029303: It would be fine to be able to clean the cache of a saved query without needing to refresh the cubes in OB Analytics
DescriptionIt would be fine to be able to clean the cache of a saved query without needing to refresh the cubes in OB Analytics
Steps To ReproduceAs group admin role:
   Go to OB Analytics window and select the Sample Purchase/Sales Order Line Cube
   Add Ordered Quantity measure in Columns
   Add Product dimension in Lines
   Save it
   Go to Analytics Queries window and select the Publish checkbox
   Go to Dimensional Reports window and launch it
   Check the quantity of a product
   Create a sales order for that product and book it
   Go to Dimensional Reports window and launch the report again
   Check the quantity is not updated
   Go to OB Analytics window and refresh the cubes
   Go to Dimensional Reports window and launch the report again
   Check the quantity is updated
   
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0029402 closed platform Analytics does not work as real time reporting component 
related to design defect 0028422 new Triage Omni WMS Data could be seen in Dimensional Reports window although the role doesn't have access to the table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-16 18:55ngarciaNew Issue
2015-03-16 18:55ngarciaAssigned To => mtaal
2015-03-16 18:55ngarciaIssue Monitored: networkb
2015-03-16 18:56ngarciaSummaryIt would be fine to be able to clean the cache of a saved query => It would be fine to be able to clean the cache of a saved query without needing to refresh the cubes in OB Analytics
2015-03-16 18:56ngarciaDescription Updatedbug_revision_view_page.php?rev_id=7998#r7998
2015-03-16 20:23mtaalNote Added: 0075663
2015-03-16 20:23mtaalAssigned Tomtaal => AugustoMauch
2015-06-03 10:38ngarciaRelationship addedrelated to 0029402
2015-06-03 11:06ngarciaRelationship addedrelated to 0028422

Notes
(0075663)
mtaal   
2015-03-16 20:23   
The solution direction:
- add a field to stored queries which says: fill/use cache, the default should be Y for this new column
- then in the query execution try to find out if a query can be executed without using the cache or by first clearing the cache for the specific cube.