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

please expand pivot charts in visual builder to not only rely on numbers for value fields
I'm trying to build a calendar of work in visual builder that I can add to the Maintenance Management Landing Page. Unfortunately visual builder seems to only allow number format into the Values section. e.g. below trying to add this string (work due) to the display values, which it doesnt allow. I am doing the exact same…
Allow Administrators to Restrict or Hide the Seeded Common Content Folder in Shared folders
The seeded Common Content folder under: /Shared/Common Content is visible to BI users, including users assigned the seeded BI Consumer Role. We would like to restrict the visibility and access to this seeded folder for end users based on our organization's reporting security requirements. Currently, the BI Consumer role…
Allow Administrators to Restrict or Hide the Seeded Common Content Folder in Shared folders
The seeded Common Content folder under: /Shared/Common Content is visible to BI users, including users assigned the seeded BI Consumer Role. We would like to restrict the visibility and access to this seeded folder for end users based on our organization's reporting security requirements. Currently, the BI Consumer role…
Allow Administrators to Restrict or Hide the Seeded Common Content Folder in Shared folders
The seeded Common Content folder under: /Shared/Common Content is visible to BI users, including users assigned the seeded BI Consumer Role. We would like to restrict the visibility and access to this seeded folder for end users based on our organization's reporting security requirements. Currently, the BI Consumer role…
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…