Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Building a union report option via subject area is missing OAC DV.

Received Response
20
Views
3
Comments
Bala.01
Bala.01 Rank 3 - Community Apprentice
in Oracle Analytics Forum

Building a union report option from Subject Area is missing OAC DV. Please guide how to create a union report in DV

Answers

  • Wayne Van Sluys
    Wayne Van Sluys Mod

    Use Data Flow and create a dataset

  • Bala.01
    Bala.01 Rank 3 - Community Apprentice

    We have data level security that is built in the RPD, and there are multiple dimensions/attributes used as prompt filters, We also have 6 yrs of data. Hence, Dataflow is not helpful. We need the data to be dynamic based on the filters selection

  • Chere-Oracle
    Chere-Oracle Rank 6 - Analytics & AI Lead

    You should be able to use a logical SQL query for your dataset. If you built a union query in classic Answers, its logical SQL can be copied from it and then pasted into a manual query in DV. Instead of pulling the subject area into your dataset, pull "Manual Query" into the dataset and paste the logical SQL into its Definition screen. Alternately, if you have already pulled the subject area into the dataset, go to Edit Definition and change the selected radio button from "Select Columns" to "Enter Logical SQL"; here you can paste (or type) the logical SQL for your union query.