How to apply group by on a column in OTBI in Oracle Fusion Cloud?

NikhilYadav

Hi everyone,

I am working with OTBI in Oracle Fusion Cloud and I need to group by Creation Date (Subject Area → "- Supplier Organization"."Creation Date")

• one aggregated measure - SUM(Number of Suppliers)
• one non-aggregated attribute - Creation Date

TIA,

Nkhil Y

RVohra

In the Subject Area, you need to use Calculated Measure. High level steps are:

In OTBI Analysis , Create a New Calculated Measure:

Click on the "+ New Calculated Measure" button.

Define Your Measure:

Name: Give your new measure a descriptive name (e.g., " Number of Suppliers").

Formula: Use the Expression Editor to build your formula.

Add Columns: Drag or insert columns like "Supplier Number"

Use Functions : Count() or SUM()

Apply and Save: Click OK, then save your analysis. 

Hope it helps!

NikhilYadav

thanks for the help!