Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Need a way for XSA query generated by the workbook to be cached
Shady Labib-Oracle
Rank 3 - Community Apprentice
OAC workbook connected to Essbase takes several minutes to open the first time a user accesses it, subsequent calls run faster.
This is because XSA queries for Essbase creates an RPD internally. Hence first execution of the query takes time.
AS for now, there is no way for the XSA query generated by the workbook to persist in cache.
The workaround is to create an RPD with a Essbase connection and using that since the default RPD is always in cache.
2