Oracle Fusion ERP Analytics

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

Categories

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
15
Views
1
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 Rank 7 - Analytics & AI Coach

    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!