Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- 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