Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 209 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Joining Dataset to Subject Area - Left, Inner, Outer Join Options

Purpose: create more robust data options with left, inner, outer join options when blending a dataset with a subject area.
Currently when blending a dataset with a subject area there is no option for what type of join. There is this option in the dataflow. We would like this option without having to do a dataflow.
Comments
-
Agreed - this would be a substantial improvement in the user experience for our organization as well.
0 -
Blends in OAC are based on a left join. This is because blending is often used for combining data sources that are not directly related. However, if you wish to use other types of joins, this is possible in the Dataset Editor, where all the common join types are supported between tables and LSAs. At this time, there is nothing planned in our roadmap to add additional join types to blending, however, if you could provide some examples of how this would improve your experience, it would help us explore some options.
2 -
Very helpful.
Thanks for the details @Luis E. Rivas -Oracle!
1 -
It would be useful to be able to choose the join type when the dataset is the primary driver and subject area data is used to enhance it. Left join would be fine if we could define the primary data source.
1 -
voted up.
0 -
Voted up for this. Whilst you can use other joins in the Dataset editor I find this is less intuitive for users to do for quick analysis and can also lead to a proliferation of datasets
0 -
+1 from me
0 -
+1
0 -
There are two features which are delivered.
For a workbook — you can control the Blend behavior (all row, etc.)
For a table or file with a Subject area Local Subject Area, you can create a dataset where you define an explicit join type. Between these two features, I think you can accomplish what is needed.
For Blending specifically — what can you not do?0 -
"For a workbook — you can control the Blend behavior" Is this a new feature? When blending a dataset and a subject area the only options are "Extend a dimension" or "Add facts". These are set automatically. The only other options are the join fields.
Yes, we can use datasets and dataflows to accomplish specific reporting needs but that requires editing the dataset any time additional measures or dimensions are needed. This is not ideal if datasets are shared.
0