I am looking for tutorial where we create Report using 2 subject areas using union all operator

Asha Yadav

I am looking for tutorial where we create Report using 2 subject areas using union all operator

Nathan CCC

Hi,

In your analysis in OTBI you press this button here "Combine results based on …".

The number and data type of columns in all query must match. Select the row in the result columns to edit each query. Remember to add filters on each query. Select Result Columns to manage the combined columns.

For more information read the manual

Oracle® Fusion Middleware
User's Guide for Oracle Business Intelligence Enterprise Edition
12.2.1.4.0 E91522-03 September 2020
Combining Columns using Set Operations

https://docs.oracle.com/html/E91522_03/GUID-EF3F4409-A734-4FD9-9967-8F027FACAEDB.htm#GUID-A6B1FE7C-24AD-432D-A934-718B4CFA8DC1

If as you say for some reason you want to create a report in OTBI on this data, then create a data model with a data set either i) of type Analysis that refence the path to your analysis above then keep the analysis or ii) cut paste the logical sql from the advanced tab of that analysis to a data set of type SQL Query with data source Oracle BI EE then delete the analysis.