nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Rajakumar Burra

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.

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Bret Grinslade - Oracle Analytics-Oracle

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

Rajakumar Burra

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

@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.