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

Ability to User BI report as DV Source

User_T7OA6

Organization Name

Navigate Consulting

Description

Currently Data Visualization Data sets allows only a Logical SQL to be used as Source. But Giving direct link to a existing BI report is still lacking. As giving Logical SQL is prone to Errors, and for a business user, it will be even more difficult, Ability to point to a BI report to use it as Source for Data Visualization Data set becomes an important Enhancement. It can enhance user experience by Leaps and bounds.

Use Case and Business Need

Inability to use BI report as source for Data Set.

Original Idea Number: 94668c2537

Find more posts tagged with

Delivered

Reporting

Data Connectivity

Analysis and Data Visualization

Status: Delivered

Comments

TimVlamis

I believe that you can do this now. Create a new connection to an "Oracle Application" and put in the credentials and connection information for connecting to your OBIEE or OAC instance. You should be able to connect to an analysis in the catalog. This would be similar to creating a connection from BI Mobile HD app back to your instance. Then navigate to the "analysis" link when you create a new data set. Hope this helps.

Lakshmi Sampath-Oracle

This is a very critical feature as it will help in building Analytic Dashboards with drill down capabilities to the cloud instances.

Bret Grinslade - Oracle Analytics-Oracle

Raghunandan Vellanki, did you try Tim's approach?

Michal Zima

Hi,

juts jumping into discussion:

Tim Vlamis recomendation is a kind of a little bit "dirty" workaround, which fills the gap in product. (like scraping with right hand on left ear.).

Why should I create connection of "Oracle Application" to the same OAC/OAS instance, I am currently working on ? It should be the native funtioality - similar to beiing able to create DV project based on Subject Areas, I have access to (on the same OAC/OAS instance). We want to leverage integration of both worlds (tradinitial OBIEE with metadata and DV self-servicing) using the same user login, not to have to create "dummy" connection to the same OAS/OAC instance I am working on.

Thanks and kind regards

Michal

User_T7OA6

Thanks for Comments. I did try the approach of Vlamis now. And it works. Its one way of doing it. Great!

However, i agree with Michal zima. When DV and BI are on same instance, they both should be able to directly talk to each other. DV should also be able to browse through the catalog and Pick the report. It should ideally be one of the options as soon as you set off to create the Dataset.

Hope all agree to it.

Thanks

Raghu

TimVlamis

I agree with Michal and Raghu regarding integration of "Classic Analyses from Answers" and DV. I believe that Oracle is working on this as part of the plan moving forward. It's actually a bit confusing right now with the different capabilities and features with different kinds of data sources ("External Subject Areas" which are uploaded data sets and "Local Subject Areas" which are subsets of Subject Areas defined as Logical SQL.) This also gets a bit confusing with the security and access privileges defined separately. I believe that there are good reasons why all of this has been designed the way it has (everything from GDPR to how data frames are addressed). We've heard that there are some major new features, functionality, and tools coming out in terms of how data models are built and managed in OAC and data sources are defined and managed. In the meantime, I think we have to help each other figure out the workarounds. What I'd love to see is an official "capabilities matrix" from Oracle showing what can and cannot be done with different types of data sources. In other words, Explain works with externally uploaded data sets but not Subject Areas. Subject Areas can have access centrally managed but not externally uploaded data sets. Correlation matrix visualization only works with these kinds of data sets, etc. Might have the list of data sources on the X axis and the system features on the Y axis. Let us know if anyone knows if something like this exists!

Michal Zima

Hi Tim,

thanks for your answer - I agree, that Oracle is moving in right direction, but still plenty of work to do to be able to catch the rest of the analytics word - hopefully another progress will be visible quite soon.

Rgds

Michal

Gabby Rubin-Oracle

This is what is possible today (and why)

Local Subject Areas are accessible directly via DV, there is no need to create a data set.
Oracle Application connector (probably poorly named) is meant to allow access for users of OBI content (local or remote) and be able to create data sets based on them. This method allows access to both metadata as well as catalog artifacts.
Local Subject Area is just a predefined connection to the local subject area. It is meant to simplify the process for the user by eliminating the need to create a connection and focus on data access.

TimVlamis

Thanks, Gabby. Sorry I forgot this feature was already there.

Here's how to an existing "classic answers analysis" as a DV project in OAC. Go to the catalog and navigate to the analysis. Click the hamburger menu (or "more" dropdown in the classic catalog) and select "explore as project". It'll open the subject and populate a visualization with the included columns. I believe this is also included as a feature in the newly released OAS 5.5

Gabby Rubin-Oracle

Thanks for highlighting it. True, it was introduced in 5.5, but I see it as a bit different as it relates to the original response as it does not use the analysis as a data source - i.e. create a data set, it connects to the subject area and tries to recreate the analysis as a DV visual. It is another way/option to achieve it, should've added it to the options above.

The same capability is available from the Analysis itself (was there for a long time).