Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Data Set using data base tables and views in Visual Analyzer (OAS-5.5 DV)

Received Response
4
Views
1
Comments
Sangeeta Pandey
Sangeeta Pandey Rank 6 - Analytics Lead
edited Aug 13, 2024 5:13PM in Oracle Analytics Cloud and Server

Hello Experts,

I am trying to create Data Set using data base tables and views in Visual Analyzer (OAS-5.5 DV) like depicted in screenshot in below. I have created connector for Oracle Database. Is it true that I can add only one table in this data set? I need to have a data set with multiple tables and views.I know one way to accomplish this- write a sql query using tables and views and use Enter SQL option. However wanted to seek experts opinion if I can select columns from multiple tables/views as well to create such data set.

Thanks,

Answers

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    I got the answer and sharing here with hope , it may be usefull for others with similar queries. Multi table select option is only available from OAC 6.1 version onward. OAS 5.5 is not having this feature in drag and drop mode.