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

Question

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

NikhilYadav · Answer

thanks for the help!

RVohra · Answer

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!