Option of creating DV workbook based on combination(union,intersection) of subject areas in OAC

Deepa Mohan

Hi ,

There is a requirement of creating a DV workbook using union of functional subject areas to get a complete picture of the data. Currently this is satisfied in the Classic version. But since the visualizations are not very interactive as in DV , this is a show stopper .

Rajakumar Burra

It is very much needed functionality.

Indranil Basak-Oracle

Hi Deepa,

I hope you are looking for union of Two subject area into DV. As current in DV might challenge. One workaround designs a dataset through logical sql which will be union logical query. Then design a workbook through dataset.

Hope this solution will work for you.

Thanks

Indranil

Rajakumar Burra

Workarounds have different issues.

• Performance
• Datsize
• Maintenance

Indranil Basak-Oracle

Agreed Rajkumar, If any update into logical sql that definitely required maintenance. But as current features of OAC this might be one possibility of solution.

Deepa Mohan

Hi Indranil ,

I tried doing it as you said - creating dataset with logical SQL and this is working fine . This approach is ok if this is an individual report by itself . In our case this is just a subset of a larger requirement

One thing i noticed is that all the date columns are considered as text and because of this sorting is not working. Also this is causing other problems where we need to join this dataset with other subject areas. The date(text type) fields are not listed when trying to create a join with another subject area

Jayko Paten

Where are you creating the logical sql? In a workbook or a dataflow/dataset?