For reference, we are using 11.1.1.9.0.
I am trying to create an analysis combining two subject areas with a union. Columns A and B come from Subject Area 1, and columns B, C, and D come from Subject Area 2. The subject areas have only column B in common. When I try to do a union, the report creates separate rows for the columns that do not align (ie. there is a row for data within columns A and B, and then another row for data with columns B, C, and D.) I created dummy columns to join the subject areas, but am having no success. Any suggestions would be highly appreciated.
Update: I believe the issue is similar to that described here (https://community.oracle.com/thread/3567836), but I cannot find a workaround for the issue.