Union Reports build in OAC Data Visualization

User_PW5NK

Hi Team,

We have a requirement from Client to build Union reports, we know that its possible to build Union report in OACS Classic Home, but we wanted to know is it possible to build Union report in DV using same Subject area.

Please let us know we need to do any configuration or parameters changes to achieve union report in DV(Within the same subject Area).

Appreciate your inputs/suggestions

Gianni Ceresa

I would say that right now you can't do it directly, not as easy as "classic" can do it.

The workaround would be to make your union in a dataset. Just be fully aware of the possible issues and downsides of having a dataset just for a union.

There is an idea you can upvote to add that feature: https://community.oracle.com/products/oracleanalytics/discussion/19322/option-of-creating-dv-workbook-based-on-combination-union-intersection-of-subject-areas-in-oac

Wayne Van Sluys

One option is to create a new dataset via Data Flow. There is Union within Data Flow