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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029303
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Modules] Analyticsmajoralways2015-03-16 18:552015-03-16 20:23
ReporterngarciaView Statuspublic 
Assigned ToAugustoMauch 
PriorityurgentResolutionopenFixed 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

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

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0029402 closedplatform Analytics does not work as real time reporting component 
related to design defect 0028422 newTriage Omni WMS Data could be seen in Dimensional Reports window although the role doesn't have access to the table 

-  Notes
(0075663)
mtaal (manager)
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.

- Issue History
Date Modified Username Field Change
2015-03-16 18:55 ngarcia New Issue
2015-03-16 18:55 ngarcia Assigned To => mtaal
2015-03-16 18:55 ngarcia Issue Monitored: networkb
2015-03-16 18:56 ngarcia Summary It 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:56 ngarcia Description Updated View Revisions
2015-03-16 20:23 mtaal Note Added: 0075663
2015-03-16 20:23 mtaal Assigned To mtaal => AugustoMauch
2015-06-03 10:38 ngarcia Relationship added related to 0029402
2015-06-03 11:06 ngarcia Relationship added related to 0028422


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker