Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

In Properties panel , "Display As" should have one more option "Running Sum".

Needs Votes
11
Views
3
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server Idea Lab

In Properties panel , "Display As" should have one more option "Running Sum". It will help in creating additional calculations.

Most of the time, it will help is Display of "Aggregating Sum values" and display them as "Running Sum".

This is already available in OBIEE classic.


image.png


5
Up
5 votes

Needs Votes · Last Updated

Comments

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    Is using RSUM as a calc in this scenario a reasonable work around?

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    Not always. It is faster to sum in a column with row by row instead of performing multiple calculations.

    It needs some extra work and also noticed performance in additional calculations in below scenarios.

    • Count Distinct and display as Running Sum is faster than RSUM ( Count (distinct XYZ))
    • Sum the Values by specific ID and display as Running Sum is faster than RSUM ( Sum XYZ by XXXX)

    Many times, I noticed in OBIEE, display is Runnign Sum gave correct values but RSUM gave some wrong values. To match values , I need to modify expression which took much time.

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    @Rajakumar Burra I understand your point and I like your idea (I was about submitting something similar).

    @Bret Grinslade - Oracle Analytics-Oracle : Using RSUM as a calculation is a reasonable workaround when you have to do it only once (1 column in 1 workbook). But I would prefer a better approach for when I have to do it for 3-4 measures and multiple workbooks.

    IMO it makes sense to include running aggregate functions to the Aggregation Method property rather than to Display As. Moreover, running aggregate options should be included when you right-click on a measure in the grammar panel, so you don't have to switch back and forth to the Properties panel.