Is it possible to do nested aggregation in single calculation?

Anirban1

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

[Deleted User]

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

You may want to start by looking at level-based measures:

https://gerardnico.com/dat/obiee/obis/measure_level_based