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 AI and Analytics

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.

Top Leaders

Tarik Branković 45

User_IG5IB 32

Michal Zima 32

Siva Pratap Nellipudi-Oracle 29

SantoshChandrasekaran 18

Top Ideas

Increasing Report Results limit from 5000 to the full report results data set
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Provide proactive notification of bug fixes/patches that change API response behavior, before deploy
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
Granular permission for Session and Query Logs (Manage Sessions) independent of BI Service Administr
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
OAS Certified Data Source (DB2) Enhancement Request
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
MCP restriction/ tool restrictions to OAC user groups
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.