Categories
Change behaviour of aggregation in table view
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):
Uponor Oyj
Description (Required):
In an analysis with unioned result sets OAS is not aggregating the rows as we would expect in the table view. The same data aggregates as expected in a pivot table view.
All columns are the same except one measure which only exist in one of the unioned result sets. In the second result set the same column is set to 0. The way the system behaves currently is that rows are aggregated and the value in the measure is summed in pivot tables. In a table view the same data results in two rows (one from each unioned result set) one showing the value 0 and the other showing the proper value from the result set with the measure.
Use Case and Business Need (Required):
This affects our users when they export data as unformatted. The system disregards features added in a pivot table and exports the same data as can be seen in the table view. The users would like to see the data aggregated also in the table view so they can use the unformatted data export as well as formatted.
Enha
ncement Request / Service Request: