nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Remove/Disable aggregation from OAS Analysis for a query

Arka Mukherjee

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.

Find more posts tagged with

Analysis and Data Visualization

Needs Votes

Status: Needs Votes

Comments

Arka Mukherjee

Please take this up and update if possible.

Alan Lee - Oracle-Oracle

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

Arka Mukherjee

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.