Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Remove/Disable aggregation from OAS Analysis for a query

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Vodafone
Description (Required): When creating an analysis in OAS using SQL query, the columns are being aggregated(single row) by itself. The same query shows multiple rows as output when using OAS DV or in SQL Developer. The option 'Suppress Repeating Values' which is present in DV, something like that should be present in Analytics as well.
Use Case and Business Need (Required): The requirement is for end users in our project, who want to use only analysis to get results.
Enhancement Request / Service Request: SR 3-29306650581 : Remove/Disable aggregation from OAS Analyis for a query, this SR was raised with Oracle Support, enhancement idea was suggested as no permanent solution could be found. We would like to have this implemented.
Comments
-
Please take this up and update if possible.
0 -
When you say Analytics, I assume this is Classic Analysis. There are some workarounds to do so if this is the case.
0 -
Hi Alan,
We are trying these in OAS 5.9 Analytics console and we tried some of the workarounds as suggested by Oracle support as part of SR 3-29306650581. However, as per our end users, the feature to disable/remove aggregation or something similar in OAS DV, should also be there in Analytics console as an option and not as a workaround. So, oracle support suggested us to raise an idea/enhancement request for this.
0