Categories
- All Categories
- 87 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 49 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Better control over BI Server caching for external (Db/file-based) data sets in OAS environment
Organization Name
CESKA NARODNI BANKA
Description
We are having DV projects based on external data sets from Oracle database (with having Data Access property set to "Live", since the data are quite volatile).
But even when using "Live" access, BI Server cache (not XSA cache) comes to play and logical queries for DV projects are cached (in BI Server cache - since we have Bi Server caching switched on - OAS environment is hosting plenty of existing Answers/Dashboards output based on metadata,leveraging BI Server cache) and subsequent users are served (instead of live queries to Oracle db) from BI Server cache.
This is for us really unwanted situation - we dont want DV project consumers (who are running the DV project in so called presentation mode - where there is no possibility to perform data refresh action - which clears/repopulates the BI Server cache) to be served from BI Server cache (showing stale data).
So our requirements for product enhancments are following :
1) To have the ability for external data set from database (with Data Access property="Live") or files to have a property (and beeing able to set it when creating/modifying data set), which is causing , that results are not cached in BI Server cache (similar to property "Cachable" in tables in physical layer of OBIEE metadata
2) To have the ability for DV projects (similar as for example for OBIEE analysis in Answers - by setting system session variable DISABLE_CACHE_HIT in Advanced tab in Asnwers) to set/define, that for particular DV project, BI Server cache will be bypassed
3) To have ODBC call similar to the known/documented ones - eg. SAPurgeCacheByDatabase - to be able to programatically purged BI Server cache for particular external data set
Use Case and Business Need
Those features are really a must for build DV projects vizualization for consumers, showing fresh data (not stale from BI Server cache) - thus making DV trusworthy data visualization tool (complementing already existing "traditional" BI world - Answers/Dashboards).
Original Idea Number: 0eb995f77e
Comments
-
I wonder, whether this Idea has ever been reviewed by Product Mgmt/Development. Could anybody pay attention, pls.
0 -
Upvoted
0
