Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Ability to User BI report as DV Source
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
Comments
-
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.
0 -
This is a very critical feature as it will help in building Analytic Dashboards with drill down capabilities to the cloud instances.
0 -
Raghunandan Vellanki, did you try Tim's approach?
0 -
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
0 -
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
0 -
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!
0 -
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
0 -
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.
0 -
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
0 -
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).
0
