Remove/Disable aggregation from OAS Analysis for a query — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Remove/Disable aggregation from OAS Analysis for a query

Needs Votes
143
Views
3
Comments

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.

1
1 votes

Needs Votes · Last Updated

Comments

  • Arka Mukherjee
    Arka Mukherjee Rank 3 - Community Apprentice

    Please take this up and update if possible.

  • When you say Analytics, I assume this is Classic Analysis. There are some workarounds to do so if this is the case.

  • Arka Mukherjee
    Arka Mukherjee Rank 3 - Community Apprentice

    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.