How to Make a Union For Specific Queries? (Doc ID 759477.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version: 9.2.0.3.00 and later   [Release: 9.2 and later ]
z*OBSOLETE: Microsoft Windows Server 2003

Goal


Is it possible to make a union of the following queries with Oracle database and Interactive Reporting Studio?

query1 :
SELECT TABLEA.*, sum(TABLEB.COLUMN2)
FROM TABLEA, TABLEB
WHERE TABLEA.COLUMN1 = TABLEB.COLUMN1

query2 :
SELECT TABLEA.*, 0
FROM TABLEA

query3 :
SELECT TABLEA.*, 0
FROM TABLEA, TABLEB
WHERE TABLEA.COLUMN1 = TABLEB.COLUMN1

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms