Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Inspecting the stored data blending joins of a data set and allowing multiple joins from same column

Delivered
11
Views
2
Comments
User_GL5YJ
User_GL5YJ Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

Organization Name

Skanska

Description

Me and my colleagues would very much appreciate an easy way to see all the stored blending connections/joins of a data set. For example in the Inspect Data Set dialog there could be a tab for it. It should contain the data set columns that have stored/pre-defined joins to other data sets. Preferably there would be a way to delete unwanted joins, and to have multiple joins (to different data sets) from one column. The only way I've achieved the latter is to duplicate the column.

Thanks, 

Jon

Use Case and Business Need

A customer user typically has data sets that are shared with other users. Allowing multiple joins to other data sets, and a possibility to administer them, would make it possible to share data sets better without deleting each others joins.

More details

User A might want to join this shared data set to data set X whereas user B wants to join the same data set to data set Y. And they want to do it from the same column. This is apparently not possible at the moment. The last saved join will win. This behavior is not intuitive. Especially when you cannot see the joins of a data set other than in the project view. You will then believe the project stores the join, which is not the case.

Original Idea Number: 1d89df324a

Tagged:
2
2 votes

Delivered · Last Updated

Addressed in OAC with the capability to add multiple tables to a dataset and the ability to define joins between the tables. There is a model diagram that shows the tables and relationships. This feature will be included in the next annual release of OAS.

Comments

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    Good observation of the user experience issue here.  What would be the benefits and challenges of having the blend data just stored with the project (vs dataset today)?

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    This is limitation of current OAS version (5.9) and OAC versions till 6.1 - where multi table data sets has been launched, which allows you to design "model" (tables with joins) in data prep phase and then leverage this multi table data set in multiple DV projects. With OAS , we have to live with this very uncomfortable limitation described in this idea. So looking forward to new yearly release of OAS with multi-table data sets feature included.