nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Using oracle HINT in an Analysis

PeregoD

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

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Michal Zima

@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.