Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

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

Received Response
21
Views
1
Comments
Asha Yadav
Asha Yadav Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

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

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics & AI Coach
    edited Sep 16, 2024 7:23AM

    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.

    image.png

    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.