Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Is it possible to do nested aggregation in single calculation?

Received Response
5
Views
1
Comments
Anirban1
Anirban1 Rank 4 - Community Specialist
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

Hi,

I have a requirement as follows -

In reporting layer we have used, Rsum(cost by Product)/Sum(cost by Product).

Is it possible to do the same thing in RPD Layer ? I have tried with logical column formula, but it is giving error while doing consistency check. I am using OBIEE 12c.

Thanks

Anirban

Answers