Using oracle HINT in an Analysis — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Using oracle HINT in an Analysis

Needs Votes
21
Views
1
Comments
PeregoD
PeregoD Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server Idea Lab

It would be nice to be able to add Oracle's HINT in the Advanced tab of an Analysis.

1
Up
1 votes

Needs Votes · Last Updated

Comments

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    @PeregoD

    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.