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

Enable EVALUATE function for OTBI reporting

Kamran Butt-161785

Organization Name

City of Hollywood FL

Description

We have reporting needs that require us to use the EVALUATE function. Since we do not have access to the RPD and certain columns or formatting is just not available in OTBI, we need this function turned on for a select group of super-users. It is possible that other Fusion Cloud users would also find this beneficial as well.

Please vote to have EVALUATE enabled for certain super-user accounts. We used to be able to do this ourselves by editing the NQSConfig.ini file in the on-prem OBIEE.

Use Case and Business Need

To use database functions that are not available OTBI, which will assist with fulfilling reporting needs.

Original Idea Number: aaa6fcafb1

Find more posts tagged with

Submitted

Security

Administration

Analysis

OTBI

Status: Submitted

Comments

Glen Ryen

This would add a lot of capability to OTBI, upvoting.

Ellen Manthei

This would be a huge help in allowing OTBI reports to provide back a single row of information instead of multiple rows where other functions don't provide the same results or flexibility.

SantoshKumarBhairi

this helps to overcome many restrictions within OTBI.

Murthy Kodavati

Much needed.

Hubert Winter

Agree with everybody. This is really much needed and not difficult to enable for Oracle.

bbci_BeverlyBaker

an absolute must have if OTBI is the recommended reporting tool moving forward. We need to have the ability to extend beyond basic logical SQL and OTBI based functions to create comprehensive, enterprise level analytics. Access to listagg and regexp alone would change our reporting game - Come on Oracle, it is time to let this tool do all it was intended to do.

A.JOSH

Indeed, must have. Upvoting.

Mårten Wendel

Agree with all! LISTAGG is very much needed if OTBI is to be of value for the business! Please Oracle add this in upcoming release!

Yechiel

The otbi is an ill reporting tool its not friendly and very much unpredictable to use. Enabling this otion might make it better

Ron van Wolferen

for Strategy review:

pls acknowledge the omission in functionality discussed in this tread.

Deloitte encounters this issue at multiple implementation projects where client for instance has a simple requirement to report on ISO week level in OTBI reporting tooling

rewriting physical SQL "to_char(<date>,'IW')" functionality to Logical SQL with all its limitations is no feasible way forward (particularly for business end-users creating reports from self service perspective)

pls consider to have EVALUATE function enabled trough SR request

( Currently, OTBI will not allow for evaluate function to be leveraged ==> [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000) )