Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion ERP Analytics

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
21
Views
2
Comments
NikhilYadav
NikhilYadav Rank 1 - Community Starter
in Oracle Fusion ERP Analytics

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

Tagged:

Answers

  • RVohra
    RVohra Mod

    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
    NikhilYadav Rank 1 - Community Starter

    thanks for the help!