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

View BI Data model query and results in one single editor like SQL Developer.

kmanda

Description

Create a DM > Data set > Query > Enter your query > when you view data > you will not be able to see the query and results at the same time.
Original Idea Number: 764a0de3d6

Find more posts tagged with

Submitted

Analysis

BI Publisher

BI Publisher Data Models

OTBI

Status: Submitted

Comments

Mark R Johnson

Great idea! This is a common complaint I hear from a lot of our consultants too.

User_0MEFO

Fabulous idea! This would be a huge help!

Jon Hayes

Great idea!

Rupa T

Very much needed. I have seen that there are tools available internally to Oracle that works like sqldeveloper. It would be great if that (or some version of that ) can be extended to customers also, as many a times, we need to do a lot of queries for problem analysis and data analysis.

Thiru Ch

Good Idea!

Félix B.

This is a great idea! Definitely better than having a notepad open, taking note of the column names and then updating your query every single time!

Jairo Rojas Méndez

Good Idea!

Purnachandra Rao

Yes. Good Idea.

Mark_Daynes

Great Idea. A full SQL Developer interface to allow for developing, tuning, etc would be ideal.

1.0.0.20

Ravi Shinde

Great Idea!!!

Top Leaders

Top Ideas

Clarification/Correction of Identifying PO Field in Payables Invoices-Transactions Real Time SA OTBI
Issue Description The Identifying PO field is a header-level attribute, but it is currently displayed under Distributions → Invoice Distribution Details → Purchase Order Information in the Payables Invoices – Transactions Real Time subject area. When an invoice has multiple POs, the same header-level PO can be repeated…
Provide Email Delivery and Bounce Status Tracking for BI Publisher Bursting Emails
BI Publisher bursting currently reports an email delivery as successful once the email has been processed and sent from Oracle. However, there is no customer-accessible functionality in Oracle Fusion/BI Publisher to determine whether the email was subsequently delivered, rejected, bounced, or returned as undeliverable by…
Copy functionality for reports to be granted independently within report security permissions
ERP: Ability to provide copy functionality for reports within report security permissions or manage privileges without providing full edit / write access. Currently, it does not appear that 'copy' access can be given independently.
FDI report/object security to grant Copy as an independently grantable permission
FDI: Ability provide copy functionality for reports within report security permissions or manage privileges without providing full edit / write access. Currently, it does not appear that 'copy' access can be given independently.
Restriction of Data Source in reports and analytics while creating Data Model
Currently any user account having access BIPDataModelDeveloper role is providing the ability to see any sensitive information in the Oracle fusion irrespective of data restrictions placed in the front end through role assignments. User while creating a data model can see any HCM data like (Payroll details, DOB, SSN, etc.)…