Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 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
Using oracle HINT in an Analysis
PeregoD
Rank 3 - Community Apprentice
It would be nice to be able to add Oracle's HINT in the Advanced tab of an Analysis.
1
Comments
-
In advanced tab of analysis definition, there is Logical SQL refered (passed to BI Server - as execution engine - translating logical SQL into physical SQL statement), it is not physical SQL statement, where you can use hints for forcing execution of physical SQL against Oracle DB - so your requirement does not make much sense.
But if your analysis is built on top of Subject Area (thus semantic model in metadata) you have the option in physical layer in metadata to place Hint in particular physical table definition (if you DB is Oracle DB). So this can satisfy your requirement.
0
